topic Re: Capturing Data Changes on Oracle from one database to another in Talend Studio

Capturing Data Changes on Oracle from one database to another

Anonymous — Sat, 16 Nov 2024 09:37:40 GMT

Hi Team,

Is there a way to capture any column changes from a source table in an oracle database to another same table in different oracle database (Don't have enterprise so can't do CDC).

Data changes can be captured though wanted to check if there is way to even capture column changes (Column definition change, New Column addition) using open studio.

Thanks in advance!

Re: Capturing Data Changes on Oracle from one database to another

Anonymous — Thu, 15 Jun 2017 03:46:40 GMT

Hello,

If you want to capture the changed data and only load these changed data into target table to achieve table sync, you can compare tables by using tMap.
The work flow should be: Target DB-->tMap(make inner join on your input and set the "Catch lookup inner join reject" as true)-->output
Source DB-->
The output will be the changed data.

Best regards

Sabrina

Re: Capturing Data Changes on Oracle from one database to another

Anonymous — Thu, 15 Jun 2017 04:56:15 GMT

Thanks Sabrina.. Data change I understand can be captured using inner join rejects. I was more interested in capturing any column/column properties changes. Like if any column addition in source or changing the properties of column from varchar to number in source.(Oracle is the db)

Re: Capturing Data Changes on Oracle from one database to another

Anonymous — Thu, 15 Jun 2017 10:45:14 GMT

Hi,

So far, with talend CDC Trigger mode, data extraction takes place at the same time the Insert, Update, or Delete operations occur in the source tables, and the change data is stored inside the database in change tables. The changed data, thus captured, is then made available to the target system(s) in a controlled manner, using subscriber views.

There is no capturing any column/column properties changes operation.

Best regards

Sabrina