Solved

Oracle DB writers


Badge

Hello,

I need to set specific order for writers to write because tables are connected with constraints , when one finishes second one starts and after second third starts. How can I do that? And second question, how can I commit changes to Oracle DB or FME does that after writing to DB? I am using Oracle non-spatial writer.

icon

Best answer by nielsgerrits 16 May 2018, 12:40

View original

4 replies

Userlevel 6
Badge +31

Multiple possible ways:

- FeatureWriters, use multiple FeatureWriters, Holders and Testers to start the next FeatureWriter as the previous one is finished.

- SQLExecutor, create the code and order by hand and run this.

stagedfeaturewriter2018.fmw

Userlevel 3
Badge +13

Hi @luckym, check out our Let the Database Tutorial for an article on writing to Oracle when dealing with constraints.

Badge

Hi @luckym, check out our Let the Database Tutorial for an article on writing to Oracle when dealing with constraints.

@TiaAtSafe thank you very much, this was very helpful.
Badge

Multiple possible ways:

- FeatureWriters, use multiple FeatureWriters, Holders and Testers to start the next FeatureWriter as the previous one is finished.

- SQLExecutor, create the code and order by hand and run this.

stagedfeaturewriter2018.fmw

@nielsgerrits thank you, this works perfectly for me.

 

Reply