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 | Version | Oracle Analytics Desktop for Windows | Oracle Analytics Desktop for Mac | More Information |
---|---|---|---|---|
Oracle Applications | 11.1.1.9+ or Fusion Applications Release 8 and later | Yes | Yes |
Connector supports several Oracle SaaS Applications. See Oracle Applications Connector. See also Create an Oracle Applications Connection. |
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. |
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 Analytics Cloud – Essbase |
Oracle Essbase 11.1.2.4.0+ Oracle Analytics Cloud – Essbase |
Yes | Yes | |
Oracle Netsuite | Netsuite Release 2019.2 (JDBC Driver 8.10.85.0) | Yes | Yes | See Connecting to NetSuite. |
Oracle Service Cloud | 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 | - |
CSV File | - | Yes | Yes | - |
DB2 | 10.1+
10.5+ |
Yes | No | - |
DropBox | - | Yes | No | - |
Elastic Search | 5.6.4+ | Yes | - | - |
Google 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 | Yes | See Create Generic JDBC Connections. |
MapR Hive | 1.2+ | - | - | Supports Kerberos.
Supports saving output from data flows. |
Microsoft Access | 2013
2016 |
Yes | No | - |
Microsoft Azure SQL Database | 5.6.0 | Yes | TBD | - |
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. |
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 | - |
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 | - |
Oracle Applications Connector
Oracle Applications Connector supports Oracle Applications Cloud. You can also use Oracle Applications Connector to connect to your on-premises Oracle BI Enterprise Edition deployments (if patched to an appropriate level) and another Oracle Analytics service.
Oracle Applications Cloud applications you can connect to:
-
Oracle Sales Cloud
-
Oracle Financials Cloud
-
Oracle Human Capital Management Cloud
-
Oracle Supply Chain Cloud
-
Oracle Procurement Cloud
-
Oracle Project Cloud
-
Oracle Loyalty Cloud
Supported Data Types
Read about the data types that Oracle Analytics supports.
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 |