D Data Sources and Data Types Reference
Find out about supported data sources, databases, and data types.
Supported Data Sources
With Oracle Analytics Desktop, you can connect to many different data sources. Data sources are sorted alphabetically by Oracle databases first, then other databases.
| Data Source/Connection Type | Version | Oracle Analytics Desktop for Windows | Oracle Analytics Desktop for Mac | More Information |
|---|---|---|---|---|
| Oracle Applications | Use the Oracle Applications connection type to connect to Oracle Fusion Cloud Applications Suite and on-premises Oracle BI Enterprise Edition deployments. | Yes | Yes |
Connector supports several Oracle SaaS Applications. See About the Oracle Applications Connector. See also Connect to an Application in Oracle Fusion Cloud Applications Suite. |
| Oracle Autonomous Data Warehouse | - | Yes | Yes |
Connection to public IP address only. You can connect to multiple Oracle Autonomous Data Warehouse data sources. Upload a wallet for each connection. Supports saving output from data flows. See Connect to Oracle Autonomous Data Warehouse. As an alternative, you can also connect to Oracle Autonomous Data Warehouse using Delta Sharing. Use the Delta Share connection type. See Connect to a Database Using Delta Sharing. |
| Oracle Database | 11.2.0.4+
12.1+ 12.2+ 18+ 19+ |
Yes | Yes |
Use the Oracle Database connection type to connect to Oracle Database Classic Cloud Service. You can connect to multiple database services. Upload a wallet for each connection. Supports saving output from data flows. Ensure that the appropriate security access rules are in place to allow a network connection to the database service on the database listening port. |
|
Oracle Essbase |
11.1.2.4.0+ 21c |
Yes | Yes |
See Create a Connection to Oracle Essbase. You can't use Oracle Essbase datasets in Data Flows. You can't blend datasets that use Oracle Essbase data sources. |
| Oracle Netsuite | Netsuite Release 2019.2 (JDBC Driver 8.10.85.0) | Yes | Yes | - |
| Oracle Fusion Cloud B2C Service | 1.2 | Yes | No | - |
| Oracle Talent Acquisition | - | Yes | Yes | - |
| Actian Ingres | 5.0+ | Yes | No | - |
| Actian Matrix | 5.0+ | Yes | No | - |
| Actian Vector | 5.0+ | Yes | No | - |
| Amazon Aurora | - | Yes | No | - |
| Amazon EMR |
Amazon EMR 4.7.2 running Amazon Hadoop 2.7.2 and Hive 1.0.0 Amazon EMR (MapR) - Amazon Machine Image (AMI) 3.3.2 running MapR Hadoop M3 and Hive 0.13.1 |
Yes | No |
Complex data types not supported. |
| Amazon Redshift | 1.0.1036 + | Yes | No | - |
| Apache Drill | 1.7+ | Yes | No | - |
| Apache Hive |
2.3.0+ 3.0+ |
Yes | No | Supports Kerberos.
Supports saving output from data flows. |
| Cassandra | 3.10 | Yes | No | - |
| Centrica | TBD | Yes | Yes | - |
| CSV File | - | Yes | Yes | - |
| DB2 | 10.1+
10.5+ |
Yes | No | - |
| DataBricks | - | Yes | No | Use the Delta Share connection type. See Connect to a Database Using Delta Sharing. |
| Delta Share | - | Yes | No | See Connect to a Database Using Delta Sharing. |
| DropBox | - | Yes | No | - |
| Elastic Search | 5.6.4+ | Yes | - | - |
| Google Analytics | V4 | Yes | No | - |
| Google Universal Analytics (Legacy) | Universal Analytics | Yes | No | - |
| Google Cloud | - | Yes | No | - |
| Google Drive | - | Yes | No | - |
| GreenPlum | 4.3.8+ | Yes | No | - |
| HortonWorks Hive | 1.2+ | Yes | No | Supports Kerberos.
Supports saving output from data flows. |
| HP Vertica | 7+ | Yes | No | - |
| IBM BigInsights Hive | 1.2+ | Yes | No | Supports Kerberos. |
| Impala | 2.7+ | Yes | No | |
| Informix | 12.1+ | Yes | No | - |
| JDBC | Generic JDBC driver support | Yes | No | See Connect to Data Using JDBC. |
| MapR Hive | 1.2+ | - | - | Supports Kerberos.
Supports saving output from data flows. |
| Microsoft Access | 2013
2016 |
Yes | No | - |
| Microsoft Azure SQL Database | - | Yes* | TBD | * Use the SQL Server connection type on the Create Connection page. |
| Microsoft Azure Synapse Analytics | - | Yes | Yes | - |
| Microsoft Excel | - | Yes | Yes | Only XLSX files (and XLS with unpivoted data). |
| MonetDB | 5+ | Yes | No | - |
| MongoDB | 3.2.5 | Yes | No | - |
| MySQL |
5.6+ 5.7+ |
Yes | No | Connections to MySQL Community Edition aren't supported. |
| MySQL Heatwave | 8.0.31+Note: (Cloud offering – current latest cloud version supported) | Yes | Yes | - |
| Netezza | 7 | Yes | No | - |
| OData | 4.0+ | Yes | No | - |
| ODBC | Generic ODBC driver support | - | - | - |
| Pivotal HD Hive | - | Yes | No | Supports Kerberos. |
| PostgreSQL | 9.0+ | Yes | No | - |
| Presto | - | Yes | No | - |
| Salesforce | - | Yes | No | - |
| Snowflake Data Warehouse | Current version | Yes | Yes | See Connect to Snowflake Data Warehouse. |
| Spark |
1.6+ |
Yes | No |
Supports saving output from data flows. |
| SQL Server |
2014 2016 |
Yes | No | - |
| Sybase ASE | 15.7+ | Yes | No | - |
| Sybase IQ | 16+ | Yes | No | - |
| Teradata | 14
15 16 16.10 |
Yes | No | - |
| Teradata Aster |
6.10+ |
Yes | No | - |
About the Oracle Applications Connector
The "Oracle Applications" connection type (
) enables you to use Oracle Analytics to visualize data from applications in Oracle
Fusion Cloud Applications Suite. For example, Oracle
Fusion Cloud Financials.You can also use the "Oracle Applications" connection type to connect to your on-premises Oracle BI Enterprise
Edition deployments (if patched to an appropriate level) or connect to another Oracle Analytics service.
You can connect to these applications in Fusion Applications Suite:
-
Oracle Fusion Cloud Financials
-
Oracle Fusion Cloud Human Capital Management
-
Oracle Fusion Cloud Loyalty
-
Oracle Fusion Cloud Procurement
-
Oracle Fusion Cloud Project
-
Oracle Fusion Cloud Supply Chain Planning
-
Oracle Sales Automation
Note:
When you connect to applications in Fusion Applications Suite, you access the data from an Oracle Transactional Business Intelligence report. These reports are subject to caching in Oracle Transactional Business Intelligence, and the data available in Oracle Analytics is based on the cached data. You can't control the cache behavior in Oracle Transactional Business Intelligence from Oracle Analytics.Certification - Supported Data Types
Here're the supported data types for Oracle Analytics.
Supported Base Data Types
When reading from a data source, Oracle Analytics attempts to map incoming data types to the supported data types.
For example, a database column that contains only date values is formatted as a DATE, a spreadsheet column that contains a mix of numerical and string values is formatted as a VARCHAR, and a data column that contains numerical data with fractional values uses DOUBLE or FLOAT.
In some cases Oracle Analytics can’t convert a source data type. To work around this data type issue, you can manually convert a data column to a supported type by entering SQL commands. In other cases, Oracle Analytics can't represent binary and complex data types such as BLOB, JSON, and XML.
Note that some data types aren't supported. You'll see an error message if the data source contains unsupported data types.
Oracle Analytics supports the following base data types:
-
Number Types — SMALLINT, SMALLUNIT, TINYINT, TINYUINT, UINT, BIT, FLOAT, INT, NUMERIC, DOUBLE
-
Date Types — DATE, DATETIME, TIMESTAMP, TIME
-
String Types — LONGVARCHAR, CHAR, VARCHAR
Supported Data Types by Database
Oracle Analytics supports the following data types.
| Database Type | Supported Data Types |
|---|---|
| Oracle |
BINARY DOUBLE, BINARY FLOAT CHAR, NCHAR CLOB, NCLOB DATE FLOAT NUMBER, NUMBER (p,s), NVARCHAR2, VARCHAR2 ROWID TIMESTAMP, TIMESTAMP WITH LOCAL TIMEZONE, TIMESTAMP WITH TIMEZONE |
| DB2 |
BIGINT CHAR, CLOB DATE, DECFLOAT, DECIMAL, DOUBLE FLOAT INTEGER LONGVAR NUMERIC REAL SMALLINT TIME, TIMESTAMP VARCHAR |
| SQL Server |
BIGINT, BIT CHAR DATE, DATETIME, DATETIME2, DATETIMEOFFSET, DECIMAL FLOAT INT MONEY NCHAR, NTEXT, NUMERIC, NVARCHAR, NVARCHAR(MAX) REAL SMALLDATETIME, SMALLINT, SMALLMONEY TEXT, TIME, TINYINT VARCHAR, VARCHAR(MAX) XML |
| MySQL |
BIGINT, BIGINT UNSIGNED CHAR DATE, DATETIME, DECIMAL, DECIMAL UNSIGNED, DOUBLE, DOUBLE UNSIGNED FLOAT, FLOAT UNSIGNED INTEGER, INTEGER UNSIGNED LONGTEXT MEDIUMINT, MEDIUMINT UNSIGNED, MEDIUMTEXT SMALLINT, SMALLINT UNSIGNED TEXT, TIME, TIMESTAMP, TINYINT, TINYINT UNSIGNED, TINYTEXT VARCHAR YEAR |
| Apache Spark |
BIGINT, BOOLEAN DATE, DECIMAL, DOUBLE FLOAT INT SMALLINT, STRING TIMESTAMP, TINYINT VARCHAR |
| Teradata |
BIGINT, BYTE, BYTEINT CHAR, CLOB DATE, DECIMAL, DOUBLE FLOAT INTEGER NUMERIC REAL SMALLINT TIME, TIMESTAMP VARCHAR |