Supported Data Sources

You can connect to many different data sources.

Data Sources Supported for Use with Oracle Analytics Cloud

Data Source Supported Versions Data Sets Data Models Remote Connection for Data Sets Remote Connection for Data Models SSL More  Information     
Oracle Applications 11.1.1.9+ or Fusion Applications Release 8 and later Yes - - - Yes

Connector supports several Oracle SaaS Applications.

See Oracle Applications Connector Support.

See also Create Oracle Applications Connections.

Oracle Autonomous Data Warehouse 18.2.4-20 and later Yes Yes - - Yes

Connection to public IP address only.

You can have one wallet per Data Set connection, which means you can connect to multiple Oracle Autonomous Data Warehouse or Oracle Database instances.

Only one global wallet is possible for Data Model connections so you can only connect to one Oracle Autonomous Data Warehouse or Oracle Database through the RPD.

See Create Connections to Oracle Autonomous Data Warehouse.

Oracle Autonomous Transaction Processing Current version Yes Yes - - Yes You can have one wallet per Data Set connection, which means you can connect to multiple ADWC or Oracle Database instances. You can only have one global wallet per Data Model connection, which means you can connect to one ADWC or Oracle Database through the RPD. Connection to public IP address only.
Oracle Big Data Cloud 18.2.4-20 Yes - - - Yes

Oracle Analytics Cloud - Classic on Oracle Cloud Infrastructure Classic: Connects to Oracle Big Data Cloud with or without Oracle Identity Cloud Service integration. If your Oracle Big Data Cloud isn’t using Oracle Identity Cloud Service, you must set up the connection to Oracle Big Data Cloud when you create your service with Oracle Analytics Cloud - Classic .

Oracle Analytics Cloud on Oracle Cloud Infrastructure: Oracle Big Data Cloud must be integrated with Oracle Identity Cloud Service.

See Create Connections to Oracle Big Data Cloud.

Oracle Big Data Cloud Service   Yes Yes        
Oracle Database 11.2.0.4+

12.1+

12.2+

Yes Yes Yes Yes Yes

Use the Oracle Database connection type to connect to Oracle Database Cloud Service.

You can connect to multiple database services. Upload a wallet for each connection.

For Data Model connections, you can only have one global wallet per Data Model connection.

Ensure that the appropriate security access rules are in place for Oracle Analytics Cloud to make a network connection to the database service on the database listening port.

See Create Database Connections.

Oracle Content and Experience Cloud - Yes - - - - -
Oracle Essbase

Oracle Essbase 11.1.2.4.0+

Yes Yes Yes Yes -

For direct connections, see Create Connections to Oracle Analytics Cloud – Essbase.

For remote connections, see Create Connections to Oracle Essbase Data on a Private Network.

Oracle Service Cloud 1.2 Yes - - - - -
Oracle Talent Acquisition Cloud

17.4+

15b.9.3+

Yes - - - -

See Create Connections to Oracle Talent Acquisition Cloud.

Oracle Hyperion Planning 11.1.2.4+ - Yes - - -

Oracle Planning and Budgeting Cloud Service - - Yes - - - -
Amazon EMR

Amazon EMR 4.7.2 running Amazon Hadoop 2.7.2 and Hive 1.0.0

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

Yes - - - -

Complex data types not supported.

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

2.3.0+

3.0+

Yes - - Yes - -
DB2 10.1+

10.5+

Yes - Yes Yes Yes*

* SSL between Remote Data Connector and Oracle Analytics Cloud.

DropBox - Yes - - - -

See Create Connections to Dropbox .

Google Analytics - Yes - - - -

See Create Connections to Google Drive or Google Analytics.

Google Drive - Yes - - - -

See Create Connections to Google Drive or Google Analytics.

GreenPlum 4.3.8+ Yes - - - - -
HortonWorks Hive 1.2+ Yes - - - - -
IBM BigInsights Hive 1.2+ Yes - - - - -
Impala 2.7+ Yes - - Yes - -
Informix 12.10+ Yes - - - - -
MapR Hive 1.2+ Yes - - - - -
Microsoft SQL Server Analysis Services (MSAS) MSAS 2016 - Yes - - - -
MongoDB 3.2.5 Yes - - - -

MySQL

5.6+

5.7+

Yes - - Yes* - * Including MySQL Community Edition.
Pivotal HD Hive - Yes - - - - -
PostgreSQL 9.0+ Yes - - - - -
Snowflake 3.16.1 Yes Yes - - Yes* * SSL is implicit. Connection from Oracle BI Publisher is via one of the Data Set or RPD connections.
Salesforce - Yes - - - - -
Spark

1.6+

Yes - - Yes - -
SQL Server

2014

2016

Yes - Yes Yes Yes*

* SSL between Remote Data Connector and Oracle Analytics Cloud.

Sybase ASE 15.7+ Yes - - - - -
Sybase IQ 16+ Yes - - - - -
Teradata - - - Yes Yes Yes*

* SSL between Remote Data Connector and Oracle Analytics Cloud.

OData 2.0 Yes - - - - -
CSV File - Yes - - - - See Add Spreadsheets as Data Sets .
Microsoft Excel File - Yes - - - -

Only XLSX files.

See Add Spreadsheets as Data Sets.

Local Subject Area in Oracle Analytics Cloud - Yes Yes - - -

See About Adding a Subject Area as a Data Set.