Database Connection Options
When you specify connection details using the Create Connection dialog or Inspect dialog, some database types have extra configuration options.
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.
- 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.
- In addition to the connections types listed on the Connections page, you can connect remotely to other on-premises data sources 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 | Supported Versions | Use in Datasets | Use in Semantic Modeler (specific to Oracle Analytics Cloud) | Use in Model Administration Tool (specific to Oracle Analytics Cloud) | Supports SSL | More information |
|---|---|---|---|---|---|---|
| Oracle Analytic Views | Oracle Database 19c | Yes
Connectivity options:
|
No | Yes
Connectivity options:
|
No | See Connect to Oracle Analytics Views. |
| Oracle Applications | Oracle
Fusion Cloud Applications Suite
On-premises Oracle BI Enterprise Edition deployments Another Oracle Analytics service |
Yes
Connectivity options:
|
No | No | Yes |
* 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:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
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. |
| Oracle Autonomous Transaction Processing | 19c | Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
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 | 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:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
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. |
| Oracle EPM Cloud (for Oracle Fusion Cloud Enterprise Performance Management) | Latest version | Yes
Connectivity options:
|
No | Yes
Connectivity options:
|
Yes |
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:
|
No | Yes
Connectivity options:
|
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 | No | Yes
Connectivity options:
|
No |
- |
| Oracle NetSuite | Release 2019.2 (JDBC Driver 8.10.85.0) | Yes
Connectivity options:
|
No | No | Yes * | * SSL: Default SSL support by driver.
Enter NetSuite2.com as Data Source. |
| Oracle Fusion Cloud B2C Service | 1.2 | Yes
Connectivity options:
|
No | No | No | - |
| Oracle Talent Acquisition Cloud |
17.4+ 15b.9.3+ |
Yes
Connectivity options:
|
No | No | No | |
| 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:
|
No | No | No |
Complex data types not supported. |
| Amazon Redshift | 1.0.1036 + | Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes | - |
| Apache Hive |
2.3.0+ 3.0+ |
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes |
Supports saving output from data flows. Supports Kerberos. |
| CSV File | - | Yes
Connectivity options:
|
No | No | No | See Add Spreadsheets as Datasets. |
| DropBox | - | Yes
Connectivity options:
|
No | No | No |
See Connect to Dropbox. |
| Google Analytics | Universal Analytics | Yes
Connectivity options:
|
No | No | No | |
| Google BigQuery | - | Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes | Requires SSL. |
| Google Drive | - | Yes
Connectivity options:
|
No | No | No | |
| GreenPlum | 4.3.8+ | Yes
Connectivity options:
|
No | No | No | - |
| Hortonworks Hive | 1.2+ | Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes |
Supports saving output from data flows. Supports Kerberos authentication for datasets. |
| IBM BigInsights Hive | 1.2+ | Yes
Connectivity options:
|
No | No | Yes | Supports Kerberos authentication for datasets. |
| IBM DB2 | 10.5+
11.1+ |
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes |
Supports SSL between Data Gateway and Oracle Analytics Cloud. |
| Impala (Cloudera) | 2.7+ | Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes | * Supports Kerberos authentication using Basic Auth. |
| Informix | 12.10+ | Yes
Connectivity options:
|
No | No | No | - |
| JDBC (Generic) | - | Yes
Connectivity options:
|
No | No | - | See Connect to Remote Data Using Generic JDBC. |
| Local Subject Area in Oracle Analytics Cloud | - | Yes
Connectivity options:
|
No | No | No | |
| MapR Hive | 1.2+ | Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes |
Supports saving output from data flows. Supports Kerberos authentication for datasets. |
| Microsoft Excel File | - | Yes
Connectivity options:
|
No | No | No |
Only XLSX files (or XLS with unpivoted data). |
| Microsoft Azure SQL Database | - | Yes
Connectivity options:
|
No | No | Yes** |
* Use the SQL Server connection type on the Create Connection page. ** SSL is mandatory. |
| Microsoft Azure Synapse Analytics | - | Yes
Connectivity options:
|
No | No | Yes | - |
| MongoDB | 3.2.5 | Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
No |
- |
| MySQL |
5.6+ 5.7+ 8.0+ |
Yes
*
Connectivity options:
|
Yes
Connectivity options:
|
Yes **
Connectivity options:
|
Yes | * Supports Enterprise Edition Only.
** Supports all Editions. |
| MySQL Heatwave |
8.0.31+Note: (Cloud offering – current latest cloud version supported) |
Yes
Connectivity options:
|
No | Yes
Connectivity options:
|
Yes | - |
| OData | 2.0 | Yes
Connectivity options:
|
No | No | No | - |
| Pivotal HD Hive | - | Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes | Supports Kerberos authentication for datasets. |
| PostgreSQL | 9.0+ | Yes
Connectivity options:
|
No | Yes
Connectivity options:
|
Yes | - |
| REST API | Yes | No | 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 (Preview). | |
| Salesforce | - | Yes
Connectivity options:
|
No | 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:
|
Yes
Connectivity options:
|
Yes **
Connectivity options:
|
Yes*** |
* See Connect to Snowflake Data Warehouse. ** See Create Semantic Model Connections to Snowflake Data Warehouse. *** SSL is implicit. Connection from BI Publisher is via one of the dataset or semantic model connections. |
| Spark |
1.6+ 3.0 |
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes | Supports saving output from data flows.
Supports Kerberos. |
| SQL Server |
2014 2016 2017 2019 |
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes |
* 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:
|
Yes
Connectivity options:
|
No | No | - |
| Sybase IQ | 16+ | Yes
Connectivity options:
|
No | No | No | - |
| Teradata | 16.20
17.x |
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes
Connectivity options:
|
Yes |
- |
| Vertica | 9.x
12.x |
Yes
Connectivity options:
|
No | Yes
Connectivity options:
|
Yes ** | * Remote connectivity for datasets is only available
using Data Gateway
** Server-Side SSL support only – no support for Mutual-TLS. |