I am trying to create an FME workspace that reads a series of feature classes from an Oracle SDE database and copies them to another Oracle SDE database, one by one. The key thing is I do not want to merge them into a single feature class. Do I need to have multiple writers, or can I use some kind of "dynamic" setting to maintain separate tables? I'm not finding very much documentation about this type of workflow. I found this article:

Pass a List of Tables or Layers to an FME Reader using Python Scripted Parameters

but I would prefer to have all of my sources contained within the workspace.


1 Answer 1


You only need one writer (to the SDE database) but multiple outputs for each feature class.
enter image description here
In fact if I specify my Reader feature classes first, when I create my output Writer it asks me if I want to create matching output feature classes, and then all I need to do is link them (and add any transformers between them if desired)

enter image description here
I believe there is a way to combine them into one Writer output and have it dynamically output to the correct feature classes, but I have never had success in getting this to work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.