Five Stars

Capturing Data Changes on Oracle from one database to another

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!

  • Data Integration
  • Exchange components
Tags (3)
3 REPLIES
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

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

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)

 

 

Moderator

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

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.