Thanks a lot for the insight, much appreciated.

I am keen in undersatnding the first phase, that is, reading the data from OLTP systems to data bricks via nightly schedule.

Could you provide some additional reads/blogs links or can provide bit more technical aspect on the replacing existing CDC by databricks connectors to Oracle or any RDBMS datbase and  how to schedule the sync .

Thanks in advance