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 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.

See Create Connections to Oracle Autonomous Data Warehouse.

Oracle Content and Experience - Yes No -
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 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.

See Create Database Connections.

Oracle Analytics Cloud – Essbase

Oracle Essbase 11.1.2.4.0+

Oracle Analytics Cloud – Essbase

Yes Yes

See Create Connections to Oracle Essbase.

Oracle Netsuite Netsuite Release 2019.2 (JDBC Driver 8.10.85.0) Yes Yes See Connect to NetSuite Data Sources.
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 -
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 (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 Support

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

Certification - 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