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 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 Support. See also Create Oracle Applications Connections. |
| 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 Big Data Cloud | - | Yes | No |
Oracle Big Data Cloud must be integrated with Oracle Identity Cloud Service. Supports saving output from data flows. |
| Oracle Content and Experience | - | Yes | No | - |
| Oracle Database | 11.2.0.4+
12.1+ 12.2+ |
Yes | Yes |
Use the Oracle Database connection type to connect to Oracle Database 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 Service Cloud | 1.2 | Yes | No | - |
| Oracle Talent Acquisition Cloud | - | 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 | - |
| DB2 | 10.1+
10.5+ |
Yes | No | - |
| CSV File | - | Yes | Yes | - |
| 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 | - | - | - |
| MapR Hive | 1.2+ | - | - | Supports Kerberos.
Supports saving output from data flows. |
| Microsoft Access | 2013
2016 |
Yes | No | - |
| Microsoft Excel | - | Yes | Yes | Only XLSX files. |
| MonetDB | 5+ | Yes | No | - |
| MongoDB | 3.2.5 | Yes | No | - |
| MySQL |
5.6+ 5.7+ |
Yes | No | Connections to MySQL Community Edition isn’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 Support
Oracle Applications Connector supports several Oracle SaaS Applications. 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 Cloud service.
Oracle SaaS 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 Desktop supports.
Supported Base Data Types
When reading from a data source, Oracle Analytics Desktop 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 Desktop 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 Desktop 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 Desktop 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 Desktop 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 |