Four Stars

Data Synchronization Testing - technical support required

Hi Team,

I’m looking for some technical insight on the Talend tool to figure out if:

  • the tool can be used to carry out data synchronisation testing requirement of my project 
  • if so, how can this be achieved 

To provide a summary of my query:

We have a main table and 3 other tables on the Oracle DB side which are Joined in order to create JSON data and PostgreSQL database is the source database which stores these JSON.

All we need to test is that any changes made to any of these tables on the oracle side are reflected exactly with the same formats, fields and values in corresponding tables in PostgreSQL database and the correct element is updated in JSON.

The time taken for this entire operation needs to be measured too.

 

I have to provide a plan to my team on how we can achieve this and timeline for the same with the help of Talend

 

Kindly let me know, if anyone has done anything similar to this in their projects and can provide some insight.

 

Thanks & Regards,

Shikha Garg

1 REPLY
Moderator

Re: Data Synchronization Testing - technical support required

Hi,

Synchronization works best when you can find your changed records quickest. With Talend, you can implement CDC (change data capture) feature.

Here is online document about:TalendHelpCenter:Change Data Capture (CDC): publish/subscribe

Note: You can capture the DML changes with CDC feature, including inserted, updated or deleted records, but it is unable to capture DDL changes.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.