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 Datasets - "Yes" means that you can connect to a data source using one of the connectivity options displayed underneath and visualize data of that type. Datasets are displayed on the Data page in Oracle Analytics Cloud. See Connect to Data for Visualizations and Analyses.
  • Use in Semantic 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 Model Administration Tool to connect. See Manage Database Connections for Semantic 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 Datasets 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 Semantic 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 Model Administration Tool to enable you to model on-premises data. See Configure and Register Data Gateway for Reporting.
      Notes:
      • With data flows you can source data from remote databases (using a remote connection with Data Gateway). However, you can't save data to datasets that use remote connections.

    • Data Access options:

      Live only means that in a dataset, the table can only get its data directly from the data source.

      Cache only means that in a dataset, the table can only load or reload its data into cache.

      Live or Cache means that in a dataset the table can access its data in either live mode or cache mode.

      See Specify Whether a Dataset Table Is Cached or Live.

  • In addition to the connections types listed on the Connections page, you can connect remotely to other on-premises data sources using generic JDBC. See Connect to Remote Data Using Generic JDBC.

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

Data Source Supported Versions Use in Datasets Use in Semantic Models Supports SSL More information
Oracle Applications 11.1.1.9+ or Oracle Cloud Applications Release 8 and later Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity*
  • Data access - Cache only
No Yes

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

Connector supports several Oracle Applications Cloud.

See About 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
  • Data access - Live or cache
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes

Supports saving output from data flows.

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

Supports saving output from data flows.

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

** For semantic model connections, you can only have one global wallet per connection, therefore you can only connect to one instance.
OCI Resource (Preview) -Not applicable* No* No Yes * Use this connection type to register Oracle functions for use in data flows. See Create a Connection to Your OCI Tenancy.
Oracle Database

12.1+

12.2+

18+

19+

Yes
Connectivity options:
  • Standard*
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
Yes
Connectivity options:
  • Standard**
  • Private access channel
  • Remote Data Connectivity
Yes

Supports saving output from data flows.

* For dataset connections, you can connect to multiple database instances. Upload a wallet for each connection.

** For semantic model connections, you can only have one global wallet per semantic 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 Connect to an Oracle Database.

Oracle EPM Cloud (for Oracle Enterprise Performance Management Cloud) Latest version Yes
Connectivity options:
  • Standard
  • Data access - Live only
Yes
Connectivity options:
  • Standard
Yes

See Connect to Oracle Enterprise Performance Management Cloud.

You can't use EPM Cloud datasets Data Flows.

You can't blend datasets that use Oracle Enterprise Performance Management data sources.

Oracle Essbase

11.1.2.4.0+

21c

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

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

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

For remote connections via Private Access Channel, see Connect to Private Data Sources Through a Private Access Channel.

You can't use Oracle Essbase datasets in Data Flows.

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

Oracle Hyperion Planning 11.1.2.4+ No Yes
Connectivity options:
  • Standard
  • Data access - Live only
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 Connect to NetSuite.

Oracle B2C Service 1.2 Yes
Connectivity options:
  • Standard
  • Data access - Live or cache
No No -
Oracle Talent Acquisition Cloud

17.4+

15b.9.3+

Yes
Connectivity options:
  • Standard
  • Data access - Live or cache
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
  • Data access - Live or cache
No No

Complex data types not supported.

Amazon Redshift 1.0.1036 + Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity
  • Data access - Live or cache
Yes
Connectivity options:
  • Remote Data Connectivity
Yes -
Apache Hive

2.3.0+

3.0+

Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
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
  • Data access - Cache only
No No See Add Spreadsheets as Datasets.
DropBox - Yes
Connectivity options:
  • Standard
  • Data access - Cache only
No No

See Connect to Dropbox.

Google Analytics - Yes
Connectivity options:
  • Standard
  • Data access - Cache only
No No

See Connect to Google Drive or Google Analytics.

Google BigQuery - Yes
Connectivity options:
  • Data access - Live or cache
No Yes Requires SSL. See Connect to Google BigQuery.
Google Drive - Yes
Connectivity options:
  • Standard
No No

See Connect to Google Drive or Google Analytics.

GreenPlum 4.3.8+ Yes
Connectivity options:
  • Standard
  • Data access - Live or cache
No No -
Hortonworks Hive 1.2+ Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
Yes
Connectivity options:
  • Private access channel
Yes

Supports saving output from data flows.

Supports Kerberos authentication for datasets.

IBM BigInsights Hive 1.2+ Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity
  • Data access - Live or cache
No Yes Supports Kerberos authentication for datasets.
IBM DB2 10.5+

11.1+

Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes

Supports SSL between Data Gateway and Oracle Analytics Cloud.

Impala (Cloudera) 2.7+ Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes * Supports Kerberos authentication using Basic Auth.
Informix 12.10+ Yes
Connectivity options:
  • Standard
  • Data access - Live or cache
No No -
JDBC (Generic) - Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • Data access - Cache only
No - See Connect to Remote Data Using Generic JDBC.
Local Subject Area in Oracle Analytics Cloud - Yes
Connectivity options:
  • Standard
  • Data access - Live or cache
Yes
Connectivity options:
  • Standard
No

See About Adding a Subject Area as a Dataset.

MapR Hive 1.2+ Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
Yes
Connectivity options:
  • Private access channel
Yes

Supports saving output from data flows.

Supports Kerberos authentication for datasets.

Microsoft Excel File - Yes
Connectivity options:
  • Standard
  • Data access - Cache only
No No

Only XLSX files (or XLS with unpivoted data).

See Add Spreadsheets as Datasets.

Microsoft Azure SQL Database - Yes
Connectivity options:
  • Standard*
  • Data access - Live or cache
No Yes**

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

** SSL is mandatory.

Microsoft Azure Synapse Analytics - Yes

Connectivity options:

  • Standard
  • Data access - Live or cache
No Yes -
MongoDB 3.2.5 Yes
Connectivity options:
  • Standard
  • Private access channel
  • Data access - Live or cache
Yes
Connectivity options:
  • Private access channel
No

-

MySQL

5.6+

5.7+

8.0+

Yes *
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
Yes **
Connectivity options:
  • Private access channel
  • Remote Data Connectivity
No * Supports Enterprise Edition Only.

** Supports all Editions.

OData 2.0 Yes
Connectivity options:
  • Standard
  • Data access - Cache only
No No -
Pivotal HD Hive - Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity
  • Data access - Live or cache
No Yes Supports Kerberos authentication for datasets.
PostgreSQL 9.0+ Yes
Connectivity options:
  • Standard
  • Private access channel
  • Data access - Live or cache
Yes
Connectivity options:
  • Private access channel
No -
Salesforce - Yes
Connectivity options:
  • Standard
  • Data access - Live or cache
No No Before you create a Salesforce connection, in the Salesforce application make sure that you enable API access in the administrative permissions for the Salesforce user.
Snowflake Current version Yes *
Connectivity options:
  • Standard
  • Private access channel
  • Data access - Live or cache
Yes **
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes***

* See Connect to Snowflake Data Warehouse.

** See Create Semantic Model Connections to Snowflake Data Warehouse.

*** SSL is implicit. Connection from Publisher is via one of the dataset or semantic model connections.

Spark

1.6+

Yes
Connectivity options:
  • Standard
  • Private access channel
  • Data access - Live or cache
Yes
Connectivity options:
  • Private access channel
  • Remote Data Connectivity
Yes Supports saving output from data flows.
SQL Server

2014

2016

2017

2019

Yes
Connectivity options:
  • Standard *
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
Yes

* In SQL Server, set up a named connection using static port allocation. Dynamic port allocation doesn't work for connecting Oracle Analytics to SQL Server.

Sybase ASE 15.7+ Yes
Connectivity options:
  • Standard
  • Data access - Live or cache
No No -
Sybase IQ 16+ Yes
Connectivity options:
  • Standard
  • Data access - Live or cache
No No -
Teradata 16.20

17.x

Yes
Connectivity options:
  • Remote Data Connectivity
  • Data access - Live or cache
Yes
Connectivity options:
  • Remote Data Connectivity
Yes

-