[resolved] tOracleCDC and dynamic schema

Six Stars

[resolved] tOracleCDC and dynamic schema

Hello,
I would like to know if it is possible to use a dynamic schema with the CDC oracle component. My problem is that my source structure table is not static, it changes a lot and is quite big (lots of millions of rows) and it will be great if i can get the changed rows without change every time the structure of my src table.
The Talend version is Big Data Entreprise 6.2.1
Oracle 11.2

Any help?

Thanks

Employee

Re: [resolved] tOracleCDC and dynamic schema

Talend real-time CDC relies on DB triggers. If your schema is changing then the triggers will be invalidated and your CDC will break.
Dynamic schema is not a good for your use case.
Six Stars

Re: [resolved] tOracleCDC and dynamic schema

Hello Amula,
Thank you for your reply, but it is a way tho do this ? maybe the mode cdc redo log ?
Regards
Employee

Re: [resolved] tOracleCDC and dynamic schema

im not sure ....if the supplemental logging dont break with schema changes then you should be ok i guess.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now