How to use CDC concept step by step in talend enterprise version

Eight Stars RAJ
Eight Stars

How to use CDC concept step by step in talend enterprise version

Hi Talend Folks,

 

I want to know how to use CDC concept step by step in talend enterprise version.

I am using sources database is db2 and  destination database is postgres. 

I am beginner for talend. so please share information to me. 

 

i have tried this link https://help.talend.com/reader/_Qg2guINsDl6hsiB7uKWzQ/XjnjnnjKf5G8OuLt9h8xZw

but its not working.

 

when i create CDC  connection it will not show other database connection.

Thanks
RAJ
Moderator

Re: How to use CDC concept step by step in talend enterprise version

Hello,

What's the error you are getting when setting up your CDC environment? Are you using talend subscription solution 6.1?

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.
Eight Stars RAJ
Eight Stars

Re: How to use CDC concept step by step in talend enterprise version

Hi Sabrina,

 

Instead of CDC concept shall we use any other concept for increment load?

Thanks
RAJ
Moderator

Re: How to use CDC concept step by step in talend enterprise version

Hi,

You can match the tables and compare all records to conclude the needed inserted records, updated records, and deleted records. 
 If you want to capture the changed data and only load these changed data into target table to achieve table sync, you can compare tables by using tMap.
The work flow should be: Target DB-->tMap(make inner join on your input and set the "Catch lookup inner join reject" as true)-->output
                                     Source DB-->
The output will be the changed data.

Let us know if it is OK with you.

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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads