Wednesday, 15 June 2016

Reducing number of connections required in FME


With FME 2017 I have to export multiple (205) feature types coming from an SDE Database. I have loaded them into Workbench which creates 205 separate Readers and I now have to create a writer for each one to export into a different format which is obviously very time consuming.


Which is the best method for outputting feature types individually as in this case?



Answer




Do you mean a writer for each one (your question says reader)?


To create multiple writers is a simple task using a fanout tool.


enter image description here


Here I am writing each postcode from an address dataset to a separate GML file. So you could point all your data sources into a single feature type on a single writer and - by setting a fanout - create a separate writer/output for each at run time.


Probably the best way is to use fme_dataset or fme_feature_type as part of the fanout expression


Obviously , this does mean you need all of your source data tables to have the same attribute schema as defined in the one output feature type.


If that's not the case then you'll need to flick the switch and make it a dynamic translation:


enter image description here


Here I'm saying to write to a different output, but using the same schema as the original table had for everything (so if I had multiple source tables they would still get the correct schema)


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...