Talend Oracle CDC

One Star

Talend Oracle CDC

I am trying to setup a CDC in Talend on an Oracle database. I am following the steps as listed here
However, when i try to establish the CDC in the main DB conneciton, i get a message saying 

"Database information must be filled to use the cdc!"


 and the 

Create Subscriber


 button is disabled.

What could I be doing differently? I have created two connections pointing to the same database, and have also retrieved the table schema in my main connection.

I am using Talend enterprise 5.4.2
Community Manager

Re: Talend Oracle CDC

Do you use the same user to connect to the same database? In this tutorial, it creates three DB connections with different credentials.
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend Oracle CDC

Yes, i am using the same user. I have a CDC setup running in Talend for a MySQL database, in that too, i am using the same user in both the data and the CDC connection. As long as the user has the privileges for creating the tables, views and trigger, it should work, right ?
One Star

Re: Talend Oracle CDC

Ok, i am able to setup CDC now, I was earlier using a connection of type Oracle Custom. Now when i change the connection type to Oracle SID, i am able to proceed forward. Not sure if this is documented anywhere, that CDC doesnt work with Oracle Custom type connections or if it is a bug.
One Star

Re: Talend Oracle CDC

Hi,
Sometimes, i see that when i create a CDC in oracle through Talend, the CDC objects' DDL that is generated (for the trigger, view and table) does not contain the table name (prefixed with TCDC). Instead i see the objects are created with names like TCDC_T00001, TCDC_VIEW_T00001 etc. Why is this ?
If i am creating a CDC on a table named "Employee", then the respective CDC objects in the DB must be named "TCDC_VIEW_Employee", "TCDC_Employee" etc. Please suggest!
Thanks!

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Downloads and Trials

Test drive Talend's enterprise products.

Downloads