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.
Information noteTip: 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 |
|
| Hive | See Supported Hive distributions for profiling data. |
| IBM DB2 and IBM DB2 Z/OS |
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 |
|
| MySQL |
|
| Netezza |
|
| Oracle with SID |
|
| Oracle with service name |
|
| Oracle Custom with SSL | Oracle 18 and later |
| PostgreSQL |
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) |
|
| Teradata |
|
| Vertica |
|