Oracle -> Oracle Golden Gate ->Databricks Delta lake

Phani1
Databricks MVP

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