Question

how to synchronize 2 databases (IFX -- SQL) with FME

  • 19 May 2016
  • 1 reply
  • 3 views

I want to synchronize (INSERT,UPDATE, DELETE) 2 databases, source is Informix and target is SQL), anyone has an example to do it??.

Finally i want the SQL database gets all changes of the Source Database (ifx),

Thanks for your help


1 reply

Badge +1

I don't know much about these formats of databases, but we work a lot with Smallworld database. So maybe this is applicable to your problem:

By using UpdateDetector transformer (from FME Store) we defined which data was updated, inserted or deleted (writen as fme_db_operation). We based this on attribute Date Modified, so everything that had newer date from revised (new) database went to one of before mentioned outputs (update, insert, delete). After that fme_where field is defined (using AttributeCretor) and writen to final database acording to operation from fme_db_operation.

Hope that helps...

Reply