The table below lists the databases supported from the Profiling perspective of Talend Studio. For a complete list about supported third-party systems, see Supported systems, databases and business applications by Talend components.
| Database name | Database version |
|---|---|
| Amazon Redshift | Initial release of Amazon Redshift |
| AS/400 | V6R1 to V7R2 (Deprecated versions: V5R2 to V5R4/V5R3 to V6R1) |
| Hive | For a complete list of the supported Hive distributions, see Supported Hive distributions for profiling data. |
| IBM DB2 and IBM DB2 Z/OS | 10.5 (Deprecated version: 10.1) |
| Impala (a sub-module of Cloudera) | CDH5.1 and above MapR 5.1.0 MapR 5.2.0 MapR 6.0.0 |
| Informix | 11.50 |
| Ingres | Deprecated version: 9.2 |
| Microsoft SQL Server | 2014 2016 2017 (Deprecated versions: 2000/2003/2005/2008/2012) |
| MySQL | MySQL 5.1/5.5/5.6 MySQL 8.0 MariaDB (Deprecated version: MySQL 4) |
| Netezza | 6 |
| Oracle with SID | Oracle 12c Release 1 (Deprecated versions: Oracle 9i/Oracle 10g/Oracle 11g) |
| Oracle with service name | Oracle 12c Release 1 (Deprecated versions: Oracle 9i/Oracle 10g/Oracle 11g) |
| PostgreSQL | 8.3 9.1+ 10 |
| SQLite | 3.6.7 |
| Sybase (ASE and IQ)QLite | 12.5 12.7 15.2 |
| Teradata | 12 13 14 15 |
| Vertica | 9.0.x (Deprecated versions: 3/3.5/4/4.1/5.0/5.1/6.0/6.1.x/7.0.x/7.1.x) |