Certification - Supported Data Sources

Here are the supported data sources for the latest update of Oracle Analytics Server.

Notes on using this table

  • Version Numbers:
    • "1.x" means any version starting with a 1 (for example, this includes version 1.4.3 but not version 2.0).
    • "2.0.x" means any version starting with 2.0 (for example, this includes version 2.0.4 but not version 2.4).
    • "1.6+" means any version starting with 1 and is greater than or equal to (>=) 1.6 (for example, this includes version 1.8 but not version 2.4).
  • Use in Datasets - "Yes" means that you can connect to a data source for analysis by creating a connection from the Oracle Analytics home page.
  • Use in Data Models - "Yes" means that you can connect to the semantic layer of a data source and model the data of that type. You can use the Console or Oracle Analytics Developer Client Tool to connect.
  • In addition to the connections types listed on the Connections page, you can connect to other data sources using the JDBC connection type.

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

Note:

To access Cloud databases across the public internet, Oracle Analytics Server must be deployed on a server that doesn't require proxy access. If you're not sure, check with your administrator.
Database Supported Versions Datasets Data Models - Semantic Modeler Data Models - Model Administration Tool More  Information     
Oracle Database

12.1+

12.2+

18+

19+

21+

Yes Yes Yes

Supports saving output from data flows.

Oracle Applications Oracle Fusion Applications Release 8 and later Yes No No -
Oracle Autonomous Data Warehouse 18.2.4+

19+

Yes Yes Yes Supports saving output from data flows.

You can also connect via Delta Sharing using the Delta Share connection type. See Connect to a Database Using Delta Sharing.

Oracle Autonomous Transaction Processing 19c Yes Yes Yes Supports saving output from data flows.
Oracle Enterprise Performance Management Cloud Current version Yes No Yes You can't blend datasets that use Oracle Enterprise Performance Management Cloud data sources.
Oracle Essbase 11.1.2.4.0+

21c

Yes No Yes You can't blend datasets that use Oracle Essbase data sources.

Connectivity to a data source in an Essbase cluster (via an Analytic Provider Services (APS) node) isn't supported.

Oracle Hyperion Financial Management 11.1.2.4+

11.2+

No No Yes -
Oracle Hyperion Planning

11.1.2.4+

11.2+

No No Yes -
Oracle NetSuite Release 2019.2 (JDBC Driver 8.10.85.0) Yes No No See Connect to NetSuite Data Sources.
Oracle OLAP

12+

18+

No No Yes -
Oracle Service Cloud 1.2 Yes No No

-

Oracle Talent Acquisition Cloud 17.4+

15b.9.3+

Yes No No -
Oracle TimesTen

18.1+*

22.1

No No Yes * Requires installation and configuration of the 18.1 client software.
Amazon Aurora Current version No Yes   -
Amazon EMR

4.7.2*

Yes No No * Running Amazon Hadoop 2.7.2 and Hive 1.0.0

Amazon EMR (MapR) No Amazon Machine Image (AMI) 3.3.2 running MapR Hadoop M3 and Hive 0.13.1

Amazon Redshift 1.0.1036 + Yes Yes Yes -
Apache Hive 2.3.0+

3.0+

Yes Yes Yes

Supports saving output from data flows.

Supports Kerberos
Apache Spark SQL

1.6+

3.0

Yes Yes   Supports saving output from data flows.

Supports Kerberos

Aster Database

5.0

6.0

No Yes   -
Cloudera CDH

4.6+

5.5+

No Yes   -
Delta Share         Supports Oracle data sharing.

Share file sizes are subject to a 250 MB limit per partition.

See Connect to a Database Using Delta Sharing.

DropBox Current version Yes No No -
Google Analytics V4 Yes No No -
Google BigQuery

8.0

8.1

Yes Yes Yes See Connect to Google BigQuery.
Google Drive Current version Yes No No -
Green Plum 4.3+ Yes No No -
Hortonworks Hive 1.2+ Yes Yes Yes

Supports saving output from data flows.

Supports Kerberos authentication for datasets
HP Vertica 7+ No No Yes -
IBM BigInsights Hive 1.2+ Yes No No Supports Kerberos authentication for datasets
IBM DB2

11.5+

Yes Yes Yes -
IBM Netezza NPS

NPS 6+

NPS 7+

NPS 11+

No No Yes -
Impala (Cloudera) 2.7+ Yes Yes Yes -
Informix

12.10+

Yes No No -
JDBC - Yes No Yes See Connect to Data Using JDBC.
MapR Hive 1.2+ Yes Yes Yes

Supports saving output from data flows.

Supports Kerberos authentication for datasets
Microsoft Access

2013

2016

No No Yes -
Microsoft Azure SQL Database Current version Yes* No No * Use the SQL Server connection type on the Create Connection page.

SSL is mandatory.

Microsoft Azure Synapse Analytics Current version Yes No No -
Microsoft Excel

2013

2016

Yes No No -
Microsoft SQL Server Analysis Services 2014

2016

2017

2019

No No Yes Connectivity is through XML for Analysis (XMLA). You must configure XMLA access to Microsoft SQL Server Analysis Services.
Microsoft SQL Server 2014

2016

2017

2019

Yes* Yes* Yes * Supports case sensitive and case insensitive collation.
MongoDB

3.2.5

Yes Yes Yes -
MySQL

5.6+

5.7+

8.0+

Yes Yes Yes -
MySQL Heatwave 8.0.31+ Yes No Yes Current latest cloud version supported.
OData 2.0 Yes No No -
ODBC - Yes No Yes -See Create Generic ODBC Connections.
Pivotal HD Hive - Yes Yes Yes Supports Kerberos authentication for datasets.
PostgreSQL

9.0+

Yes Yes Yes -
Presto DB 0.149+ Yes No No -
Salesforce Current version Yes No No -
Spark 1.6+

3.0

Yes Yes Yes Supports saving output from data flows.
Snowflake Data Warehouse

Current version

Yes Yes Yes -
SQL Server 2014

2016

2017

2019

Yes Yes Yes -
Sybase ASE (Adaptive Server Enterprise)

15.7+

Yes Yes No -
Sybase IQ

16+

Yes No No -
Teradata 16.20

17.x

Yes Yes Yes -
Vertica 9.x

12.x

Yes No Yes -