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 ?
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.
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!