Supported Data Sources

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

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 Data Sets - "Yes" means that you can connect to a data source using one of the connectivity options displayed underneath and visualize data of that type. Data sets are displayed on the Data page in Oracle Analytics Cloud. See Connect to Data for Visualizations and Analyses.
  • Use in Data Models - "Yes" means that you can connect to the semantic layer of a data source using one of the connectivity options displayed underneath and model the data of that type. You can use the Console or Oracle Analytics Developer Client Tool to connect. See Manage Database Connections for Data Models and Connect to a Data Source using a Connection Defined Through Console.
  • Connectivity Options:
    • Standard means that the data source host is accessible via the public Internet.
    • Private access channel means that Oracle Analytics Cloud can access data on a private host over a private access channel. You can use a private access channel to connect to private data sources that are within your virtual cloud network (VCN) on Oracle Cloud Infrastructure or other networks peered to the VCN such as your corporate network. See Connect to Private Data Sources Through a Private Access Channel.
    • Remote Data Connectivity:
      • In the Use in Data Sets column, this means that if your administrator has set up and enabled remote 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.
      • In the Use in Data Models column, this means that if your administrator has set up and enabled remote data connectivity, you can model on-premises data of that type. You create a physical data connection using Oracle Analytics Developer Client Tool (also known as Administration Tool) to enable you to model on-premises data.

      Note: Unless specified otherwise, the Remote Data Connectivity option includes both Data Gateway and Remote Data Connector.

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

Data Source Supported Versions Use in Data Sets Use in Data Models Supports SSL More information
Oracle Applications 11.1.1.9+ or Oracle Fusion Applications Release 8 and later Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity*
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

19c

Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes

Supports saving output from data flows.

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 19c Yes
Connectivity options:
  • Standard*
  • Private access channel
  • Remote Data Connectivity
Yes
Connectivity options:
  • Standard**
  • Private access channel
  • Remote Data Connectivity
Yes

Supports saving output from data flows.

* 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
Connectivity options:
  • Standard*
  • Private access channel
  • Remote Data Connectivity
Yes
Connectivity options:
  • Standard**
  • Private access channel
  • Remote Data Connectivity
Yes

Supports saving output from data flows.

* 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.

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

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 connection for an Oracle Database.

Oracle Enterprise Performance Management Cloud Latest version Yes
Connectivity options:
  • Standard
Yes
Connectivity options:
  • Standard
Yes

EPM Cloud data sets cannot be used in Data Flows.

Oracle Essbase

Oracle Essbase 11.1.2.4.0+

Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
No

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 Essbase data sets cannot be used in Data Flows.

Oracle Hyperion Planning 11.1.2.4+ No Yes
Connectivity options:
  • Standard
No

-

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

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

Oracle Service Cloud 1.2 Yes
Connectivity options:
  • Standard
No No -
Oracle Talent Acquisition Cloud

17.4+

15b.9.3+

Yes
Connectivity options:
  • Standard
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
Connectivity options:
  • Standard
  • Remote Data Connectivity
No No

Complex data types not supported.

Amazon Redshift 1.0.1036 + Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity
Yes
Connectivity options:
  • Remote Data Connectivity
Yes -
Apache Hive

2.3.0+

3.0+

Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes

Supports saving output from data flows.

Supports Kerberos.

CSV File - Yes
Connectivity options:
  • Standard
No No See Add Spreadsheets as Data Sets.
DB2 10.1+

10.5+

Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes

Supports SSL between Remote Data Connector and Oracle Analytics Cloud.

DropBox - Yes
Connectivity options:
  • Standard
No No

See Connect to Dropbox.

Google Analytics - Yes
Connectivity options:
  • Standard
No No

See Connect to Google Drive or Google Analytics.

Google Drive - Yes
Connectivity options:
  • Standard
No No

See Connect to Google Drive or Google Analytics.

GreenPlum 4.3.8+ Yes
Connectivity options:
  • Standard
No No -
HortonWorks Hive 1.2+ Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes
Connectivity options:
  • Private access channel
Yes

Supports saving output from data flows.

Supports Kerberos authentication for data sets.

IBM BigInsights Hive 1.2+ Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity
No Yes Supports Kerberos authentication for data sets.
Impala (Cloudera) 2.7+ Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes * Supports Kerberos authentication Basic Auth.
Informix 12.10+ Yes
Connectivity options:
  • Standard
No No -
Local Subject Area in Oracle Analytics Cloud - Yes
Connectivity options:
  • Standard
Yes
Connectivity options:
  • Standard
No

See About Adding a Subject Area as a Data Set.

MapR Hive 1.2+ Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes
Connectivity options:
  • Private access channel
Yes

Supports saving output from data flows.

Supports Kerberos authentication for data sets.

Microsoft Excel File - Yes
Connectivity options:
  • Standard
No No

Only XLSX files (or XLS with unpivoted data).

See Add Spreadsheets as Data Sets.

Microsoft Azure SQL Database - Yes
Connectivity options:
  • Standard*
No Yes**

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

** SSL is mandatory.

MongoDB 3.2.5 Yes
Connectivity options:
  • Standard
  • Private access channel
Yes
Connectivity options:
  • Private access channel
No

-

MySQL

5.6+

5.7+

8.0+

Yes
Connectivity options:
  • Standard*
  • Private access channel
  • Remote Data Connectivity*
Yes
Connectivity options:
  • Private access channel
  • Remote Data Connectivity**
No * Supports Enterprise Edition Only (5.6+ and 5.7+).

** Supports all Editions (5.6+ and 5.7+).

OData 2.0 Yes
Connectivity options:
  • Standard
No No -
Pivotal HD Hive - Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity
No Yes Supports Kerberos authentication for data sets.
PostgreSQL 9.0+ Yes
Connectivity options:
  • Standard
  • Private access channel
Yes
Connectivity options:
  • Private access channel
No -
Salesforce - Yes
Connectivity options:
  • Standard
No No -
Snowflake Current version Yes
Connectivity options:
  • Standard
  • Private access channel
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity*
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
Connectivity options:
  • Standard
  • Private access channel
Yes
Connectivity options:
  • Private access channel
  • Remote Data Connectivity
Yes Supports saving output from data flows.
SQL Server

2014

2016

2017

Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes

-

Sybase ASE 15.7+ Yes
Connectivity options:
  • Standard
No No -
Sybase IQ 16+ Yes
Connectivity options:
  • Standard
No No -
Teradata 16.20 Yes
Connectivity options:
  • Remote Data Connectivity
Yes
Connectivity options:
  • Remote Data Connectivity
Yes

-