topic Re: data linking without having primary key in Talend Studio

data linking without having primary key

StreetTalender — Fri, 15 Nov 2024 22:11:46 GMT

Hello,

I need to link data from Oracle 11g to Oracle 19c.

I am trying to do it by using CDC Foundation, however, in some tables there are no primary keys.

When I attempt to create CDC under a DB connection, it requires primary key.

As I am not allowed to add new columns to the DB, I am wondering if one of the following is possible:

I would appreciate if anyone can help me.

Best Regards,

Anonymous — Tue, 17 Jan 2023 16:08:48 GMT

I'm afraid you will need the primary keys. If you take a look here you will see....

https://help.talend.com/r/en-US/8.0/studio-user-guide/step-3-create-subscriber-s-table

You may want to speak to your account executive about our new CDC offering. This may help you....

https://www.talend.com/products/change-data-capture/

StreetTalender — Wed, 18 Jan 2023 10:54:44 GMT

Hi rhall,

Thanks for your comment.

I will take a look into the page.