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

[Louis_Frolio]

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.

[hyaqoob]

I am currently working with Essbase 21c and I need to pull data from Databricks through a SQL query. I was able to successfully setup JDBC connection to Databricks but when I try to create a data source using a SQL query, it gives me an error: "[Databricks][JDBC][10220] Driver does not support this optional feature".

I can confirm that the query is successfully sent to Databricks and if I run the query manually in Databricks, I get the correct results.

Any idea what could be the issue?

Thanks a lot in advance.