topic Re: Oracle Essbase connectivity in Data Engineering

Oracle Essbase connectivity

maddan80 — Mon, 02 Sep 2024 22:16:20 GMT

Team,

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

Re: Oracle Essbase connectivity

Melody242s — Tue, 03 Sep 2024 08:55:18 GMT

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.

Re: Oracle Essbase connectivity

daniel_sahal — Tue, 03 Sep 2024 09:13:05 GMT

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

Re: Oracle Essbase connectivity

maddan80 — Fri, 09 May 2025 15:32:58 GMT

Any Specific driver name or location

Re: Oracle Essbase connectivity

Louis_Frolio — Fri, 09 May 2025 17:56:22 GMT

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.

Re: Oracle Essbase connectivity

hyaqoob — Tue, 25 Nov 2025 18:14:23 GMT

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.

Re: Oracle Essbase connectivity

Developer35 — Fri, 23 Jan 2026 08:04:08 GMT

Since Lakehouse Federation doesn’t support ODBC connections, is there any way to connect to Essbase using JDBC and create a foreign catalog?