Oracle -> Oracle Golden Gate ->Databricks Delta lake

[Phani1]

Hi All,

We have a situation where we are collecting data from different Oracle instances.
The customer is using Oracle GoldenGate to replicate this data into a storage location.
From there, we can use Auto Loader or Delta Live Tables to read Avro files and process them in a medallion architecture.

Is this the best approach, or are there better ways to handle this scenario?

Regards,

Janga

[szymon_dybczak]

Hi @Phani1 ,

In my opinion this is really good setup. You have push scenario where Oracle GoldenGate  is responsible for delivering data into storage, so you don't have to bother about extraction part. And autoloader is the best choice when it comes to efficiently loading data into Delta lake tables.