Help. I'm trying to write several tables (ESRI geodatabase, not file geodatabase), based on a csv on input tables to the identical schema on the output (ie SCHEMA1.TABLE1 -> SCHEMA1.TABLE, SCHEMA2.TABLE1 -> SCHEMA2.TABLE1). My latest attempt is to have connection files for each SCHEMA and generate an attribute with the path to the connection file, then in a featurewriter I set the connection file to be that attribute, but it's only using the first connection file path and ignoring others coming in. This process will expand to other tables in other schema's so I'm trying to make it as adaptable as possible.
Userlevel 4
- 8177 replies
-
25 April 2018
I suspect it's not possible to change the connection file during translation.
You may want to use a child workspace with the connection file as a parameter. You can then invoke the child workspace using either the WorkspaceRunner or the FMEServerJobSubmitter.
Userlevel 2
+16
- Contributor
- 2180 replies
-
25 April 2018
Can you use multiple FeatureWriters (one per connection file) and the based on the attribute (AttributeFilter) pass the features to the right FeatureWriter?
It seems a bit more work, but could be easier to maintain.
Depends on the number of different connection files.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.