topic CDC Implementation in Oracle in Talend Studio

CDC Implementation in Oracle

Anonymous — Mon, 21 Nov 2016 06:26:01 GMT

Hi All,
I am trying to implement CDC in oracle as given in
https://www.talendforge.org/tutorials/tutorial.php?language=english&idTuto=42
When i am adding CDC to Customers table on DataOracle,It has generated a script which puts an entry in TSubscribers table and creating a new subscriber as TCDC_Customers.
But here i am facing a difficulty as the script generated has ID as Number(0).This is further giving me "number precision specifier is out of range(1 to 38) " error.
While the manual has correct script with NUMBER(22,0).
Any help or suggestion would be appreciated.

Re: CDC Implementation in Oracle

Anonymous — Tue, 06 Dec 2016 09:04:20 GMT

Hi,
Sorry for delay!
Could you please indicate what's the build version you are using?
The tutorial is out of date. Have you already checked document about: TalendHelpCenteretting up a CDC environment?

Best regards
Sabrina

Re: CDC Implementation in Oracle

Anonymous — Thu, 15 Dec 2016 12:28:03 GMT

Thanks for redirecting to the right path Sabrina.
https://help.talend.com/search/all?query=Setting+up+a+CDC+environment
My issue is at step 4.
I have rechecked my table.It does have a Primary Key.
Also my script is not creating the name as Alias like TCDC_CUSTOMERS.
Can u please suggest what could be the reason?

Regards,
Gowthami

Re: CDC Implementation in Oracle

Anonymous — Thu, 15 Dec 2016 12:31:30 GMT

Build Version is 5.4.2