# 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 Qlik 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 Qlik but with certain conditions explained in notes. ## Talend Administration Center Compatible databases for Talend Administration CenterCompatible databases for Talend Administration CenterTalend Administration Center | Database | Version | Supported driver | Support type | | --- | --- | --- | --- | | MySQL ^3, 4, 6^ | 9.7 LTS | mysql-connector-j-9.7.0.jar | Recommended | | MySQL ^3, 4, 6^ | 8.4 LTS | mysql-connector-j-8.4.0.jar | Recommended | | MySQL ^3, 4^ | 9.3 - deprecated (EOL July 22, 2025) | mysql-connector-j-8.4.0.jar | Supported | | MySQL ^3, 4, 6^ | 8.0 - deprecated (EOL April 30, 2026) | mysql-connector-j-8.4.0.jar | Supported | | MySQL ^3, 4^ | 5.7 - deprecated (EOL October 31, 2023)

Information noteImportant: Support for MySQL version 5 has been removed from Talend 8.0 R2026-04 onwards. | mysql-connector-j-8.4.0.jar | Supported | | Oracle ^6^ | 19c | | Recommended | | Oracle | 18c | | Supported | | Azure SQL | Not applicable | | Supported | | Azure Database for MySQL | 8.4 LTS | mysql-connector-j-8.4.0.jar | Recommended | | H2 ^1^ | 2.1 ^5^ | h2-2.1.210.jar | Not supported for production | | MariaDB ^6^ | | mariadb-java-client-3.5.2.jar | Supported | | MS SQL Server ^2, 6^ | 2025 | | Supported | | MS SQL Server ^2, 6^ | 2022 | | Supported | | MS SQL Server ^2^ | | | Supported | | PostgreSQL ^6^ | | postgresql-42.7.12.jar | Supported | | PostgreSQL ^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^ Qlik supports the Always Encrypted feature of Microsoft SQL Server 2017 or higher. MS SQL Server cluster is supported by Talend Administration Center with these additional parameters: org.quartz.jobStore.clusterCheckinInterval = 240000. ^3^ 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 ^4^ Talend Administration Center supports the MySQL setup in failover configuration with Red Hat clustering. For more information, see [High Availability Add-On Administration](https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/high_availability_add-on_administration/index) in the Red Hat documentation. Note that you may need to add some parameters to JDBC connection URL, as described in ^4^. ^5^ Update your H2 database to 2.1 version, see [Upgrading the administration database](https://help.qlik.com/talend/en-US/migration-upgrade-guide/8.0/upgrading-administration-database). ^6^ Talend Administration Center supports the following database clusters: * MySQL version 8.0.40 on AWS * PostgreSQL version 16.3-R3 on AWS * Oracle version 19.0.0.0 on AWS * MariaDB version 11.4.4 on AWS * SQL Server - Microsoft SQL Azure (RTM) version 12.0.2000.8 on Azure ## 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 Compatible databases for Talend Identity and Access ManagementTalend Identity and Access Management | Database | Version | Supported drivers | Support type | | --- | --- | --- | --- | | MySQL | 8.0 ^1, 3^ | mysql-connector-java-8.x.jar | Recommended | | Oracle | 19c | | Recommended | | Oracle | 18c | | Supported | | Azure SQL | Not applicable | Latest available version
of Microsoft driver supporting your version of SQL Server. For more
information, see [Microsoft matrix](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15#sql-version-compatibility). | Supported | | H2 ^4^ | 2.1 ^5^ | h2-2.1.210.jar | Not supported for production | | MS SQL Server ^2, 3^ | | Latest available version of Microsoft driver supporting your version of
SQL Server. For more information, see [Microsoft matrix](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15#sql-version-compatibility). | Supported | | PostgreSQL ^3^ | | postgresql-42.2.2.jre7.jar | Supported | ^1^ Google Cloud SQL is supported. ^2^ Qlik supports the Always Encrypted feature of Microsoft SQL Server 2017 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](https://help.qlik.com/talend/en-US/migration-upgrade-guide/8.0/upgrading-administration-database). * Available in: * Data Fabric * Data Services Platform * ESB * Qlik Cloud Enterprise Edition * Qlik Talend Cloud Enterprise Edition * Qlik Talend Cloud Premium Edition * Real-Time Big Data Platform ## Service Activity Monitoring (SAM) Compatible databases for Service Activity Monitoring Compatible databases for Service Activity MonitoringService Activity Monitoring | Database | Version | Supported drivers | Support type | | --- | --- | --- | --- | | MySQL | 8.0 ^1, 3^ | mysql-connector-java-8.x.jar | Recommended | | MySQL | 5.7

Information noteImportant: Support for MySQL version 5 has been removed from Talend 8.0 R2026-04 onwards. | mysql-connector-java-8.x.jar | Supported | | Oracle | 19c | | Recommended | | Oracle | 18c | | 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^ | | jtds-1.3.1.jar | Supported | | PostgreSQL ^3^ | | postgresql-42.2.2.jre7.jar | Supported | ^1^ Google Cloud SQL is supported. ^2^ Qlik supports the Always Encrypted feature of Microsoft SQL Server 2017 or higher. ^3^ Amazon RDS is supported. * Available in: * Data Fabric * Data Services Platform * ESB * Qlik Cloud Enterprise Edition * Qlik Talend Cloud Enterprise Edition * Qlik Talend Cloud Premium Edition * Real-Time Big Data Platform ## ESB Service Registry/Authorization Compatible databases for ESB Service Registry/Service Activity Monitoring/Provisioning Service/AuthorizationCompatible databases for ESB Service RegistryService Registry/Service Activity MonitoringService 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

Information noteImportant: Support for MySQL version 5 has been removed from Talend 8.0 R2026-04 onwards. | mysql-connector-java-8.x.jar | Supported | | Oracle | 19c | | Recommended | | Oracle | 18c | | Supported | | Azure SQL | Not applicable | Latest available version of Microsoft driver supporting your version of
SQL Server. For more information, see [Microsoft matrix](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15#sql-version-compatibility). | 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^ | | Latest available version of Microsoft driver supporting your version of
SQL Server. For more information, see [Microsoft matrix](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15#sql-version-compatibility). | Supported | | PostgreSQL ^3^ | | postgresql-42.2.2.jre7.jar | Supported | ^1^ Google Cloud SQL is supported. ^2^ Qlik supports the Always Encrypted feature of Microsoft SQL Server 2017 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 * Qlik Cloud Enterprise Edition * Qlik Talend Cloud Enterprise Edition * Qlik Talend Cloud Premium Edition * Real-Time Big Data Platform ## Data quality data mart Compatible databases for data quality data martCompatible 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

Information noteImportant: Support for MySQL version 5 has been removed from Talend 8.0 R2026-04 onwards. | mysql-connector-java-5.x.jar | Recommended | | Oracle | | | 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^ | | Latest available version
of Microsoft driver supporting your version of SQL Server. For more
information, see [Microsoft matrix](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15#sql-version-compatibility). | Supported | | PostgreSQL ^3^ | 12 and later | postgresql-42.2.14.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^ Qlik supports the Always Encrypted feature of Microsoft SQL Server 2017 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 Compatible MongoDB databases for Talend Data PreparationTalend Data Preparation | MongoDB version | Patch version | Support type | | --- | --- | --- | | 7.0 | R2023-10

R2024-05

R2025-02 | Supported | ## Talend Data Stewardship Compatible MongoDB databases for Talend Data Stewardship Compatible MongoDB databases for Talend Data StewardshipTalend Data Stewardship | MongoDB version | Patch version | Support type | | --- | --- | --- | | 4.0 to 7.0 | R2024-05 | Supported | | 6.0 to 8.0 | R2025-02 | Supported | * Available in: * Big Data Platform * Data Fabric * Data Management Platform * Data Services Platform * Qlik Cloud Enterprise Edition * Qlik Talend Cloud Enterprise Edition * Qlik Talend Cloud Premium Edition * Real-Time Big Data Platform ## Talend Dictionary Service Compatible MongoDB databases for Talend Dictionary Service Compatible MongoDB databases for Talend Dictionary ServiceTalend Dictionary Service | MongoDB version | Support type | | --- | --- | | 7.0 | Supported |