Oracle Essbase
by Oracle
Multidimensional OLAP server for planning and analytics models; the REST API returns applications, cubes, dimensions and query results.
- Category
- Cloud & Data Platforms
- Type
- BI & reporting
- Interface
- REST API
- Built with
- Connect Any API
- Credentials
- Username and password, OAuth 2.0
02Data
What you can sync.
- Applications
- Cubes
- Dimensions
- Mdx query results
- Jobs
Load Oracle Essbase applications into your Lake and model it in the Warehouse with the rest of your stack.
Need more? Name any other Oracle Essbase data the API returns, and the AI adds it to the connector.
03Credentials
Credentials you will need.
- A username and password
- OAuth 2.0 (client ID, client secret, refresh token)
Oracle Essbase uses a username and password or OAuth 2.0 (client ID, client secret, refresh token). You add the credentials once, when the AI asks for them, and it tells you where to create them in Oracle if you need help.
04How it works
How it works in DataMind.
-
Pick Oracle Essbase.
Open Lake, pick Oracle Essbase in the source picker and name the connection. Connect Any API opens with a ready prompt that points the AI at the Oracle Essbase API docs.
-
Answer a few questions.
The AI reads the Oracle Essbase documentation, then asks which credentials you will use, which data to sync (for example applications and cubes), whether you want a one-time load or a recurring sync, and which accounts or filters apply.
-
Your data lands in Lake.
It builds the connector, tests it and shows you sample rows. Then Oracle Essbase data loads into your Lake on your schedule, ready for the Warehouse, DataPrism BI and AI Minds.
