Hello everyone

I'd like to try integration of Data Bricks with on-premise Oracle database, and now I have the following  fundamental questions as below about the architectures of that integration.

1) I guess the following is the list of integration way with Oracle database, but is there any other options?

- Convert table data to csv/parquet via ETL tool, and ingest csv/parquet via COPY INTO/Auto Loader

- Using Lakehouse Federation to query table data

- Using Query based connectors for LakeFlow to ingest table data

2) Does Lakehouse Federation and Query based connectors for Oracle use JDBC connections?

3) Is there any ways to implement CDC for Oracle? I guess Oracle is not listed in the supported database for CDC LakeFlow.

Thank you