Database
This matrix provides certification for Oracle Essbase (Plus) Essbase 26ai independent deployments and Oracle Cloud Infrastructure (OCI) via Marketplace.
| Essbase Version | Database* | Notes |
|---|---|---|
| 26.1 and higher | Oracle Database 19c, Oracle AI Database 26ai | - |
| 26.1 and higher | Microsoft SQL Server Enterprise Edition 2022, 2025 | For independent deployments only. |
- Note 1: The latest available Autonomous AI Database Serverless will be deployed in case users do NOT select the "USE EXISTING DATABASE" option at the time of deployment of the stack.
- Note 2: If OCI DB System is used, Essbase compute and Database (OCI or Autonomous) should be in the same Region.
- Note 3: Bare Metal and VM databases are supported. Exadata is not supported, as it is no longer supported in OCI provisioning and with Terraform.
Platform SQL refers to performing a data load or dimension build using the Connections and Datasource constructs. The database used in Platform SQL should be network accessible, if you're not using the CLI or REST streaming options.
Platform SQL means that the connectivity to the JDBC source database is enabled by drivers included with Essbase (rather than generic JDBC drivers you upload). Platform SQL sources of data are accessible using load rules with a Source Type of Datasource. For instructions on enabling Platform SQL connectivity, refer to Create an Application-Level Connection and Datasource or Create a Global Connection and Datasource.
Direct SQL allows users to connect to the data sources by direct SQL in rules files.
| Essbase Versions | Database* | Notes |
|---|---|---|
| 26.1 | IBM DB2 10.1 | See Note 2. |
| 26.1 | Oracle Database 19c and 26ai |
Oracle Database is supported as a repository schema and data source. |
| 26.1 | Teradata Database 17.00 | See Note 1. |
| 26.1 | Microsoft SQL Server 2022 | For independent deployments only. |
- *Database column notes for Direct SQL:
- Oracle Databases listed in Database column are supported on all platforms supported on this page.
- For all Oracle configurations: Single instance, RAC, XA, and DR are supported.
- Oracle Database XE is not supported.
- Oracle recommends using latest Oracle Database PSUs.
- Essbase uses ODBC 8.0.2; see related ODBC documentation: https://www.progress.com/odbc.
- For latest recommended patch information, see Oracle Support.
- Note 1: Database Client: Teradata Native ODBC and JDBC driver client version. Native Drivers are recommended.
- Note 2: Repositories hosted in DB2 or Sybase must set DB (tablespace/dbspace) page size greater than 4k. For IBM DB2 10.1, FP 2 and higher are supported.