Skip to main content
Question

Difference between DatabaseUpdater and Feature Operation in Writer


I'm wondering what the difference is between the DatabaseUpdater transformer and setting the Feature Operation to Update in a database writer.

I know there is a lot of overlap is some of the transformers in FME so i'm wondering if one is better or if they'll do the same thing.

 

2 replies

caracadrian
Contributor
Forum|alt.badge.img+23
  • Contributor
  • January 8, 2021

DatabaseUpdater is designed to do one thing and do it really good.

A database writer (any type of database) can do a lot of things, it is universal/generic as it comes to db operations.

The logic usually is that a dedicated solution is faster than a more generic one. So that should be the answer.

Depending on how you set them up they should do the same thing in terms of updating.​


caracadrian wrote:

DatabaseUpdater is designed to do one thing and do it really good.

A database writer (any type of database) can do a lot of things, it is universal/generic as it comes to db operations.

The logic usually is that a dedicated solution is faster than a more generic one. So that should be the answer.

Depending on how you set them up they should do the same thing in terms of updating.​

Great, thank you!


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