Skip to main content
Solved

Unable to connect Delete Writer to Reader

  • February 16, 2021
  • 2 replies
  • 24 views

Forum|alt.badge.img+1

Hi

Added Reader to extract from Access db source and then insert into destination SQL db (right hand side) and it worked fine:

FMEWanted to add a writer to delete all db records (on the far left) before the reader. However, unable to connect that writer to the reader. Any advice on how can I execute that Delete Writer before the Reader? Thanks.

Best answer by nielsgerrits

You can use FeatureReaders / FeatureWriters for this kind of workflow. If you have no features to initiate the proces, you can put a Creator transformer in front of the FeatureReader.

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.

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+62
  • Best Answer
  • February 16, 2021

You can use FeatureReaders / FeatureWriters for this kind of workflow. If you have no features to initiate the proces, you can put a Creator transformer in front of the FeatureReader.


Forum|alt.badge.img+1
  • Author
  • February 16, 2021

Thanks

 

Created new Feature Writer as below to delete SQL records:server1Able to link that ti AttributeManager and FeatureReader:

server2Ran the FeatureWriter but nothing got deleted in the SQL db. Anything that I missed?