In the following documentation:
- Recommended: designates an environment recommended by Talend based on experience and customer usage.
- Supported: designates a supported environment for use with the listed component or service.
- Supported with limitations: designates an environment that is supported by Talend but with certain conditions explained in notes.
Talend Administration Center
Database | Version | Supported driver | Support type |
---|---|---|---|
MySQL4,5 | 8.0 | mysql-connector-java-8.x.jar | Recommended |
5.7 | Supported | ||
Oracle | 19c | ojdbc10.jar ojdbc8.jar |
Recommended |
18c | Supported | ||
Azure SQL | - |
mssql-jdbc-9.4.0.jre11.jar mssql-jdbc-9.4.0.jre8.jar |
Supported |
H2 1 | 2.16 |
h2-2.1.210.jar |
Not supported for production |
MariaDB 2 | 10.5 | mariadb-java-client-2.7.4.jar | Supported |
MS SQL Server 3 | 2019 |
mssql-jdbc-10.2.0.jre11.jar mssql-jdbc-10.2.0.jre8.jar mssql-jdbc-9.4.0.jre11.jar mssql-jdbc-9.4.0.jre8.jar |
Supported |
2017 | Supported | ||
2016 | Supported | ||
2014 | Supported | ||
PostgreSQL | 15 | postgresql-42.5.3.jar | Supported |
14 | Supported | ||
13 | Supported | ||
12 | Supported | ||
11 | Supported | ||
10 | Supported | ||
9.6 | Supported | ||
Aurora | 2.07.2 | mysql-connector-java-8.0.26.jar | Supported |
1 Embedded for development, test, and demo purposes only. H2 is not supported if you migrate from previous versions. To migrate from a previous version, you need to migrate from H2 to MySQL or other supported databases first in the source version, and then trigger the upgrade of Talend Administration Center to the target version.
2 When you create a database schema using
MariaDB 10.1, you must use UTF8 encoding. For example: CREATE DATABASE <YOUR_DATABASE_NAME> DEFAULT
CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
3 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher. MSSQL cluster is supported for Talend Administration Center.
4 MySQL InnoDB cluster is supported by Talend Administration Center.
When using the InnoDB cluster, you may need to change the JDBC URL as the cluster
system env, for example,
JDBCUrl:jdbc:mysql://192.168.1.32:6446/TAC?useSSL=true&connectTimeout=15000&socketTimeout=15000&autoReconnect=true
.
IP address 192.168.1.32 and port 6446 are the IP address of the mysqlrouter host
and the RW port of mysql router.
My MySQL Route Classic protocol: Read/Write Connections: localhost:6446 Read/Only Connections: localhost:6447
5 Talend Administration Center supports the MySQL setup in failover configuration with Red Hat clustering. For more information, see https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/high_availability_add-on_administration/index. Note that you may need to add some parameters to JDBC connection URL, as shown in 4.
6 Update your H2 database to 2.1 version, see Upgrading the administration database.
Available in:
Data Fabric
MDM Platform
Talend MDM Server
Database | Versions | Supported drivers | Support type |
---|---|---|---|
MySQL 1, 5 | 8.0 | mysql-connector-java-8.x.jar | Recommended |
5.7 | Supported | ||
Oracle | 19c | ojdbc10.jar ojdbc8.jar |
Recommended |
18c | Supported | ||
Azure SQL | - | jtds-1.3.1_patched.jar | Supported |
H2 2 | 2.16 |
h2-2.1.210.jar |
Not supported for production |
IBM DB2 | 10.5 | Supported | |
MS SQL Server | 2019 | mssql-jdbc-9.4.0.jre11.jar mssql-jdbc-10.2.1.jre11.jar 7 |
Supported |
2017 5 | mssql-jdbc-9.2.1.jre8.jar mssql-jdbc-9.2.1.jre11.jar |
Supported | |
2016 | Supported | ||
2014 | Supported | ||
PostgreSQL | 13 | postgresql-42.2.2.jre7.jar | Supported |
12 | Supported | ||
11 | Supported | ||
10 | Supported | ||
9.6 | Supported |
1 Google Cloud SQL is supported.
2 Embedded for development, test, and demo purposes only.
3 When you create a database schema using MariaDB 10.1, you must use UTF8
encoding. For example: CREATE DATABASE <YOUR_DATABASE_NAME> DEFAULT
CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
4 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.
5 Amazon RDS is supported.
6 Update your H2 database to 2.1 version following the procedure: Upgrading the administration database.
7 When using mssql-jdbc-10.2.1.jre11.jar, you need to append the parameter
TrustServerCertificate=True
in the connection URL for MS SQL
Server in the MDM datasource configuration file
datasources.xml.
Talend Identity and Access Management
Use the same database type and version for oidc
and idp
databases.
For more information about the databases supported by Apache Syncope, see Apache Syncope documentation.
Database | Version | Supported drivers | Support type |
---|---|---|---|
MySQL | 8.0 1, 3 | mysql-connector-java-8.x.jar | Recommended |
5.7 | Supported | ||
Oracle | 19c |
ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar ojdbc10.jar |
Recommended |
18c | Supported | ||
Azure SQL | - | Latest available version of Microsoft driver supporting your version of SQL Server. For more information, see Microsoft matrix. | Supported |
H2 4 | 2.16 |
h2-2.1.210.jar |
Not supported for production |
MS SQL Server 2, 3 | 2017 | Latest available version of Microsoft driver supporting your version of SQL Server. For more information, see Microsoft matrix. | Supported |
2016 | Supported | ||
2014 | Supported | ||
PostgreSQL 3 | 13 | postgresql-42.2.2.jre7.jar | Supported |
12 | Supported | ||
11 | Supported | ||
10 | Supported | ||
9.6 | Supported |
1 Google Cloud SQL is supported.
2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.
3 Amazon RDS is supported.
4 Embedded for development, test, and demo purposes only.
6 Update your H2 database to 2.1 version following the procedure: https://help.talend.com/r/en-US/8.0/migration-upgrade-guide/upgrading-administration-database.
Available in:
Data Fabric
Data Services Platform
ESB
MDM Platform
Real-Time Big Data Platform
Service Activity Monitoring (SAM)
Database | Version | Supported drivers | Support type |
---|---|---|---|
MySQL | 8.0 1, 3 | mysql-connector-java-8.x.jar | Recommended |
5.7 | Supported | ||
Oracle | 19c | ojdbc10.jar ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar |
Recommended |
18c | Supported | ||
Azure SQL | jtds-1.3.1_patched.jar | Supported | |
Derby DB | 10.8 (or later) | Supported | |
IBM DB2 | 10.5 | Supported | |
MS SQL Server 2, 3 | 2017 | jtds-1.3.1.jar | Supported |
2016 | Supported | ||
2014 | Supported | ||
PostgreSQL 3 | 13 | postgresql-42.2.2.jre7.jar | Supported |
12 | Supported | ||
11 | Supported | ||
10 | Supported | ||
9.6 | Supported |
1 Google Cloud SQL is supported.
2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.
3 Amazon RDS is supported.
Available in:
Data Fabric
Data Services Platform
ESB
MDM Platform
Real-Time Big Data Platform
ESB Service Registry/Authorization/Event Logging
Database | Version | Supported drivers | Support type |
---|---|---|---|
MySQL | 8.0 1, 3 | mysql-connector-java-8.x.jar | Recommended |
5.7 | Supported | ||
Oracle | 19c | ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar ojdbc10.jar |
Recommended |
18c | Supported | ||
Azure SQL | - | Latest available version of Microsoft driver supporting your version of SQL Server. For more information, see Microsoft matrix. | Supported |
HSQL 4 | 2.3.2 | Supported | |
Derby DB | 10.8 (or later) | Supported | |
IBM DB2 5 | 10.5 | Supported | |
MS SQL Server 2, 3 | 2017 | Latest available version of Microsoft driver supporting your version of SQL Server. For more information, see Microsoft matrix. | Supported |
2016 | Supported | ||
2014 | Supported | ||
PostgreSQL 3 | 13 | postgresql-42.2.2.jre7.jar | Supported |
12 | Supported | ||
11 | Supported | ||
10 | Supported | ||
9.6 | Supported |
1 Google Cloud SQL is supported.
2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.
3 Amazon RDS is supported.
4 Embedded in the product.
5 Service Activity Monitoring only.
Available in:
Big Data Platform
Data Fabric
Data Management Platform
Data Services Platform
MDM Platform
Real-Time Big Data Platform
Data quality data mart
Database | Version | Supported drivers | Support type |
---|---|---|---|
MySQL | 8.0 1, 3 | mysql-connector-java-8.x.jar | Recommended |
5.7 | mysql-connector-java-5.x.jar | Recommended | |
Oracle | 19c | ojdbc8.jar (recommended for all supported
versions) ojdbc7.jar ojdbc7-11g.jar ojdbc10.jar |
Supported |
18c | |||
12c3 (deprecated from 8.0.1 R2023-01 onwards) | |||
11g (deprecated from 8.0.1 R2023-01 onwards) | |||
Azure SQL | - | jtds-1.3.1_patched.jar mssql-jdbc-9.4.0.jre8.jar mssql-jdbc-9.4.0.jre11.jar |
Supported |
MS SQL Server 2, 3 | 2017 | Latest available version of Microsoft driver supporting your version of SQL Server. For more information, see Microsoft matrix. | Supported |
2016 | Supported | ||
2014 | Supported | ||
PostgreSQL 3 | 13 | postgresql-42.2.14.jar | Supported |
12 | |||
11 | postgresql-42.2.2.jre7.jar | Supported | |
10 | |||
9.6 | |||
Snowflake | - | snowflake-jdbc-3.13.8.jar | Supported |
max_allowed_packet = 64M
The 64M value is only given as example. It represents the maximum size of a query packet the server can handle as well as the maximum query size the server can process. You can replace it with any value superior to 16M.
1 Google Cloud SQL is supported.
2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.
3 Amazon RDS is supported.
Talend Data Preparation
Database | Versions | Support type |
---|---|---|
MongoDB | 4.0 | Supported (embedded in the product) Important: Version not
recommended for production environment as it does not support
active/active clustering.
|
4.4 | Supported | |
3.6 | Supported |
Talend Data Stewardship
Database | Versions | Support type |
---|---|---|
MongoDB | 4.0 | Supported (embedded in the product) Important: Version not
recommended for production environment as it does not support
active/active clustering.
|
4.4 | Supported | |
3.6 | Supported |
Available in:
Big Data Platform
Data Fabric
Data Management Platform
Data Services Platform
MDM Platform
Real-Time Big Data Platform
Talend Dictionary Service
Database | Versions | Support type |
---|---|---|
MongoDB | 4.0 | Supported (embedded in the product) Important: Version not
recommended for production environment as it does not support
active/active clustering.
|
4.4 | Supported (external to the product) | |
3.6 | Supported (external to the product) |