Skip to main content
  • EN

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.

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.

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


Community Stats

30,108
Posts
114,293
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.