Compatible databases - 7.2

Talend Big Data Installation Guide for Mac

EnrichVersion
7.2
EnrichProdName
Talend Big Data
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend Log Server
Talend Runtime
Talend Studio
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
MySQL1 8.0 mysql-connector-java-8.x.jar Recommended
5.7 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 2 1.4 h2-1.4.187.jar Supported
MariaDB 3 10.1 mariadb-java-client-1.1.7.jar Supported
MS SQL Server 4 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. Not suitable for a production enviornment.

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. MSSQL cluster is supported for Talend Administration Center.

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 3 Recommended
11g Supported
Azure SQL   jtds-1.3.1_patched.jar Supported
H2 4 1.4 h2-1.4.187.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 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. Not suitable for a production enviornment.

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 3 Recommended
11g Supported
Azure SQL   jtds-1.3.1_patched.jar Supported
H2 4 1.4 h2-1.4.187.jar 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.

4 Embedded for developement, test, and demo purposes. Not suitable for a production enviornment.

Talend Data Preparation

Compatible databases for Talend Data Preparation
Database Versions Support type
MongoDB 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 Recommended (external to the product)
4.0 Supported (embedded in the product)
Note: Version not recommended for production environment as it does not support active/active clustering.
3.6 Recommended (external to the product)