Supported Data Sources

With Oracle Analytics you can connect to a wide range of data sources.

Notes for Reading 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).
  • Data Sets - "Yes" means that you can connect to a data source and visualize data of that type. Data sets are displayed on the Data page in Oracle Analytics Cloud.
  • Data Models - "Yes" means that you can connect to the semantic layer of a data source and model the data of that type.
  • Remote Connectivity Data Sets - "Yes" means that if your administrator has set up and enabled data connectivity, you can visualize on-premises data of that type. You’ll see a check box named Use Remote Data Connectivity on the Create Connection dialog that you select to indicate that the database is on-premises.
  • Remote Connectivity Data Models - "Yes" means that if your administrator has set up and enabled data connectivity, you can model on-premises data of that type. You create a physical data connection in Oracle Analytics Developer Client Tool (also known as Administration Tool) to enable you to model on-premises data.

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 Data Sets Remote Connectivity Data Models SSL More Information
Oracle Applications 11.1.1.9+ or Oracle Fusion Applications Release 8 and later Yes No Yes* No Yes

* Remote connectivity for data sets is only available using Data Gateway for Linux.

Connector supports several Oracle Applications Cloud.

See Oracle Applications Connector.

See also Create an Oracle Applications Connection.

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

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 Connect to Oracle Autonomous Data Warehouse.

Oracle Autonomous Transaction Processing Current version Yes Yes Yes Yes Yes

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 Database 11.2.0.4+

12.1+

12.2+

18+

19+

Yes Yes Yes Yes Yes

Supports saving output from data flows.

Use the Oracle Database connection type to connect to Oracle Database Classic 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 a Database Connection.

Oracle Enterprise Performance Management Cloud 17.10.34+ Yes Yes No No Yes Oracle Analytics Cloud supports Planning, Financial Consolidation and Close, and Tax Reporting.
Oracle Essbase

Oracle Essbase 11.1.2.4.0+

Yes Yes Yes Yes* No

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

For direct connections, see Create a Connection to Oracle Essbase.

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

Oracle Hyperion Planning 11.1.2.4+ No Yes No No No

-

Oracle NetSuite Release 2019.2 (JDBC Driver 8.10.85.0) Yes No No No Yes * * SSL: Default SSL support by driver.

Enter NetSuite2.com as Data Source. See Connecting to NetSuite.

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

17.4+

15b.9.3+

Yes No No No No

See Connect 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) No Amazon Machine Image (AMI) 3.3.2 running MapR Hadoop M3 and Hive 0.13.1

Yes No Yes No No

Complex data types not supported.

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

2.3.0+

3.0+

Yes

Basic and Kerberos

Yes

Basic

Yes

Basic and Kerberos

Yes

Basic

Yes Supports Kerberos.

Supports saving output from data flows.

CSV File Not applicable Yes No No No No See Add Spreadsheets as Data Sets.
DB2 10.1+

10.5+

Yes No Yes Yes Yes

Supports SSL between Remote Data Connector and Oracle Analytics Cloud.

DropBox Not applicable Yes No No No No

See Connect to Dropbox.

Google Analytics Not applicable Yes No No No No

See Connect to Google Drive or Google Analytics.

Google Drive Not applicable Yes No No No No

See Connect to Google Drive or Google Analytics.

GreenPlum 4.3.8+ Yes No No No No -
HortonWorks Hive 1.2+ Yes

Basic and Kerberos

No Yes No Yes Supports Kerberos.

Supports saving output from data flows.

IBM BigInsights Hive 1.2+ Yes

Basic and Kerberos

No No No Yes Supports Kerberos.
Impala (Cloudera) 2.7+ Yes

Basic and Kerberos

Yes

Basic

Yes

Basic

Yes

Basic

Yes Supports Kerberos.
Informix 12.10+ Yes No No No No -
Local Subject Area in Oracle Analytics Cloud Not applicable Yes Yes No No No

See About Adding a Subject Area as a Data Set.

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

Supports saving output from data flows.

Microsoft Excel File Not applicable Yes No No No No

Only XLSX files (or XLS with unpivoted data).

See Add Spreadsheets as Data Sets.

Microsoft Azure SQL Database Not applicable Yes* No No No Yes**

* Use the SQL Server connection type on the Create Connection page.

** SSL is mandatory.

MongoDB 3.2.5 Yes No No No No

-

MySQL

5.6+

5.7+

Yes* No Yes** Yes** No * Direct connections for data sets are supported for MySQL Enterprise Edition.

** Remote connection supported for all MySQL Editions.

OData 2.0 Yes No No No No -
Pivotal HD Hive Not applicable Yes No Yes No Yes Supports Kerberos.
PostgreSQL 9.0+ Yes No No No No -
Salesforce Not applicable Yes No No No No -
Snowflake 3.2 Yes Yes No Yes* Yes**

* See Create Data Model Connections to Snowflake Data Warehouse.

* SSL is implicit. Connection from Publisher is via one of the data set or data model connections.

Spark

1.6+

Yes No No Yes Yes Supports saving output from data flows.
SQL Server

2014

2016

2017

Yes Yes Yes Yes Yes

-

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

* SSL between Remote Data Connector and Oracle Analytics Cloud.