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 19c and later. 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

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.

See Connect to an Oracle Database.

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 15b.9.3+, 17.4+ 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 11.5+ Yes No -
DataBricks Not applicable Yes No Use the Delta Share connection type. See Connect to a Database Using Delta Sharing.
Delta Share Not applicable Yes No See Connect to a Database Using Delta Sharing.
DropBox - Yes No -
Elastic Search 5.6.4+ Yes - -
Google Analytics Universal Analytics, 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 -
Heatwave 8.0.31+ Yes No -
HortonWorks Hive 1.2+ Yes No Supports Kerberos.

Supports saving output from data flows.

HP Vertica 9.x, 12.x Yes No -
IBM BigInsights Hive 1.2+ Yes No Supports Kerberos.
Impala 2.7+ Yes No
Informix 12.10+ 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+

8.0+

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+

3.0

Yes No

Supports saving output from data flows.

SQL Server

2014, 2016, 2017, 2019

Yes No -
Sybase ASE 15.7+ Yes No -
Sybase IQ 16+ Yes No -
Teradata 16.20, 17.x Yes No -
Teradata Aster

6.10+

Yes No -
Vertica 9.x, 12.x Yes No -

About the Oracle Applications Connector

The "Oracle Applications" connection type (Icon for Oracle Applications connections) 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