data linking without having primary key

[StreetTalender]

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:

1. Find out a way to link data without having primary key using CDC Foundation
2. Add virtual primary key

I would appreciate if anyone can help me.

Best Regards,

[Anonymous]

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]

Hi rhall,

Thanks for your comment.​

I will take a look into the page.