Skip to main content
Question

Difference between DatabaseUpdater and Feature Operation in Writer

  • January 8, 2021
  • 2 replies
  • 40 views

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.​


  • Author
  • 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.​

Great, thank you!