Seven Stars RAJ
Seven 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
3 REPLIES
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.
Seven Stars RAJ
Seven 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.