Question

Generic Writer with fme_db_operation?

  • 3 September 2018
  • 1 reply
  • 4 views
T
Badge

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?

1 reply

redgeographics
Rank
Userlevel 5
Badge +25

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.

Reply


Community Stats

28,688
Posts
109,431
Replies
36,542
Members
Terms & ConditionsCookie settings
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.