Compatible databases - 7.1

Talend Real-Time Big Data Platform Installation Guide for Mac

EnrichVersion
7.1
EnrichProdName
Talend Real-Time Big Data Platform
task
Installation and Upgrade
EnrichPlatform
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 Log Server
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
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

Note: If you want to use a MS SQL database for Talend Administration Center, Talend only supports the jTDS driver version 1.3.1.
Support type Database Note
Recommended MySQL 5.7 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

Warning: Make sure to use mysql-connector-java-8.x.jar as the MySQL driver.
Oracle 12c Release 1 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
Supported Azure SQL The only supported driver is the patched jTDS-1.3.1.jar driver. For more information, see Installing database drivers in your Web application server.
H2 1.4 Embedded, for development, test and demo purposes. Not suitable for production environments.
MariaDB 10.1  
MS SQL Server 2017 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2016 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2014  
MS SQL Server 2012 (SP2)  
MySQL 8.0  
Oracle 11g  
PostgreSQL 10 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
PostgreSQL 9.6 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

PostgreSQL 9.5 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Talend Identity and Access Management

Use the same database type and version for oidc and idp databases. For more information, see Changing Talend Identity and Access Management database.

For more information about the databases supported by Apache Syncope, see Apache Syncope documentation.

Support type Database Note
Recommended MySQL 5.7 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

Oracle 12c Release 1 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
Supported Derby DB > 10.8  
MS SQL Server 2017 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2016 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2014  
MS SQL Server 2012 (SP2)  
Oracle 11g  
PostgreSQL 10 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
PostgreSQL 9.6 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

PostgreSQL 9.5 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Talend Activity Monitoring Console

Support type Database Note
Recommended MySQL 5.7 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

Warning: Make sure to use mysql-connector-java-8.x.jar as the MySQL driver.
Oracle 12c Release 1 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
Supported IBM DB2 10.5  
MS SQL Server 2017 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2016 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2014  
MS SQL Server 2012 (SP2)  
MySQL 8.0  
Oracle 11g  
PostgreSQL 10 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
PostgreSQL 9.6 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

PostgreSQL 9.5 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Service Activity Monitoring (SAM)

Support type Database Note
Recommended MySQL 5.7 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

Oracle 12c Release 1 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
Supported Derby DB > 10.8  
IBM DB2 10.5  
MS SQL Server 2017 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2016 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2014  
MS SQL Server 2012 (SP2)  
MySQL 8.0  
Oracle 11g  
PostgreSQL 10 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
PostgreSQL 9.6 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

PostgreSQL 9.5 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

ESB Service Registry/Authorization/Event Logging

Support type Database Note
Recommended MySQL 5.7 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

Oracle 12c Release 1 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
Supported Derby DB > 10.8  
MS SQL Server 2017 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2016 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2014  
MS SQL Server 2012 (SP2)  
MySQL 8.0  
Oracle 11g  
PostgreSQL 10 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
PostgreSQL 9.6 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

PostgreSQL 9.5 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Talend DQ Portal

Talend DQ Portal is deprecated from Talend 7.1 onwards. You can connect the data quality data mart to your own reporting tool.

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.

Support type Database used to store the analyses Note
Recommended MySQL 5.7 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

Oracle 12c Release 1 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
Supported MS SQL Server 2017 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2016 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2014  
MS SQL Server 2012 (SP2)  
MySQL 8.0  
Oracle 11g  
PostgreSQL 10 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
PostgreSQL 9.6 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

PostgreSQL 9.5 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
Support type Database used to store the portal configuration
Supported (embedded in the product) HSQL 2.3.2

Talend Repository Manager

Support type Database Note
Recommended MySQL 5.7 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

Oracle 12c Release 1 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
Supported Azure SQL  
H2 1.4  
MariaDB 10.1  
MS SQL Server 2017 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2016 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
MS SQL Server 2014  
MS SQL Server 2012 (SP2)  
MySQL 8.0  
Oracle 11g  
PostgreSQL 10 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.
PostgreSQL 9.6 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Google Cloud SQL is supported.

PostgreSQL 9.5 The corresponding Amazon Relational Database Service (Amazon RDS) is supported.

Talend Data Preparation

Support type Database
Recommended (external to the product) MongoDB 3.4
Supported (embedded in the product) MongoDB 3.4

Talend Data Stewardship

Support type Database
Recommended (external to the product) MongoDB 3.4
Supported (embedded in the product) MongoDB 3.4

Talend Dictionary Service

Support type Database
Recommended (external to the product) MongoDB 3.4
Supported (embedded in the product) MongoDB 3.4