Database
This matrix provides certification for Oracle Essbase (Plus) 21c independent deployments and Oracle Cloud Infrastructure (OCI) via Marketplace.
Target Database for RCU
| Essbase Version | Database* | Notes |
|---|---|---|
| 21.1 and higher | Oracle Autonomous Database (ATP and ADW) 19c | For OCI deployments only; see Notes 1, 2, 4, and KM DOC ID 2825030.1. |
| 21.1 and higher | Oracle Database 12.1.0.1, 18.3, 19.3 and higher | If deploying on OCI, see Notes 2, 3. |
| 21.1 and higher | Microsoft SQL Server 2016 SP2 | For independent deployments only. |
| 21.3 and higher | Microsoft SQL Server 2019 | For independent deployments only. |
Notes:
- ,
- Note 1: The latest available Autonomous database on OCI (ATP) 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
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.
| Essbase Version | Database* | Notes |
|---|---|---|
| 21.1 | IBM DB2 10.1 | For IBM DB2 10.1, FP 2 and higher are supported. |
| 21.1 and higher | Oracle Database 12.1.0.1, 12.2.0.1.0, 18.3, 19.3 and higher | - |
| 21.1 and higher | Oracle Autonomous Database (19C) |
ATP and ADW can be used via the wallet files provided. For OCI deployments, both serverless and dedicated are supported. |
| 21.1 and higher | MySQL Database Server 5.6.x and 5.7.x | Only MySQL Enterprise Edition is supported. |
| 21.1 and higher | Oracle Essbase 19.3 and higher | - |
| 21.1 and higher | Microsoft SQL Server 2012, 2014, 2016 | For Microsoft SQL Server 2012, SP1 and higher is supported. |
| 21.2 | IBM DB2 10.1 | For IBM DB2 10.1, FP 2 and higher are supported. |
| 21.3 and higher | Microsoft SQL Server 2019 | For independent deployments only. |
Direct SQL
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.1, 12.2.0.1.0, 18.3 and higher | - |
| 21.1 and higher | Oracle Autonomous Database (19c) | For OCI deployments, see Note 1. |
| 21.1 and higher | Microsoft SQL Server 2012, 2014 and 2016 | For Microsoft SQL Server 2012, SP1 and higher are supported. |
| 21.1 and higher | 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.0 | See Note 2. |
| 21.4 | Teradata Database 17.1 | See Note 2. |
| 21.5 | Teradata Database 17.2 | See Note 2. |
| 21.5 | Oracle Database 21.1 and higher | Starting with Essbase 21.5, Oracle 21.1 and higher are supported as a repository schema and data source. |
Notes:
- *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 DB XE is not supported.
- Oracle recommends using latest Oracle DB PSU's.
- 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.