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, you can use a JDBC connection.

Database name	Database version
Amazon Aurora	Amazon RDS for Aurora MySQL 8 MySQL 5 (deprecated)
Amazon Redshift	Initial release of Amazon Redshift Information noteNote: External tables are supported.
AS/400	V7R3 and later V6R1 to V7R2 (deprecated)
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 (deprecated) MariaDB
Netezza	7.2 6
Oracle with SID	Amazon RDS for Oracle Oracle 23ai Vector and JSON data types are not supported. Oracle 19c Oracle 18c
Oracle with service name	Amazon RDS for Oracle Oracle 23ai Vector and JSON data types are not supported. Oracle 19c Oracle 18c
Oracle Custom with SSL	Oracle 18 and later
PostgreSQL	Amazon RDS for PostgreSQL Azure Database for PostgreSQL 12 and later Information noteNote: Foreign tables are supported.
SAP HANA	2.0 SAP HANA is supported for Table, View, and Calculation View schemas.
Availability-noteBeta Snowflake	Not applicable Information noteRestriction: You can only use the basic authentication and profile column analyses.
SQLite	3.6.7
Sybase (ASE and IQ)	16.0
Teradata	16 15 14 13 12
Vertica	12 9.x (deprecated)

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 – please let us know!