Supported databases for profiling data

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 database or business systems for Talend components.

Tip: If the database you want to connect to is not in the list but has a JDBC driver, like Snowflake, you can use a JDBC connection.

Database name	Database version
Amazon Aurora	Amazon RDS for Aurora MySQL 8 (from 8.0 R2023-06) MySQL 5
Amazon Redshift	Initial release of Amazon Redshift Information noteNote: External tables are supported from Talend Studio 8.0 R2023-07 onwards.
AS/400	V7R1 to V7R3 V6R1 to V7R2
Hive	See Supported Hive distributions for profiling data.
IBM DB2 and IBM DB2 Z/OS	11.1 10.5 Information noteNote: Binary large objects (BLOBs) are not supported.
Impala (a sub-module of Cloudera)	CDP 7.1.1 and later
Informix	11.50
Microsoft SQL Server	Amazon RDS for SQL Server Azure SQL Database Azure Synapse Analytics 2017 2016 2014
MySQL	Amazon RDS for MySQL Amazon RDS for MariaDB Azure Database for MySQL MySQL 8.0 MySQL 5.1/5.5/5.6 MariaDB
Netezza	7.2 6
Oracle with SID	Amazon RDS for Oracle Oracle 19c Oracle 18c Oracle 12c Release 1
Oracle with service name	Amazon RDS for Oracle Oracle 19c Oracle 18c Oracle 12c Release 1
Oracle Custom with SSL	Oracle 18 and later
PostgreSQL	Amazon RDS for PostgreSQL Azure Database for PostgreSQL 12 and later 8.3, 9.1+, and 10 Information noteNote: From Talend Studio 8.0. R2024-03 onwards, only the PostgreSQL versions 12 and later are supported. The earlier versions have been removed. Information noteNote: Foreign tables are supported from Talend Studio 8.0 R2023-07 onwards.
SAP HANA	2.0 SAP HANA is supported for Table, View, and Calculation View schemas.
SQLite	3.6.7
Sybase (ASE and IQ)	16.0 15.7 15.2 12.7 12.5
Teradata	16 15 14 13 12
Vertica	12 9.x

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!