Data Synchronization Testing - technical support required

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


Re: Data Synchronization Testing - technical support required


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


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


Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.