Compatible databases

In the following documentation:

Recommended: designates an environment recommended by Talend based on our experiences 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
MySQL¹	8.0	mysql-connector-java-8.x.jar	Recommended
MySQL¹	5.7	mysql-connector-java-8.x.jar	Supported
Oracle	18c	ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar	Supported
	12c release 1		Recommended
	11g		Supported
Azure SQL		jtds-1.3.1_patched.jar	Supported
H2 ²	1.4	h2-1.4.187.jar	Not supported for production
MariaDB ³	10.1	mariadb-java-client-1.1.7.jar	Supported
MS SQL Server ⁴	2017	jtds-1.3.1.jar	Supported
	2016		Supported
	2014		Supported
	2012 SP2		Supported
PostgreSQL	11	postgresql-42.2.2.jre7.jar	Supported
	10		Supported
	9.6		Supported
	9.5		Supported

Note: All the databases stated above are supported regardless of the hosting mode, Google Cloud Platform and Amazon RDS included.

^{1 MySQL cluster is not supported for
Talend Administration Center.}

^{2 Embedded for developement, 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.}

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	18c	ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar	Supported
	12c Release 1 ⁵		Recommended
	11g		Supported
Amazon Aurora Database			Supported
AzureSQL		jtds-1.3.1_patched.jar	Supported
H2 ²	1.4	h2-1.4.187.jar	Not supported for production
IBM DB2	10.5		Supported
MS SQL Server	2017 ⁵	mssql-jdbc-9.2.1.jre8.jar mssql-jdbc-9.2.1.jre11.jar	Supported
	2016 (SP2)		Supported
	2014		Supported
	2012 (SP2)		Supported
PostgreSQL	11	postgresql-42.2.2.jre7.jar	Supported
	10		Supported
	9.6		Supported
	9.5 ⁵		Supported

^{1 Google Cloud SQL is supported.}

^{2 Embedded for developement, 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_DATABAE_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.}

Talend Identity and Access Management

Note:

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.

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
Oracle	18c	ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar	Supported
	12c Release 1 ³		Recommended
	11g		Supported
Azure SQL		Latest available version of Microsoft driver supporting your version of SQL Server. For more information, check Microsoft matrix.	Supported
H2 ⁴	1.4	h2-1.4.187.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, check Microsoft matrix.	Supported
	2016		Supported
	2014		Supported
	2012 (SP2)		Supported
PostgreSQL ³	11	postgresql-42.2.2.jre7.jar	Supported
	10		Supported
	9.6		Supported
	9.5 ³		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 developement, test, and demo purposes only.}

Talend Activity Monitoring Console

Compatible databases for Talend Activity Monitoring Console
Database	Version	Supported drivers	Support type
MySQL	8.0 ^{1, 3}	mysql-connector-java-8.x.jar	Recommended
Oracle	18c	ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar	Supported
	12c release 1 ³		Recommended
	11g		Supported
Azure SQL		jtds-1.3.1_patched.jar	Supported
H2 ⁴	1.4	h2-1.4.187.jar	Not supported for production
IBM DB2	10.5		Supported
MS SQL Server ^{2, 3}	2017	jtds-1.3.1.jar	Supported
	2016		Supported
	2014		Supported
	2012 SP2		Supported
PostgreSQL ³	11	postgresql-42.2.2.jre7.jar	Supported
	10		Supported
	9.6		Supported
	9.5		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 developement, test, and demo purposes only.}

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
Oracle	18c	ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar	Supported
	12c release 1 ³		Recommended
	11g		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
	2012 SP2		Supported
PostgreSQL ³	11	postgresql-42.2.2.jre7.jar	Supported
	10		Supported
	9.6		Supported
	9.5		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/Event Logging

Compatible databases for ESB Service Registry/Authorization/Event Logging
Database	Version	Supported drivers	Support type
MySQL	8.0 ^{1, 3}	mysql-connector-java-8.x.jar	Recommended
Oracle	18c	ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar	Supported
	12c release 1 ³		Recommended
	11g		Supported
Azure SQL		jtds-1.3.1_patched.jar	Supported
HSQL ⁴	2.3.2		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
	2012 SP2		Supported
PostgreSQL ³	11	postgresql-42.2.2.jre7.jar	Supported
	10		Supported
	9.6		Supported
	9.5		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.}

Deprecated

Talend DQ Portal

Talend DQ Portal is deprecated from Talend 7.1 onwards.

Compatible databases for Talend DQ Portal
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	18c	ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar	Supported
	12c release 1 ³		Recommended
	11g		Supported
Azure SQL		jtds-1.3.1_patched.jar	Supported
MS SQL Server ^{2, 3}	2017	jtds-1.3.1.jar	Supported
	2016		Supported
	2014		Supported
	2012 SP2		Supported
PostgreSQL ³	11	postgresql-42.2.2.jre7.jar	Supported
	10		Supported
	9.6		Supported
	9.5		Supported

Note:

If you are using MySQL, the my.ini file of your MySQL server installation directory must be edited in order to add the following line:

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.}

Database used to store the portal configuration	Version	Support type
HSQL ¹	2.3.2	Supported

^{1 Embedded in the product.}

Talend Repository Manager

Compatible databases for Talend Repository Manager
Database	Version	Supported driver	Support type
MySQL	8.0 ^{1, 5}	mysql-connector-java-8.x.jar	Recommended
MySQL	5.7	mysql-connector-java-8.x.jar	Supported
Oracle	18c	ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar	Supported
	12c release 1 ⁵		Recommended
	11g		Supported
Azure SQL		jtds-1.3.1_patched.jar	Supported
H2 ²	1.4	h2-1.4.187.jar	Not supported for production
MariaDB ³	10.1	mariadb-java-client-1.1.7.jar	Supported
MS SQL Server ^{4, 5}	2017	jtds-1.3.1.jar	Supported
	2016		Supported
	2014		Supported
	2012 SP2		Supported
PostgreSQL ⁵	11	postgresql-42.2.2.jre7.jar	Supported
	10		Supported
	9.6		Supported
	9.5		Supported

^{1 Google Cloud SQL is
supported.}

^{2 Embedded for developement, 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_DATABAE_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.}

Talend Data Preparation

Compatible databases for Talend Data Preparation
Database	Versions	Support type
MongoDB	4.x	Recommended (external to the product)
MongoDB	3.6	Recommended (external to the product)

Talend Data Stewardship

Compatible databases for Talend Data Stewardship
Database	Versions	Support type
MongoDB	4.0	Recommended (external to the product)
	4.0	Supported (embedded in the product) Information noteNote: Version not recommended for production environment as it does not support active/active clustering.
	3.6	Recommended (external to the product)

Talend Dictionary Service

Compatible databases for Talend Dictionary Service
Database	Versions	Support type
MongoDB	4.0	Recommended (external to the product)
MongoDB	4.0	Supported (embedded in the product) Information noteNote: Version not recommended for production environment as it does not support active/active clustering.

Talend Administration Center

Talend MDM Server

Talend Identity and Access Management

Talend Activity Monitoring Console

Service Activity Monitoring (SAM)

ESB Service Registry/Authorization/Event Logging

Talend DQ Portal

Talend Repository Manager

Talend Data Preparation

Talend Data Stewardship

Talend Dictionary Service

Did this page help you?