Certification - Repository Creation Utility (RCU) Databases
You can host the mid-tier schemas created by Repository Creation Utility (RCU) on a variety of database types.
Databases supported by the latest update of Oracle Analytics Server for hosting the mid-tier schemas created by RCU (sorted alphabetically by Oracle databases first, then other databases)
| Database | Supported Versions | JDBC Driver | More Information |
|---|---|---|---|
| Oracle | 12.1+
12.2+ |
Oracle JDBC Thin Driver 19.x+ |
To create or upgrade RCU schemas from an Oracle Database Standard Edition instance, apply patch 35476806, available from My Oracle Support. |
| Oracle | 18+ | Oracle JDBC Thin Driver 19.x+ |
To create or upgrade RCU schemas from an Oracle Database Standard Edition instance, apply patch 35476806, available from My Oracle Support. |
| Oracle | 19+ | Oracle JDBC Thin Driver 19.x+ |
To create or upgrade RCU schemas from an Oracle Database Standard Edition instance, apply patch 35476806, available from My Oracle Support. |
| Oracle Autonomous Transaction Processing | 19+ | Oracle JDBC Thin Driver 19.x+ | You must use the Oracle Autonomous Database TP consumer group.
Also certified for Autonomous Database when configured for the Autonomous Transactional Processing workload type. |
| Microsoft SQL Server * | 2014
2016 2017 2019 |
WebLogic JDBC Driver for Microsoft SQL Server Type 4 |
* You must have SQL Server Enterprise Edition. Supports case sensitive and case insensitive collation. See Recommended Configuration Settings for Usage Tracking using SQL Server. |
Exceptions and Additional Information
When you migrate from BI Enterprise Edition to Oracle Analytics Server, you can't migrate scheduler data from IBM DB2 or Microsoft SQL Server. You can migrate scheduler data only from Oracle databases.