Compatible databases

Talend Real-Time Big Data Platform Installation Guide for Windows

EnrichVersion
6.5
EnrichProdName
Talend Real-Time Big Data Platform
task
Installation and Upgrade
EnrichPlatform
Talend Runtime
Talend Administration Center
Talend Installer
Talend CommandLine
Talend Artifact Repository
Talend Activity Monitoring Console
Talend Data Stewardship
Talend JobServer
Talend Studio
Talend Identity and Access Management
Talend DQ Portal
Talend ESB
Talend Log Server
Talend Data Preparation
Talend SAP RFC Server
Talend Repository Manager
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

Support type

Database

Note

Recommended

MySQL 5.7

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

The corresponding Google Cloud SQL is supported.

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 2016

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

Only JTDS driver 1.3.1 is supported.

MS SQL Server 2014

Only JTDS driver 1.3.1 is supported.

MS SQL Server 2012 (SP2)

Only JTDS driver 1.3.1 is supported.

MySQL 5.6

Only InnoDB table type is supported.

The corresponding Google Cloud SQL is supported.

Oracle 11g

 

PostgreSQL 9.6

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

The corresponding Google Cloud SQL is supported.

PostgreSQL 9.5

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

PostgreSQL JDBC driver 9.4 is used

PostgreSQL 9.4

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

PostgreSQL JDBC driver 9.4 is used

Talend Activity Monitoring Console

Support type

Database

Note

Recommended

MySQL 5.7

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

Oracle 12c Release 1

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

Supported

IBM DB2 10.1

 

MySQL 5.6

Only InnoDB table type is supported.

Oracle 11g

 

PostgreSQL 9.6

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

The corresponding Google Cloud SQL is supported.

PostgreSQL 9.5

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

PostgreSQL JDBC driver 9.4 is used

PostgreSQL 9.4

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

PostgreSQL JDBC driver 9.4 is used

Service Activity Monitoring (SAM)

Support type

Database

Note

Recommended

MySQL 5.7

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

Oracle 12c Release 1

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

Supported

Azure SQL

 

Derby DB > 10.8

 

IBM DB2 10.1

 

MS SQL Server 2016

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

MS SQL Server 2014

 

MS SQL Server 2012 (SP2)

 

MySQL 5.6

Only InnoDB table type is supported.

Oracle 11g

 

PostgreSQL 9.6

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

The corresponding Google Cloud SQL is supported.

PostgreSQL 9.5

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

PostgreSQL JDBC driver 9.4 is used

PostgreSQL 9.4

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

PostgreSQL JDBC driver 9.4 is used

ESB Service Registry/Authorization/Talend Identity Management/Event Logging

Support type

Database

Note

Recommended

MySQL 5.7

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

Oracle 12c Release 1

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

Supported

Azure SQL

 

Derby DB > 10.8

 

MS SQL Server 2016

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

MS SQL Server 2014

 

MS SQL Server 2012 (SP2)

 

MySQL 5.6

Only InnoDB table type is supported.

Oracle 11g

 

PostgreSQL 9.6

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

The corresponding Google Cloud SQL is supported.

PostgreSQL 9.5

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

PostgreSQL JDBC driver 9.4 is used

PostgreSQL 9.4

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

PostgreSQL JDBC driver 9.4 is used

Talend DQ Portal

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.

Oracle 12c Release 1

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

Supported

Azure SQL

 

MS SQL Server 2016

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

MS SQL Server 2014

 

MS SQL Server 2012 (SP2)

 

MySQL 5.6

Only InnoDB table type is supported.

Oracle 11g

 

PostgreSQL 9.6

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

The corresponding Google Cloud SQL is supported.

PostgreSQL 9.5

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

PostgreSQL JDBC driver 9.4 is used

PostgreSQL 9.4

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

PostgreSQL JDBC driver 9.4 is used

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.

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 2016

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

MS SQL Server 2014

 

MS SQL Server 2012 (SP2)

 

MySQL 5.6

Only InnoDB table type is supported.

Oracle 11g

 

PostgreSQL 9.6

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

The corresponding Google Cloud SQL is supported.

PostgreSQL 9.5

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

PostgreSQL JDBC driver 9.4 is used

PostgreSQL 9.4

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

PostgreSQL JDBC driver 9.4 is used

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