This topic provides details about supported data sources, databases, and data types.
Here are the supported data sources and version numbers.
Data Sources Supported for Use with Oracle Data Visualization for BI EE
| Supported Data Source | Version |
|---|---|
| Oracle Applications | 11.1.1.9+ or Fusion Applications Release 8 and later
This connector only supports specific Oracle SaaS Applications. See Oracle Applications Connector Support. |
| Oracle Autonomous Data Warehouse Cloud | NA |
| Oracle Big Data Cloud (Beta) | NA |
| Oracle Database | 11.2.0.4+
12.1+ 12.2+ |
| Oracle Content and Experience Cloud | NA |
| Oracle Essbase | Essbase 11.1.2.4.0+ |
| Oracle Service Cloud | NA |
| Oracle Talent Acquisition Cloud (Beta) | 15b.9.3+ |
| Actian Ingres | 5.0+ |
| Actian Matrix | 5.0+ |
| Actian Vector | 5.0+ |
| Amazon Aurora | NA |
| Amazon EMR |
|
| Amazon Redshift | 1.0.1036 + |
| Apache Drill | 1.7+ |
| Apache Hive | 1.2.1+
Supported version:
|
| Cassandra | 3.10 |
| IBM DB2 | 10.1+
10.5+ |
| CSV File | NA |
| DropBox | NA |
| Google Analytics | NA |
| Google Cloud SQL | NA |
| Google Drive | NA |
| GreenPlum | 4.3.8+ |
| HortonWorks Hive | 1.2+ |
| HP Vertica | 7+ |
| IBM BigInsights Hive | 1.2+ |
| Impala | 2.7+ |
| Informix | 12+ |
| MapR Hive | 1.2+ |
| Microsoft Access | 2013
2016 |
| Microsoft Excel | Any version that uses XLSX files. |
| MonetDB | 5+ |
| MongoDB | 3.2.5 |
| MySQL | 5.1+
5.6+ |
| Netezza | 7 |
| Pivotal HD Hive | NA |
| PostGreSQL | 9.5+ |
| Presto | NA |
| Salesforce | NA |
| Spark | 1.6+
2.0 2.1+ |
| SQL Server | 2008
2012 2016 |
| Sybase ASE | 16+ |
| Sybase IQ | 16+ |
| Teradata | 14
15 16 16.10 |
| Teradata Aster |
6.10+ |
| Elastic Search | 5.6.4+ |
| JDBC | Generic JDBC driver support |
| OData | 4.0+ |
| ODBC | Generic ODBC driver support |
Data Visualization provides limited support for databases marked with the Beta label.
In the Create New Connection dialog, some of the databases might be marked Beta. The Beta label indicates that the database has been tested, but isn’t fully supported. Data sources created from databases marked as Beta might contain undocumented limitations and you should use them as is.
Oracle Applications Connector supports only the following Oracle SaaS Applications.
Oracle Sales Cloud
Oracle Financials Cloud
Oracle HCM Cloud
Oracle Supply Chain Cloud
Oracle Procurement Cloud
Oracle Project Cloud
Oracle Loyalty Cloud
This section contains information about the data types that Data Visualization supports and doesn’t support.
Some data types aren’t supported.
You'll see an error message if the data source contains data types that Data Visualization doesn't support.
When reading from a data source, Data Visualization 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 Data Visualization 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, Data Visualization can't represent binary and complex data types such as BLOB, JSON, and XML.
Data Visualization 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
Data Visualization 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 |