Skip to main content Skip to complementary content

Compatible databases

The following tables provide information on the recommended and supported databases you can use with Talend server modules. Unless stated otherwise, this list is for standalone (or single node) database configurations.

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

Compatible databases for Talend Administration Center
Database Version Supported driver Support type
MySQL4,5 8.0 mysql-connector-java-8.x.jar Recommended
MySQL4,5 5.7 mysql-connector-java-8.x.jar Supported
Oracle 19c
  • ojdbc10.jar
  • ojdbc8.jar
 Recommended
Oracle 18c
  • ojdbc10.jar
  • ojdbc8.jar
 Supported
Azure SQL Not applicable
  • mssql-jdbc-9.4.0.jre11.jar
  • mssql-jdbc-9.4.0.jre8.jar
 Supported
Azure MySQL Flexible Server 8.0 mysql-connector-j-8.x.x.jar Recommended
H21 2.16 h2-2.1.210.jar Not supported for production
MariaDB2 10.5 mariadb-java-client-2.7.4.jar Supported

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;

MS SQL Server3 2022
  • mssql-jdbc-12.2.0.jre8.jar
  • mssql-jdbc-12.2.0.jre11.jar
 Supported
MS SQL Server3
  • 2019
  • 2017
  • 2016
  • 2014
  • 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
PostgreSQL
  • 16
  • 15
  • 14
  • 13
  • 12
  • 11
  • 10
  • 9.6
 postgresql-42.5.3.jar Supported
Aurora 3 mysql-connector-java-8.0.33.jar Supported
Aurora 2.07.2 mysql-connector-java-8.0.26.jar Supported
Information noteNote: All the databases stated above are supported regardless of the hosting mode, Google Cloud Platform and Amazon RDS included.

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 with these additional parameters: jobserver.log.retriever.deprecated=true and org.quartz.jobStore.clusterCheckinInterval = 240000.

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 High Availability Add-On Administration in the Red Hat documentation. Note that you may need to add some parameters to JDBC connection URL, as described in 4.

6 Update your H2 database to 2.1 version, see Upgrading the administration database.

Talend MDM Server

Compatible databases for Talend MDM Server
Database Versions Supported drivers Support type
MySQL 1, 5 8.0 mysql-connector-java-8.x.jar Recommended
MySQL 1, 5 5.7 mysql-connector-java-8.x.jar Supported
Oracle 19c
  • ojdbc10.jar
  • ojdbc8.jar
 Recommended
Oracle 18c
  • ojdbc10.jar
  • ojdbc8.jar
 Supported
Azure SQL Not applicable jtds-1.3.1_patched.jar Supported
H2 2 2.1 6 h2-2.1.210.jar Not supported for production
IBM DB2 10.5 db2jcc.jar Supported
MS SQL Server 2019
  • mssql-jdbc-9.4.0.jre11.jar
  • mssql-jdbc-10.2.1.jre11.jar 7
 Supported
MS SQL Server
  • 2017 5
  • 2016
  • 2014
  • mssql-jdbc-9.2.1.jre8.jar
  • mssql-jdbc-9.2.1.jre11.jar
 Supported
PostgreSQL
  • 13
  • 12
  • 11
  • 10
  • 9.6
 postgresql-42.2.2.jre7.jar 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

Information noteTip: Use the same database type and version for oidc databases.
Compatible databases for Talend Identity and Access Management
Database Version Supported drivers Support type
MySQL 8.0 1, 3 mysql-connector-java-8.x.jar Recommended
MySQL 5.7 mysql-connector-java-8.x.jar Supported
Oracle 19c
  • ojdbc7-11g.jar
  • ojdbc7.jar
  • ojdbc8.jar
  • ojdbc10.jar
 Recommended
Oracle 18c
  • ojdbc7-11g.jar
  • ojdbc7.jar
  • ojdbc8.jar
  • ojdbc10.jar
 Supported
Azure SQL Not applicable Latest available version of Microsoft driver supporting your version of SQL Server. For more information, see Microsoft matrix. Supported
H2 4 2.1 5 h2-2.1.210.jar Not supported for production
MS SQL Server 2, 3
  • 2017
  • 2016
  • 2014
 Latest available version of Microsoft driver supporting your version of SQL Server. For more information, see Microsoft matrix. Supported
PostgreSQL 3
  • 13
  • 12
  • 11
  • 10
  • 9.6
 postgresql-42.2.2.jre7.jar 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.

5 To update your H2 database to version 2.1, see Upgrading the administration database.

Service Activity Monitoring (SAM)

Compatible databases for Service Activity Monitoring
Database Version Supported drivers Support type
MySQL 8.0 1, 3 mysql-connector-java-8.x.jar Recommended
MySQL 5.7 mysql-connector-java-8.x.jar Supported
Oracle 19c
  • ojdbc10.jar
  • ojdbc7-11g.jar
  • ojdbc7.jar
  • ojdbc8.jar
 Recommended
Oracle 18c
  • ojdbc10.jar
  • ojdbc7-11g.jar
  • ojdbc7.jar
  • ojdbc8.jar
 Supported
Azure SQL Not applicable jtds-1.3.1_patched.jar Supported
Derby DB 10.8 (or later) Not applicable Supported
IBM DB2 10.5 db2jcc.jar Supported
MS SQL Server 2, 3
  • 2017
  • 2016
  • 2014
 jtds-1.3.1.jar Supported
PostgreSQL 3
  • 13
  • 12
  • 11
  • 10
  • 9.6
 postgresql-42.2.2.jre7.jar 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.

ESB Service Registry/Authorization

Compatible databases for ESB Service Registry/Service Activity Monitoring/Provisioning Service/Authorization
Database Version Supported drivers Support type
MySQL 8.0 1, 3 mysql-connector-java-8.x.jar Recommended
MySQL 5.7 mysql-connector-java-8.x.jar Supported
Oracle 19c
  • ojdbc7-11g.jar
  • ojdbc7.jar
  • ojdbc8.jar
  • ojdbc10.jar
 Recommended
Oracle 18c
  • ojdbc7-11g.jar
  • ojdbc7.jar
  • ojdbc8.jar
  • ojdbc10.jar
 Supported
Azure SQL Not applicable Latest available version of Microsoft driver supporting your version of SQL Server. For more information, see Microsoft matrix. Supported
HSQL 4 2.3.2 Not applicable Supported
Derby DB 10.8 (or later) Not applicable Supported
IBM DB2 5 10.5 db2jcc.jar Supported
MS SQL Server 2, 3
  • 2017
  • 2016
  • 2014
 Latest available version of Microsoft driver supporting your version of SQL Server. For more information, see Microsoft matrix. Supported
PostgreSQL 3
  • 13
  • 12
  • 11
  • 10
  • 9.6
 postgresql-42.2.2.jre7.jar 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.

Data quality data mart

Compatible databases for data quality data mart
Database Version Supported drivers Support type
MySQL 8.0 1, 2, 3 mysql-connector-java-8.x.jar Recommended
MySQL 5.7 mysql-connector-java-5.x.jar Recommended
Oracle
  • 19c
  • 18c
  • 12c 3 (deprecated from 8.0.1 R2023-01 onwards)
  • 11g (deprecated from 8.0.1 R2023-01 onwards)
  • ojdbc8.jar (recommended for all supported versions)
  • ojdbc7.jar
  • ojdbc7-11g.jar
  • ojdbc10.jar
 Supported
Azure SQL Not applicable jtds-1.3.1_patched.jar

mssql-jdbc-9.4.0.jre8.jar

mssql-jdbc-9.4.0.jre11.jar

 Supported
MS SQL Server 3, 4
  • 2019
  • 2017
  • 2016
  • 2014
 Latest available version of Microsoft driver supporting your version of SQL Server. For more information, see Microsoft matrix. Supported
PostgreSQL 3
  • 13
  • 12
 postgresql-42.2.14.jar Supported
PostgreSQL 3
  • 11
  • 10
  • 9.6
 postgresql-42.2.2.jre7.jar Supported
Snowflake Not applicable snowflake-jdbc-3.13.8.jar Supported

1 Google Cloud SQL is supported.

2 From Talend Studio 8.0 R2023-07, MySQL InnoDB cluster is supported.

3 Amazon RDS is supported.

4 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.

Information noteImportant: If you are using MySQL, you must add the following line to the my.ini file of your MySQL server installation directory:
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.

Talend Data Preparation

Compatible MongoDB databases for Talend Data Preparation
MongoDB version Support type
7.0 Supported
5.0 Supported

Talend Data Stewardship

Compatible MongoDB databases for Talend Data Stewardship
MongoDB version Support type
7.0 Supported
5.0 Supported

Talend Dictionary Service

Compatible MongoDB databases for Talend Dictionary Service
MongoDB version Support type
7.0 Supported
5.0 Supported

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!

Leave your feedback here