Compatible Databases - 6.4

Talend Data Services Platform Installation Guide for Windows

EnrichVersion
6.4
EnrichProdName
Talend Data Services 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 Management
Talend Installer
Talend JobServer
Talend Log Server
Talend Project Audit
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

Note

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.

Please refer to the following grids for a summary of supported databases.

Table 19. Talend Administration Center

Support type

Databases

Recommended

MySQL 5.71,2

Oracle 12c Release 11

Supported

Azure SQL5

H2 1.46

MariaDB 10.1

MS SQL Server 20161,4

MS SQL Server 20144

MS SQL Server 2012 (SP2)4

MySQL 5.6

,2

Oracle 11g

PostgreSQL 9.61,2

PostgreSQL 9.4 and 9.51,2,3


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

2. The corresponding Google Cloud SQL version is supported.

3. PostgreSQL JDBC driver 9.4 is used.

4. Only JTDS driver 1.3.1 is supported.

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

6. Embedded, for development, test and demo purposes. Not suitable for production environments.

Table 20. Talend Identity and Access Management

Support type

Databases

Recommended

MySQL 5.71

Oracle 12c Release 11

Supported

Azure SQL4

H2 1.45

Derby DB > 10.8

MS SQL Server 20161

MS SQL Server 2014

MS SQL Server 2012 (SP2)

MySQL 5.6

Oracle 11g

PostgreSQL 9.61,2

PostgreSQL 9.4 and 9.51,2,3


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

2. The corresponding Google Cloud SQL version is supported.

3. PostgreSQL JDBC driver 9.4 is used.

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

5. Embedded, for development, test and demo purposes. Not suitable for production environments.

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

5. Embedded, for development, test and demo purposes. Not suitable for production environments.

Table 21. Talend Activity Monitoring Console

Support type

Databases

Recommended

MySQL 5.71

Oracle 12c Release 11

Supported

IBM DB2 10.1

MS SQL Server 20161

MS SQL Server 2014

MS SQL Server 2012 (SP2)

MySQL 5.6

Oracle 11g

PostgreSQL 9.61,2

PostgreSQL 9.4 and 9.53


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

2. The corresponding Google Cloud SQL version is supported.

3. PostgreSQL JDBC driver 9.4 is used.

Table 22. Service Activity Monitoring (SAM)

Support type

Databases

Recommended

MySQL 5.71

Oracle 12c Release 11

Supported

Azure SQL4

Derby DB > 10.8

IBM DB2 10.1

MS SQL Server 20161

MS SQL Server 2014

MS SQL Server 2012 (SP2)

MySQL 5.6

Oracle 11g

PostgreSQL 9.61,2

PostgreSQL 9.4 and 9.53


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

2. The corresponding Google Cloud SQL version is supported.

3. PostgreSQL JDBC driver 9.4 is used.

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

Table 23. ESB Service Registry/Authorization/Talend Identity Management/Event Logging

Support type

Databases

Recommended

MySQL 5.71

Oracle 12c Release 11

Supported

Azure SQL4

Derby DB > 10.8

MS SQL Server 20161

MS SQL Server 2014

MS SQL Server 2012 (SP2)

MySQL 5.6

Oracle 11g

PostgreSQL 9.61,2

PostgreSQL 9.4 and 9.53


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

2. The corresponding Google Cloud SQL version is supported.

3. PostgreSQL JDBC driver 9.4 is used.

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

Table 24. Talend Data Quality Portal

Support type

Databases used to store the analyses

Recommended

MySQL 5.71

Oracle 12c Release 11

Supported

MS SQL Server 20161

MS SQL Server 2014

MS SQL Server 2012 (SP2)

MySQL 5.6

Oracle 11g

PostgreSQL 9.61,2

PostgreSQL 9.4 and 9.53


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

2. The corresponding Google Cloud SQL version is supported.

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

Warning

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.

Table 25. Talend Repository Manager

Support type

Databases

Recommended

MySQL 5.71

Oracle 12c Release 11

Supported

Azure SQL

H2 1.4

MariaDB 10.1

MS SQL Server 20161

MS SQL Server 2014

MS SQL Server 2012 (SP2)

MySQL 5.6

Oracle 11g

PostgreSQL 9.61,2

PostgreSQL 9.4 and 9.53


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

2. The corresponding Google Cloud SQL version is supported.

3. PostgreSQL JDBC driver 9.4 is used.

Table 26. Talend Data Preparation

Support type

Database

Recommended (external to the product)

MongoDB 3.4

Supported (embedded in the product)

MongoDB 3.4


Table 27. Talend Data Stewardship

Support type

Database

Recommended (external to the product)

MongoDB 3.4

Supported (embedded in the product)

MongoDB 3.4


Table 28. Talend Dictionary Service

Support type

Database

Recommended (external to the product)

MongoDB 3.4

Supported (embedded in the product)

MongoDB 3.4