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 to other data sources using the JDBC connection type.
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+ 18+ 19+ 21+ |
Yes | Yes | Yes |
Supports saving output from data flows. |
| Oracle Applications | Oracle Fusion Applications Release 8 and later | Yes | No | No | - |
| Oracle Autonomous Data Warehouse | 18.2.4+
19+ |
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 | Yes | Yes | Yes | Supports saving output from data flows. |
| Oracle Enterprise Performance Management Cloud | Current version | Yes | No | Yes | You can't blend datasets that use Oracle Enterprise Performance Management Cloud data sources. |
| Oracle Essbase | 11.1.2.4.0+
21c |
Yes | No | 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+ 18+ |
No | No | Yes | - |
| Oracle Service Cloud | 1.2 | 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. |
| Amazon Aurora | Current version | No | Yes | - | |
| 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 SQL |
1.6+ 3.0 |
Yes | Yes | Supports saving output from data flows.
Supports Kerberos |
|
| Aster Database |
5.0 6.0 |
No | Yes | - | |
| Cloudera CDH |
4.6+ 5.5+ |
No | Yes | - | |
| Delta Share | 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 | - |
| Green Plum | 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 | No | 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 | No | No | - |
| JDBC | - | Yes | No | Yes | 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 |
2013 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 |
2013 2016 |
Yes | No | No | - |
| Microsoft SQL Server Analysis Services | 2014
2016 2017 2019 |
No | No | Yes | Connectivity is through XML for Analysis (XMLA). You must configure XMLA access to Microsoft SQL Server Analysis Services. |
| Microsoft SQL Server | 2014
2016 2017 2019 |
Yes* | Yes* | Yes | * Supports case sensitive and case insensitive collation. |
| MongoDB |
3.2.5 |
Yes | Yes | Yes | - |
| MySQL |
5.6+ 5.7+ 8.0+ |
Yes | Yes | Yes | - |
| MySQL Heatwave | 8.0.31+ | Yes | No | Yes | Current latest cloud version supported. |
| OData | 2.0 | Yes | No | No | - |
| ODBC | - | Yes | No | Yes | -See Create Generic ODBC Connections. |
| Pivotal HD Hive | - | Yes | Yes | Yes | Supports Kerberos authentication for datasets. |
| PostgreSQL |
9.0+ |
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 | - |
| Spark | 1.6+
3.0 |
Yes | Yes | Yes | Supports saving output from data flows. |
| Snowflake Data Warehouse |
Current version |
Yes | Yes | Yes | - |
| SQL Server | 2014
2016 2017 2019 |
Yes | Yes | Yes | - |
| Sybase ASE (Adaptive Server Enterprise) |
15.7+ |
Yes | Yes | No | - |
| Sybase IQ |
16+ |
Yes | No | No | - |
| Teradata | 16.20
17.x |
Yes | Yes | Yes | - |
| Vertica | 7.x
9.x 12.x |
Yes | No | Yes | - |