Certification - Supported Data Sources

You can connect to many database types, and use a variety of database types for your Repository Creation Utility (RCU).

Data Sources Supported for Use with Oracle Analytics Server (sorted alphabetically by Oracle databases first, then other databases)

Database Supported Versions Data Sets Data Models More  Information     
Oracle 11.2+ Yes Yes

Not applicable

Oracle 12.1+

12.2+

Yes Yes

Not applicable

Oracle

18+

19+

Yes Yes

Not applicable

Apache Hive

0.10+

2.3+

3+

Yes Yes

Not applicable

Apache Spark SQL

1.2+

1.6+

Yes Yes

Not applicable

Aster Database

5.0 / 6.0

Yes Yes

Not applicable

Google Big Query

8.0

8.1

Yes Yes

Not applicable

IBM DB2 10.5+

11.1+

Yes Yes

Not applicable

IBM Informix Dynamic Server

12.10+

Yes Yes

Not applicable

IBM Netezza NPS

NPS 6+

NPS 7+

Yes Yes

Not applicable

Microsoft Analysis Services 2014 / 2016 / 2017 Yes Yes

Not applicable

Microsoft SQL Server 2014 / 2016 / 2017 Yes Yes

Not applicable

MongoDB

3.2+

Yes Yes

Not applicable

MySQL

5.6+

5.7+

Yes Yes

Not applicable

PostgreSQL

9+

Yes Yes

Not applicable

Snowflake

3.2

Yes Yes

Not applicable

Sybase Adaptive Server Enterprise

15.7

Yes Yes

Not applicable

Sybase IQ

16+

Yes Yes

Not applicable

Teradata

14+

15+

16+

Yes Yes

Not applicable

RCU Databases Supported by Oracle Analytics Server (sorted alphabetically by Oracle databases first, then other databases)

Database Supported Versions JDBC Driver More Information     
Oracle 11.2+ Oracle JDBC Thin Driver 12.2.0.0+

Not applicable

Oracle 12.1+

12.2+

Oracle JDBC Thin Driver 12.2.0.0+

Not applicable

Oracle 18.3+ Oracle JDBC Thin Driver 12.2.0.0+

Not applicable

Oracle 19.3+ Oracle JDBC Thin Driver 12.2.0.0+

Not applicable