span8
span4
span8
span4
你好,
I'm trying to create a dynamic workspace to create file geodatabase extracts of data out of ArcSDE.Ideally, I would like to make use of change detection in some form, so that data that hasn't changed doesn't get processed for no reason.Even more ideally, I'd like to query the database system tables to quickly narrow down what objects have experienced any change (I have some ideas on how to satisfy the second part, but haven't gotten to it yet).
The SDE extracts in FGDB form will end up on a network share and be replicated out to the users.
This article is pretty much what I want to do, I think.
https://knowledge.safe.com/articles/1157/dynamic-workflow-tutorial-destination-schema-as-a.html
I have to presume that I don't know the schema, nor the quality of the data, in an effort to make this flexible for the many SDE databases we're running this for.
My workspace looks like this:
Where I'm getting stuck, right now anyway, is applying the delete operation to rows that no longer exist in SDE.In specifying thefme_db_operationkeyword as the 'Feature Operation' method on the writer, I must supply criterion (which is part of the FGDB schema, it seems) so that the right rows are removed.Screenshot:
If the task here is to mirror an SDE database with any number of tables, all with different fields, how can I do this reliably?More frustrating: I have seen an example that uses Esri's Data Interop extension that doesn't seem to be restricted by this requirement, even though it's using the FGDB writer.
Am I missing something obvious here?
谢谢,
克里斯
你好@ chris2,
Thanks for your question!I believe you're on the right track in using the dynamic schema here.For where you're getting stuck, try setting the Row Selection to Match Columns by your primary key attribute.Check out the Mixed Operations section inthis article on Incremental Updatesthat uses the fme_db_operation for some more information on it.For setting up fme_db_operation, I'd also suggest taking a look throughthis articlewhich has a downloadable workspace template that might be helpful to reference even though they don't use the dynamic schema.Hope this helps a bit!
- Jo
感谢您的回复。有一个问题我想我的挑战是,我不知道我的主键提前。比方说,我复制周一10数据库表,周二有可能是十一点了,我什么都不知道的是十一表 - 字段名,钥匙,不知道。是这种灵活性可能吗?
谢谢,
克里斯
你好@ chris2,
我对响应的推移道歉,我也不太清楚,如果有可能不知道的主键。有办法避免测试架构,或匹配列...它可能会以测试列唯一值,但恐怕这是我的专长之外。你会开到发布针对这一特定问题的一个新的问题?它会打开它,并邀请来自社会各界的一些新的观点。亚搏国际在线官网对不起,我不能够提供关于这个具体问题更多的帮助。
© 2019 Safe Software Inc |Legal