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.
Userlevel 2
+12
- Contributor
- 2177 replies
-
1 February 2017
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)..
+1
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.
+16
- Contributor
- 1425 replies
-
1 February 2017
my choice would be to set up a dynamic translation which will take care of the schema changes.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.