Skip to main content
Question

Efficient way for simple export of many SDE GIS layers


000craig

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.

4 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

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.


000craig
  • Author
  • September 7, 2023

Thank you for providing that direction!


nielsgerrits
VIP
Forum|alt.badge.img+54
000craig wrote:

Thank you for providing that direction!

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


j.botterill
Influencer
Forum|alt.badge.img+40
  • Influencer
  • September 8, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings