Skip to main content
  • EN

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.

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

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

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.

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


Community Stats

30,159
Posts
114,480
Replies
37,807
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.