Skip to main content
Question

Generic Writer with fme_db_operation?

  • September 3, 2018
  • 1 reply
  • 32 views
T
Forum|alt.badge.img

Hi

There is this really cool writer called Generic (Any Format). I tried to use this writer to keep my scripts independently from the DBMS I'm writing into. This would enable me to switch DBMS very fast, and just to have one lean script to work with PostgreSQL, MS SQL Server, Oracle, or Teradata.

Thing is that I make use of the parameter fme_db_operation in almost all my scripts. Some features lead to an INSERT, some trigger an UPDATE, other a DELETE.

I couldn't make the Generic ( Any Format) writer to accept fme_db_operation. It always leads to an INSERT operation.

How do I use the Generic ( Any Format) writer with the parameter fme_db_operation?

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.

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+62

Not sure if this will work and no time to try it myself, but if you add writers for the database formats you want the Generic writer to support you'll gain access to their parameters. You don't need to actually write data to them, they don't even have to have feature types, they just have to be there.

FME rocks! \m/

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.