Database
This matrix provides certification for Oracle Essbase (Plus) 21c independent deployments and Oracle Cloud Infrastructure (OCI) via Marketplace.
| Essbase Version | Database* | Notes |
|---|---|---|
| 21.1 and higher | Oracle Autonomous Database (19c) Autonomous AI Transaction Processing and Autonomous AI Lakehouse | For OCI deployments only; see Notes 1, 2, 4, and KM DOC ID 2825030.1. |
| 21.1 and higher | Oracle Database 12.1.0.x, 18.y, 19.z |
If deploying on OCI, see Notes 2, 3. Where x >=1; y>=3, z>=3. |
| 21.1 | Microsoft SQL Server Enterprise Edition 2016 SP2 | For independent deployments only. |
| 21.3 and higher | Microsoft SQL Server Enterprise Edition 2019 | For independent deployments only. |
| 21.7 and higher | Oracle AI Database 26ai | - |
| 21.8 and higher | Microsoft SQL Server Enterprise Edition 2022 | 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 in 21.4 and higher, as it is no longer supported in OCI provisioning and with Terraform.
- Note 4: Both serverless and dedicated are supported.
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 |
|---|---|---|
| 21.1 | Teradata Database 16.20 | See Note 2. |
| 21.1 | IBM DB2 10.1 | See Note 3. |
| 21.1 | MySQL Database Server 5.6.x and 5.7.x | Only MySQL Enterprise Edition is supported. |
| 21.1 and higher | Oracle Database 12.1.0.x, 18.y, 19.z | Where x >=1; y>=3, z>=3. |
| 21.1 and higher | Oracle Autonomous Database (19c) | For OCI deployments, see Note 1. |
| 21.1 | Microsoft SQL Server 2012, 2014 and 2016 | For Microsoft SQL Server 2012, SP1 and higher are supported. |
| 21.1 | Microsoft SQL Server 2012, 2014 and 2016 | For Microsoft SQL Server 2012, SP1 and higher are supported. |
| 21.2 | IBM DB2 10.1 | See Note 3. |
| 21.2 | MySQL Database Server 5.6.x and 5.7.x | Only MySQL Enterprise Edition is supported. |
| 21.3 and higher | Microsoft SQL Server 2019 | For independent deployments only. |
| 21.3 | Teradata Database 17.00 | See Note 2. |
| 21.4 | Teradata Database 17.10 | See Note 2. |
| 21.4 and higher | IBM DB2 11 | See Note 3. |
| 21.5 | Teradata Database 17.20 | See Note 2. |
| 21.5 | Oracle Database 21.x |
Starting with Essbase 21.5, Oracle 21.x are supported as a repository schema and data source. Where x>=1. |
| 21.8 | Teradata Database 20.00 | See Note 2. |
| 21.8 | 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: Both serverless and dedicated are supported.
- Note 2: Database Client: Teradata Native ODBC and JDBC driver client version. Native Drivers are recommended.
- Note 3: 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.