Certification - Supported Data Sources
Here are the supported data sources for the latest update of Oracle Analytics Server.
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 for analysis by creating a connection from the Oracle Analytics home page.
- Use in Data Models - "Yes" means that you can connect to the semantic layer of a data source and model the data of that type. You can use the Console or Oracle Analytics Developer Client Tool to connect.
- In addition to the connections types listed on the Connections page, you can connect remotely to other on-premises data sources using The JDBC connection type. See Connect to Remote Data Using Generic JDBC.
- Your use of third-party data sources is governed by the data source vendor's terms and agreements, and you're responsible for complying with these terms and agreements.
Data Sources Supported for Use with Oracle Analytics Server (sorted alphabetically by Oracle databases first, then other databases)
Note:
To access Cloud databases across the public internet, Oracle Analytics Server must be deployed on a server that doesn't require proxy access. If you're not sure, check with your administrator.| Database | Supported Versions | Datasets | Data Models - Semantic Modeler | Data Models - Model Administration Tool | More Information |
|---|---|---|---|---|---|
| Oracle Database |
12.1+ 12.2+ 19+ 21c 23ai |
Yes | Yes | Yes |
Supports saving output from data flows. |
| Oracle Analytic Views | Oracle Database 19c and later | Yes | No | Yes | See Connect to Oracle Analytic Views. |
| Oracle Applications | 11.1.1.9+ or Oracle Fusion Applications Release 8 and later
Oracle Fusion Cloud Applications Suite, On-premises Oracle BI Enterprise Edition deployments, Another Oracle Analytics service |
Yes | No | No | - |
| Oracle Autonomous Data Warehouse |
18.2.4+ 19c and later 23ai |
Yes | Yes | Yes | Supports saving output from data flows.
You can also connect via Delta Sharing using the Delta Share connection type. See Connect to a Database Using Delta Sharing. |
| Oracle Autonomous Transaction Processing | 19c and later
23ai |
Yes | Yes | Yes | Supports saving output from data flows. |
| Oracle Enterprise Performance Management Cloud | Current version | Yes | Yes | Yes | You can't blend datasets that use Oracle Enterprise Performance Management Cloud data sources. See Connect to Oracle Fusion Cloud Enterprise Performance Management (EPM). |
| Oracle Essbase | 11.1.2.4.0+
21c |
Yes | Yes | Yes | You can't blend datasets that use Oracle Essbase data sources.
Connectivity to a data source in an Essbase cluster (via an Analytic Provider Services (APS) node) isn't supported. |
| Oracle Hyperion Financial Management | 11.1.2.4+
11.2+ |
No | No | Yes | - |
| Oracle Hyperion Planning |
11.1.2.4+ 11.2+ |
No | No | Yes | - |
| Oracle NetSuite | Release 2019.2 (JDBC Driver 8.10.85.0) | Yes | No | No | See Connect to NetSuite Data Sources. |
| Oracle OLAP |
12+ |
No | No | Yes | - |
| Oracle Service Cloud | Current version | Yes | No | No |
- |
| Oracle Talent Acquisition Cloud | 17.4+
15b.9.3+ |
Yes | No | No | - |
| Oracle TimesTen |
18.1+* 22.1 |
No | No | Yes | * Requires installation and configuration of the 18.1 client software. |
| OCI Object Storage | - | Yes | No | No | See Create a Dataset from OCI Object Storage. |
| OCI Data Flow SQL Endpoints | - | Yes | No | No | Use the ODI Data Flow connection type. |
| Amazon EMR |
4.7.2* |
Yes | No | No | * 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 | Yes | Yes | - |
| Apache Hive | 2.3.0+
3.0+ |
Yes | Yes | Yes |
Supports saving output from data flows. Supports Kerberos |
| Apache Spark |
1.6+ 3.0 |
Yes | Yes | Supports saving output from data flows.
Supports Kerberos |
|
| Aster Database |
5.0 6.0 |
No | No | Yes | - |
| Cloudera CDH |
4.6+ 5.5+ |
No | Yes | No | - |
| Delta Share | - | Yes | No | No | Supports Oracle data sharing.
Share file sizes are subject to a 250 MB limit per partition. |
| DropBox | Current version | Yes | No | No | - |
| Google Analytics | V4 | Yes | No | No | - |
| Google BigQuery |
8.0 8.1 |
Yes | Yes | Yes | See Connect to Google BigQuery. |
| Google Drive | Current version | Yes | No | No | - |
| Greenplum | 4.3+ | Yes | No | No | - |
| Hortonworks Hive | 1.2+ | Yes | Yes | Yes |
Supports saving output from data flows. Supports Kerberos authentication for datasets |
| IBM BigInsights Hive | 1.2+ | Yes | Yes | No | Supports Kerberos authentication for datasets |
| IBM DB2 |
11.5+ |
Yes | Yes | Yes | - |
| IBM Netezza NPS |
NPS 6+ NPS 7+ NPS 11+ |
No | No | Yes | - |
| Impala (Cloudera) | 2.7+ | Yes | Yes | Yes | - |
| Informix |
12.10+ |
Yes | Yes | Yes | - |
| JDBC | - | Yes | Yes | No | See Connect to Data Using JDBC. |
| MapR Hive | 1.2+ | Yes | Yes | Yes |
Supports saving output from data flows. Supports Kerberos authentication for datasets |
| Microsoft Access |
2016 |
No | No | Yes | - |
| Microsoft Azure SQL Database | Current version | Yes* | No | No | * Use the SQL Server connection type on the Create Connection page.
SSL is mandatory. |
| Microsoft Azure Synapse Analytics | Current version | Yes | No | No | - |
| Microsoft Excel |
2016 |
Yes | No | No | - |
| Microsoft SQL Server Analysis Services | 2016
2017 2019 2022 |
No | No | Yes | Connectivity is through XML for Analysis (XMLA). You must configure XMLA access to Microsoft SQL Server Analysis Services. |
| MongoDB |
3.2.5 |
Yes | Yes | Yes | - |
| MySQL |
5.6+ 5.7+ 8.0+ |
Yes | Yes | Yes | - |
| MySQL Heatwave | 8.0.31+ | Yes | Yes | Yes | Current latest cloud version supported. |
| OData | 2.0
4.0 |
Yes | No | No | Oracle Analytics doesn’t support the following OData features:
|
| ODBC | - | Yes | No | Yes | -See Create Generic ODBC Connections. |
| Pivotal HD Hive | - | Yes | Yes | Yes | Supports Kerberos authentication for datasets. |
| PostgreSQL |
9.0+ 13 14 15 |
Yes | Yes | Yes | - |
| Presto DB | 0.149+ | Yes | No | No | - |
| REST API | - | Yes | No | No | See Create a Connection to a Data Source with REST Endpoints, and JSON Examples for Common Data Sources with REST Endpoints. |
| Salesforce | Current version | Yes | No | No | - |
| Snowflake Data Warehouse |
Current version |
Yes | Yes | Yes | - |
| Spark | 1.6+
3.0 |
Yes | Yes | Yes | Supports saving output from data flows. |
| SQL Server | 2016
2017 2019 2022 |
Yes* | Yes* | Yes | * Supports case sensitive and case insensitive collation. |
| Sybase ASE (Adaptive Server Enterprise) |
15.7+ |
Yes | Yes | Yes | - |
| Sybase IQ |
16+ |
Yes | Yes | Yes | - |
| Teradata | 16.20
17.x |
Yes | Yes | Yes | - |
| Vertica | 9.x
12.x |
Yes | Yes | Yes | - |