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+ Oracle Autonomous Database (ATP and ADW) 19c For OCI deployments only; see Notes 1, 2, 4.
21.1 Oracle Database 12.1.0.1+ If deploying on OCI, see Notes 2, 3.
21.1, 21.2 Oracle Database 18.3+ If deploying on OCI, see Notes 2, 3.
21.3 Oracle Database 19.3+ If deploying on OCI, see Notes 2, 3.
21.1+ Microsoft SQL Server 2016 SP2 For independent deployments only.
21.3+ 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+, 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+ Oracle Database 12.1.0.1+ -
21.1+ Oracle Database 12.2.0.1.0 -
21.1, 21.2 Oracle Database 18.3+ -
21.1+ Oracle Autonomous Database (19C)

ATP and ADW can be used by using the wallet files provided.

For OCI deployments, see Note 1.

21.1+ Microsoft SQL Server 2012 For Microsoft SQL Server 2012, SP1+ is supported.
21.1+ Microsoft SQL Server 2014 -
21.1+ Microsoft SQL Server 2016 -
21.3+ Microsoft SQL Server 2019 For independent deployments only.
21.4+ Microsoft SQL Server 2019 -
21.1, 21.2 IBM DB2 10.1 For IBM DB2 10.1, FP 2 and higher are supported.
21.1+ Apache Spark SQL 1.2+ -
21.1, 21.2 MySQL Database Server 5.6.x Only MySQL Enterprise Edition is supported.
21.1+ MySQL Database Server 5.7.x Only MySQL Enterprise Edition is supported.
21.1+ Oracle Essbase 19.3+ -
Notes:
  • Note 1: Both serverless and dedicated are supported.
  • Note 2: Only serverless is supported.
Direct SQL

Direct SQL allows users to connect to the data sources by direct SQL in rules files.

Essbase Versions Database* Notes
21.1+ Oracle Database 12.1.0.1+ -
21.1+ Oracle Database 12.2.0.1.0 -
21.1, 21.2 Oracle Database 18.3+ Independent or OCI deployment.
21.1+ Oracle Database 19.3+ Independent or OCI deployment.
21.1+ Oracle Autonomous Database (19c) For OCI deployments, see Note 1.
21.1+ Microsoft SQL Server 2012 For Microsoft SQL Server 2012, SP1+ is supported.
21.1+ Microsoft SQL Server 2014 -
21.1+ Microsoft SQL Server 2016 -
21.3+ Microsoft SQL Server 2019 For independent deployments only.
21.4+ Microsoft SQL Server 2019 -
     
21.1, 21.2 IBM DB2 10.1

1. Repositories hosted in DB2 or Sybase must set DB (tablespace/dbspace) page size greater than 4k.

2. For IBM DB2 10.1, FP 2 and higher are supported.

21.1+ Apache Spark SQL 1.2+ -
21.1, 21.2 MySQL Database Server 5.6.x Only MySQL Enterprise Edition is supported.
21.1, 21.2 MySQL Database Server 5.7.x Only MySQL Enterprise Edition is supported.
21.1+ Teradata Database 16.20

1. Database Client: Teradata Native ODBC and JDBC driver client version.

2. Native Drivers are recommended.

21.3 Teradata Database 17.0

1. Database Client: Teradata Native ODBC and JDBC driver client version.

2. Native Drivers are recommended.

21.4 Teradata Database 17.10

1. Database Client: Teradata Native ODBC and JDBC driver client version.

2. Native Drivers are recommended.

Notes:
  • *Database: The Oracle databases listed in this column are supported on all platforms that the database supports. See Database Certification Matrix for details. All Oracle configurations - Single instance, RAC, XA, DR are supported. There is no support with Oracle DB XE. Oracle recommends using latest Oracle DB PSU's. For latest recommended patch information, see Oracle Support.
  • Note 1: Both serverless and dedicated are supported.
  • Note 2: Only serverless is supported.