Supported Data Sources

With Oracle Analytics Cloud 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.
  • Use in Semantic Modeler - "Yes" means that Semantic Modeler supports this data source type. "No" means that you should use Model Administration Tool to model data of this type until it's supported by Semantic Modeler in a future update.

    Note: When Oracle Analytics is deployed as part of other services such as Fusion Analytics Warehouse or NetSuite Analytics Warehouse, you can't connect to the semantic model. Therefore you can ignore the Use in Semantic Modeler column in the following table.

  • Use in Model Administration Tool - "Yes" means that Model Administration Tool supports this data source type. If it's also supported by Semantic Modeler, we recommend that you use Semantic Modeler.

    Note: When Oracle Analytics is deployed as part of other services such as Fusion Analytics Warehouse or NetSuite Analytics Warehouse, you can't connect to the RPD. Therefore you can ignore the Use in Model Administration Tool column in the following table.

  • 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 Modeler or Use in Model Administration Tool columns, this means that if your administrator has set up and enabled remote data connectivity, you can model on-premises data of that type. 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.

    • System Connection means that data modelers can connect to a semantic model using connection details copied from an Oracle Analytics Cloud connection. For supported data sources, data modelers copy the Object ID from the Inspect pane into Semantic Modeler. If you're using Model Administration Tool, copy the Object ID into the Connection Pool dialog. See Connect to a Data Source Using a Data Connection.
  • Oracle Analytics Cloud supports Transport Layer Security (TLS) for all data sources.
  • 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/ Connection Type Versions Use in Datasets Use in Semantic Modeler (specific to Oracle Analytics Cloud) Use in Model Administration Tool (specific to Oracle Analytics Cloud) More information
Oracle Analytic Views Oracle Database 19c Yes
Connectivity options:
  • Standard
  • Data access - Live
No Yes
Connectivity options:
  • Standard
See Connect to Oracle Analytic Views.
Oracle Applications Oracle Fusion Cloud Applications Suite

On-premises Oracle BI Enterprise Edition deployments

Another Oracle Analytics service

Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity*
  • Data access - Cache only
No No

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

Connector supports several applications in Fusion Applications Suite.

See About the Oracle Applications Connector.

See also Connect to an Application in Oracle Fusion Cloud Applications Suite.

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

  • Remote Data Connectivity

  • System Connection

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

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

  • Remote Data Connectivity

  • System Connection

Yes
Connectivity options:
  • Standard**

  • Private access channel

  • Remote Data Connectivity

  • System Connection

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.

See Connect to Oracle Autonomous Transaction Processing.

OCI Resource (Preview) -Not applicable* No* No No * 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
  • Remote Data Connectivity
  • System Connection
Yes
Connectivity options:
  • Standard**
  • Private access channel
  • Remote Data Connectivity
  • System Connection

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 Fusion Cloud Enterprise Performance Management) Latest version Yes
Connectivity options:
  • Standard
  • Data access - Live only
No Yes
Connectivity options:
  • Standard

See Connect to Oracle Fusion Cloud Enterprise Performance Management (EPM).

You can't use Oracle Fusion Cloud Enterprise Performance Management (EPM) datasets in Data Flows.

You can't blend datasets that use Oracle Fusion Cloud Enterprise Performance Management (EPM) data sources.

Oracle Essbase

11.1.2.4.0+

21c

Yes
Connectivity options:
  • Standard

  • Private access channel

  • Remote Data Connectivity

  • Data access - Live only

No Yes
Connectivity options:
  • Standard

  • Private access channel

  • Remote Data Connectivity

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

-

Oracle NetSuite Release 2019.2 (JDBC Driver 8.10.85.0) Yes
Connectivity options:
  • Standard
No No Enter NetSuite2.com as Data Source. See Connect to NetSuite.
Oracle Fusion Cloud 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

4.7.2 *

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

Complex data types not supported.

* 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

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

  • Remote Data Connectivity

  • System Connection

Yes
Connectivity options:
  • Remote Data Connectivity *

  • System Connection

* See JDBC and JNDI Templates and Examples.
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
  • Remote Data Connectivity
  • System Connection
Yes
Connectivity options:
  • Standard

  • Private access channel

  • Remote Data Connectivity

  • System Connection

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.
Delta Share - Yes
Connectivity options:
  • Standard
  • Data access - Cache only
No No -
DropBox - Yes
Connectivity options:
  • Standard
  • Data access - Cache only
No No

See Connect to Dropbox.

Google Analytics Universal Analytics

Google Analytics V4

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
Yes
Connectivity options:
  • System Connection
Yes
Connectivity options:
  • System Connection
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:
  • Standard
Yes
Connectivity options:
  • Private access channel
  • System Connection

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 No Supports Kerberos authentication for datasets.
IBM DB2 11.5+ Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity
  • System Connection
Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • System Connection

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

See Create a Dataset from a Local Subject Area.

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

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 No

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

Microsoft Azure Synapse Analytics - Yes

Connectivity options:

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

-

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:
  • Standard
  • Remote Data Connectivity
  • System Connection
Yes **
Connectivity options:
  • Private access channel
  • Remote Data Connectivity
  • System Connection
* Supports Enterprise Edition Only.

** Supports all Editions.

MySQL HeatWave

8.0.31+

Yes
Connectivity options:
  • Standard
  • Private access channel
  • Data access - Live or cache
No Yes
Connectivity options:
  • Private access channel
  • System Connection
Note: (Cloud offering – current latest cloud version supported)
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
Yes
Connectivity options:
  • Standard
Yes
Connectivity options:
  • Standard
Supports Kerberos authentication for datasets.
PostgreSQL 9.0+ Yes
Connectivity options:
  • Standard
  • Private access channel
  • Data access - Live or cache
Yes
Connectivity options:
  • System Connection
Yes
Connectivity options:
  • Private access channel
  • System Connection
-
REST API Not applicable. Yes
Connectivity options:
  • Standard
  • Private access channel
No No Connect to wide range of data sources that have REST endpoints available. See Create a Connection to a Data Source with REST Endpoints.

See JSON Examples for Common Data Sources with REST Endpoints (Preview).

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

* See Connect to Snowflake Data Warehouse.

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

Spark

1.6+

3.0

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

Supports Kerberos.

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

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

Sybase ASE 15.7+ Yes
Connectivity options:
  • Standard
  • Data access - Live or cache
Yes
Connectivity options:
  • Standard
  • Remote Data Connectivity
  • System Connection
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
Connectivity options:
  • Remote Data Connectivity
  • System Connection

-

Vertica 9.x

12.x

Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity *
  • Data access - Live or cache
No Yes
Connectivity options:
  • Standard
  • Private access channel
  • Remote Data Connectivity *
  • System Connection
* Remote connectivity for datasets is only available using Data Gateway

Server-Side SSL support only – no support for Mutual-TLS.