I am trying to figure out a way to update the schema of a writer after changes are made to the schema of a reader. In this case, there are no transformers, just a reader pointing directly to a writer. The name on the writer is different from the reader but that is the only difference. Occasionally a field length will change on the reader or a new field is added to the reader. I can bring those changes into the workspace by updating the reader, and I am looking for a way for the change attributes of the writer if the reader changes.
Question
Update writer schema from reader schema changes
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+26- Contributor
The easiest I can think of is: After updating, right click the Reader feature type and use "Duplicate on Writer".
Then remove the original Writer feature Type (or do that first)..
+2- Participant
I was hoping I could use the workbench as part of an automated script so running it would update the destination schema and not have to get in and fiddle with it each time. Also, Duplicate on Writer wouldn't use the new feature names on the writer.
+18- Supporter
my choice would be to set up a dynamic translation which will take care of the schema changes.