CDC

Seven Stars

CDC

Hi ,

 

I am having my target table name PRODUCT in oracleDB, which is daily load on which action on data i am performing Insert or update, but i wanted to capture the latest insert and updated records in another table for audit purpose, i have studied some forum on CDC but am confused how to set up this practically, can some one please help me out the procedure step by step, as i am new to talend. Thanks in advance.

 

Regards,

Meena

Moderator

Re: CDC

Hello,

Talend Change data capture feature will be available in talend subscription solution not open source.

For more information, please refer to online document about:TalendHelpCenter:Change Data Capture.

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

Re: CDC

Hi Sabrina,

 

Thanks for the information, i am using Talend 6.4.1 subscribed version, but as i am new to this concept, i need step by step information to setup a CDC, both my source table and target tables are available in oracle

 

Regards,

Meena

Forteen Stars

Re: CDC

please check below link.
https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/JXvgNTorRK1zf3XyoitGag
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: CDC

@muralam did it help you ?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Seven Stars

Re: CDC

Hi @manodwhb,

 

i tried and followed the same steps but i am getting an error like table or view doesnot exist, everything seems fine.

 

Regards,

Meena

Forteen Stars

Re: CDC

based on the error,you were either pointing to worng database or worng tablename and schema

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

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

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog