- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Hi,
For SQL server it is clear, I was asking about Oracle.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
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.
