Skip to main content

Newb here, I'm using FME a lot for simple GIS feature class extraction, from source DB to a target DB, pretty straight forward. After many of these I'm thinking there must be a simpler way to map the source and targets.

Per image below, reader layers on the left and writer layers on the right, then I manually connect them. The writers are identical, no changes or alterations required, surely there is a way around the manual connecting of source/target.

You need a dynamic workflow. This can be set up easily using a FeatureReader and FeatureWriter. Connect the schema features to the featurewriter as well, check dynamic and you are good to go. If you search you will find the article explaining this.


Thank you for providing that direction!


Thank you for providing that direction!

Cheers. From the UC on mobile so a limited answer for now :)


HI Craig, the following article on About Dynamic Workspaces (safe.com) and a guide visual:

feature reader with the Schema and the generic port goes into the single input in Feature Writer, where you need to

  • ensure the table name = fme_feature_type
  • table qualifer is likely BDO or similar (depending on your SDE config)
  • tick on dynamic schema and the source "Schema From Schema Feature"
  •  

featurereadwriterdynamicLastly under the User attributes, ensure the attribute definition is dynamic. You can remove any attributes and leave blankattributeDef_Dynamic


Reply