Oracle Essbase connectivity

[maddan80]

Team, 

I wanted to understand the best way of connecting to Oracle Essbase to ingest data into the delta lake

[Melody242s]

Hello,

---

@maddan80 wrote:

Team, 

I wanted to understand the best way of connecting to Oracle Essbase to ingest data into the delta lake

---

To connect to Oracle Essbase and ingest data into a Delta Lake, consider using Databricks, Airflow, Talend, or custom Python/Scala code. Ensure proper authentication, data extraction, transformation, and Delta Lake integration. Choose the method that best suits your requirements and technical expertise.

[daniel_sahal]

@maddan80 I see that Essbase supports ODBC/JDBC connector. Try utilizing one of those.

[maddan80]

Any Specific driver name or location

[BigRoux]

I would start by looking at Oracle DataDirect ODBC. It is optimized for Oracle and it supports Essbase. I believe this driver is included with Essbase. Hope this helps. Lou.