Compatible databases - 7.3

Talend Installation Guide for Mac

Version
7.3
Language
English (United States)
EnrichDitaval
Mac
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend LogServer
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
The following tables provide information on the recommended and supported databases you can use with Talend server modules.

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
MySQL4,5 8.0 mysql-connector-java-8.x.jar Recommended
5.7 Supported
Oracle 19c ojdbc10.jar

ojdbc8.jar

ojdbc7-11g.jar

ojdbc7.jar

Recommended
18c Supported
12c release 1 Supported
11g Supported
Azure SQL   mssql-jdbc-7.4.1.jre8.jar Supported
H2 1

2.16

h2-2.1.210.jar

Not supported for production
MariaDB 2 10.1 mariadb-java-client-1.1.7.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
2012 SP2 Recommended
PostgreSQL 13 postgresql-42.2.10.jar Supported
11 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 Embedded for developement, 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 systerm 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 Please update your H2 database to 2.1 version following the procedure: https://help.talend.com/r/en-US/7.3/migration-upgrade-guide/upgrading-administration-database.

Available in:

Data Fabric

MDM Platform

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
5.7 Supported
Oracle 19c ojdbc10.jar

ojdbc8.jar

ojdbc7-11g.jar

ojdbc7.jar

Recommended
18c Supported
12c release 1 5 Supported
11g 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 2017 5 mssql-jdbc-9.2.1.jre8.jar

mssql-jdbc-9.2.1.jre11.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 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_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.

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 19c

ojdbc7-11g.jar

ojdbc7.jar

ojdbc8.jar

ojdbc10.jar

Recommended
18c Supported
12c release 1 3 Supported
11g Supported
Azure SQL   Latest available version of Microsoft driver supporting your version of SQL Server. For more information, check 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, check Microsoft matrix. Supported
2016 Supported
2014 Supported
2012 (SP2) Supported
PostgreSQL 3 11 postgresql-42.2.2.jre7.jar Supported
10 Supported
9.6 Supported
9.5 3 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 19c

ojdbc7-11g.jar

ojdbc7.jar

ojdbc8.jar

ojdbc10.jar

Recommended
18c Supported
12c release 1 3 Supported
11g Supported
H2 4 1.4 h2-1.4.187.jar Not supported for production
MS SQL Server 2, 3 2017 jtds-1.3.1.jar

mssql-jdbc-7.4.1.jre11.jar

mssql-jdbc-7.4.1.jre8.jar

Supported
2016 Supported
2014 Supported
2012 SP2 Supported
PostgreSQL 3 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.

Available in:

Data Fabric

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

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 19c ojdbc10.jar

ojdbc7-11g.jar

ojdbc7.jar

ojdbc8.jar

Recommended
18c Supported
12c release 1 3 Supported
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 3 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.

Available in:

Data Fabric

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

ESB Service Registry/Authorization/Event Logging

Compatible databases for ESB Service Registry/Service Activity Monitoring/Provisioning Service/Authorization/Event Logging
Database Version Supported drivers Support type
MySQL 8.0 1, 3 mysql-connector-java-8.x.jar Recommended
Oracle 19c ojdbc7-11g.jar

ojdbc7jar

ojdbc8.jar

ojdbc10.jar

Recommended
18c Supported
12c release 1 3 Supported
11g Supported
Azure SQL   Latest available version of Microsoft driver supporting your version of SQL Server. For more information, check 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, check Microsoft matrix. Supported
2016 Supported
2014 Supported
2012 SP2 Supported
PostgreSQL 3 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.

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

Compatible databases for data quality data mart
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
12c release 1 3 Supported
11g Supported
Azure SQL 4   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 3 11 postgresql-42.2.2.jre7.jar Supported
10 Supported
9.6 Supported
9.5 Supported
Snowflake - snowflake-jdbc-3.11.0.jar 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.

4 The jTDS-1.3.1.jar patched driver is the only supported driver.

Available in:

Big Data Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

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
5.7 Supported
Oracle 19c ojdbc7-11g.jar

ojdbc7.jar

ojdbc8.jar

ojdbc10.jar

Recommended
18c Supported
12c release 1 5 Supported
11g Supported
Azure SQL   jtds-1.3.1_patched.jar Supported
H2 2 1.4 h2-1.4.187.jar Not supported for production
MariaDB 3 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 5 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.0 Supported (embedded in the product)
Note: Version not recommended for production environment as it does not support active/active clustering.
4.x Recommended (external to the product)
3.6 Recommended (external to the product)

Talend Data Stewardship

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

Available in:

Big Data Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

Talend Dictionary Service

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