CODEWITHSUNDEEP
h2talendchange-data-capture
Guru Prasanna
Guru Prasanna

Reputation: 51

Applying SCD on Talend MDM Server

I am using Talend Open Studio for MDM and I have a requirement to do version control on customer records.

When using an Oracle database, I can use tOracleSCD to capture the changes. Likewise, for MySQL, I can use tMysqlSCD.

But in Talend Open Studio for MDM, the only supported database is H2 and so I am storing all master records in a H2 database.

In this case, how can I achieve version control as there is no component available in Talend for H2 database?

Upvotes: 1

Views: 315

Answers (1)

ydaetskcoR
ydaetskcoR

Reputation: 56849

The SCD components just set up triggers on the watched tables and provide an easy interface into reading the trigger output tables.

You could set the triggers up manually on the H2 database by recreating the database in MySQL and then using the MySQL SCD components to work out what it's doing and work out how to read the data back in and then recreate those steps with H2 components as part of a data integration task.

That said, Talend MDM has the concept of a journal which stores all of the changes made to a data record. The Talend Open Studio for MDM documentation has some more detailed information about how to view the journal. All changes made through the MDM interface should make an entry in the journal automatically.

Upvotes: 1

Related Questions