Compatible Databases - 6.2

Talend Big Data Platform Installation Guide for Linux

EnrichVersion
6.2
EnrichProdName
Talend Big Data Platform
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend DQ Portal
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.

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 12. 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 13. 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 14. 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 15. 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

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