Skip to main content
Solved

Oracle DB writers


Forum|alt.badge.img

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.

Best answer by nielsgerrits

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

View original
Did this help you find an answer to your question?

4 replies

nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • May 16, 2018

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


fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • May 16, 2018

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


Forum|alt.badge.img
  • Author
  • May 17, 2018
fmelizard wrote:

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.

Forum|alt.badge.img
  • Author
  • May 17, 2018
nielsgerrits wrote:

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.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings