Supported Data Sources

You can connect to many different data sources.

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

Data Source Supported Versions Data Sets Data Models Remote Connectivity for Data Sets Remote Connectivity 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.

Supports saving output from data flows.

For data set connections, you can have one wallet per connection, which means you can connect to multiple instances.

For data model connections, you can only have one global wallet, therefore you can only connect to one instance.

See Create Connections to Oracle Autonomous Data Warehouse.

Oracle Autonomous Transaction Processing Current version Yes Yes - - Yes

Connection to public IP address only.

Supports saving output from data flows.

For data model connections, you can only have one global wallet per connection, therefore you can only connect to one instance

For data set connections, you can have one wallet per connection, therefore you can connect to multiple instances.

For data model connections, you can only have one global wallet per connection, therefore you can only connect to one instance.
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 - - -

Supports saving output from data flows.

Oracle Content and Experience - Yes - - - - -
Oracle Database 11.2.0.4+

12.1+

12.2+

Yes Yes Yes Yes Yes

Supports saving output from data flows.

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

For data set connections, you can connect to multiple database instances. 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 Essbase

Oracle Essbase 11.1.2.4.0+

Yes Yes Yes* Yes* -

* Use Remote Data Connector to connect remotely to Oracle Essbase, not Data Gateway.

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 Hyperion Planning 11.1.2.4+ - Yes - - -

-

Oracle Netsuite Release 2019.2 (JDBC Driver 8.10.85.0) Yes - - - Yes * * SSL: Default SSL support by driver.
Oracle Planning and Budgeting Cloud Service 17.10.34+ - Yes - - - -
Oracle Service Cloud 1.2 Yes - - - - -
Oracle Talent Acquisition Cloud

17.4+

15b.9.3+

Yes - - - -

See Create Connections to Oracle Talent Acquisition Cloud.

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 Yes Supports Kerberos.

Supports saving output from data flows.

CSV File - Yes - - - - See Add Spreadsheets as Data Sets.
DB2 10.1+

10.5+

Yes - Yes Yes Yes

Supports 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 - - - Yes Supports Kerberos.

Supports saving output from data flows.

IBM BigInsights Hive 1.2+ Yes - - - Yes Supports Kerberos.
Impala 2.7+ Yes - - Yes - -
Informix 12.10+ Yes - - - - -
Local Subject Area in Oracle Analytics Cloud - Yes Yes - - -

See About Adding a Subject Area as a Data Set.

MapR Hive 1.2+ Yes - - - Yes Supports Kerberos.

Supports saving output from data flows.

Microsoft Excel File - Yes - - - -

Only XLSX files.

See Add Spreadsheets as Data Sets.

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.
OData 2.0 Yes - - - - -
Pivotal HD Hive - Yes - - - Yes Supports Kerberos.
PostgreSQL 9.0+ Yes - - - - -
Salesforce - Yes - - - - -
Snowflake 3.16.1 Yes Yes - - Yes* * SSL is implicit. Connection from BI Publisher is via one of the data set or data model connections.
Spark

1.6+

Yes - - Yes Yes Supports saving output from data flows.
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 16.20 - - Yes Yes Yes*

* SSL between Remote Data Connector and Oracle Analytics Cloud.