Oracle Connectivity - CDC

[psingh13]

Hi Team,

Has Databricks released CDC(Change data Capture) for Oracle Ingestion(public preview or GA)?

I was able to see this option in free edition but want to make sure.Please check attached screenshot.

Also, I understand that there are steps mentioned for SQL server CDC ingestion ( steps to be executed on source SQL server), but I don’t see any steps mentioned for Oracle anywhere.

Are there any steps applicable for the same?

[rkhbo3003]

Hi , 

Are you using lakeflow ? For sql there is lakeflow connector it uses . I have used that it us very convenient however need to do configuration at account level

[psingh13]

Hi,

For SQL server it is clear, I was asking about Oracle.

Thanks.

[harisrinivasay]

Answer: Not yet.

As of now, Oracle is not listed as a supported CDC (Change Data Capture) database connector in Lakeflow Connect managed CDC connectors.

Databricks has recently introduced Query-Based Connectors for databases including Oracle. These connectors are different from CDC:

• They query the source database on a schedule.
• They use a cursor/watermark column (for example, LAST_UPDATED_DATE).
• They do not read Oracle redo logs or perform transaction-log-based CDC.
• They do not require an ingestion gateway or CDC configuration on the source database.