topic Re: CDC in Talend Studio

CDC

muralam — Mon, 26 Feb 2018 05:20:59 GMT

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

Re: CDC

Anonymous — Mon, 26 Feb 2018 07:35:06 GMT

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

Re: CDC

muralam — Mon, 05 Mar 2018 09:31:48 GMT

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

Re: CDC

manodwhb — Mon, 05 Mar 2018 09:44:35 GMT

please check below link.
https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/JXvgNTorRK1zf3XyoitGag

Re: CDC

manodwhb — Tue, 06 Mar 2018 04:31:44 GMT

@muralam did it help you ?

Re: CDC

muralam — Tue, 13 Mar 2018 07:28:54 GMT

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

Re: CDC

manodwhb — Tue, 13 Mar 2018 09:05:53 GMT

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