Compatible Databases - 6.2

Talend MDM Platform Installation Guide for Mac

EnrichVersion
6.2
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
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.

The information contained in the following table is applicable for the 6.2.2 version of your Talend product at the time of its release. For updated information on the latest supported software or databases, see this page.

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

Table 14. Talend Administration Center

Support type

Databases

Version

Recommended

MySQL

5.7

Oracle

12c Release 1

Supported

MySQL

5.6

MS SQL Server

2012/2014 2

Oracle

11g

PostgreSQL1

9.4

H23

1.4

MariaDB

10.1


1. PostgreSQL JDBC driver 9.4 is used.

2. No new feature introduced by MS SQL Server 2014 is supported.

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

Table 15. MDM Server and Talend Data Stewardship Console

Support type

Databases

Version

Recommended

MySQL

5.7

Oracle

12c Release 1

Supported

IBM DB2

10.1

MS SQL Server

2012/2014 2

MySQL

5.6

Oracle

11g

PostgreSQL1

9.4

Supported

H2

1.4


1. PostgreSQL JDBC driver 9.4 or higher must be used.

2. No new feature introduced by MS SQL Server 2014 is supported.

Table 16. Talend Activity Monitoring Console

Support type

Databases

Version

Recommended

MySQL

5.7

Oracle

12c Release 1

Supported

MySQL

5.6

MS SQL Server

2012/2014 2

PostgreSQL1

9.4

IBM DB2

10.1

Oracle

11g


1. PostgreSQL JDBC driver 9.4 is used.

2. No new feature introduced by MS SQL Server 2014 is supported.

Table 17. Service Activity Monitoring (SAM)

Support type

Databases

Version

Recommended

MySQL

5.7

Oracle

12c Release 1

Supported

MySQL

5.6

MS SQL Server

2012/2014 2

Oracle

11g

PostgreSQL1

9.4

IBM DB2

10.1

Derby DB

> 10.8


1. PostgreSQL JDBC driver 9.4 is used.

2. No new feature introduced by MS SQL Server 2014 is supported.

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

Support type

Databases

Version

Recommended

MySQL

5.7

Oracle

12c Release 1

Supported

MySQL

5.6

MS SQL Server

2012/2014 2

Oracle

11g

PostgreSQL1

9.4

Derby DB

> 10.8


1. PostgreSQL JDBC driver 9.4 is used.

2. No new feature introduced by MS SQL Server 2014 is supported.

Table 19. Talend Data Quality Portal

Support type

Databases used to store the analyses

Version

Recommended

MySQL

5.7

Oracle

12c Release 1

Supported

MySQL

5.6

Oracle

11g

PostgreSQL

9.x

Support type

Database used to store the portal configuration

Version

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 20. Talend Repository Manager

Support type

Databases

Version

Recommended

MySQL

5.7

Oracle

12c Release 1

Supported

MySQL

5.6

MS SQL Server

2012/2014 2

Oracle

11g

PostgreSQL1

9.4

H2

1.4

MariaDB

10.1


1. PostgreSQL JDBC driver 9.4 is used.

2. No new feature introduced by MS SQL Server 2014 is supported.