Compatible Databases - 6.1

Talend MDM Platform Installation Guide

EnrichVersion
6.1
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend DQ Portal
Talend ESB
Talend Identity Management
Talend Installer
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Project Audit
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

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

Table 9. Talend Administration Center

Support type

Databases

Version

Recommended

MySQL

5.6

Oracle

12c Release 1

Supported

MySQL

5.5

MS SQL Server

2008/2012

Oracle

11g

PostgreSQL1

9.4

H22

1.4

MariaDB

10.1


1. PostgreSQL JDBC driver 9.4 is used.

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

Table 10. MDM Server and Talend Data Stewardship Console

Support type

Databases

Version

Recommended

MySQL

5.6

Oracle

12c Release 1

Supported

IBM DB2

10.1

MS SQL Server

2008/2012

MySQL

5.5

Oracle

11g

PostgreSQL1

9.4

Supported

H2

1.4


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

Talend MDM system objects and master data records are stored in two databases. The following table shows which combinations are supported.

System Objects

Master Data Records

Supported

Relational database

Relational database

yes

Table 11. Talend Activity Monitoring Console

Support type

Databases

Version

Recommended

MySQL

5.6

Oracle

12c Release 1

Supported

MySQL

5.5

MS SQL Server

2012

PostgreSQL1

9.4

IBM DB2

10.1

Oracle

11g

Deprecated

Sybase

N/A


1. PostgreSQL JDBC driver 9.4 is used.

Table 12. Service Activity Monitoring (SAM)

Support type

Databases

Version

Recommended

MySQL

5.6

Oracle

12c Release 1

Supported

MySQL

5.5

MS SQL Server

2008/2012

Oracle

11g

PostgreSQL1

9.4

IBM DB2

10.1

Derby DB

> 10.8


1. PostgreSQL JDBC driver 9.4 is used.

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

Support type

Databases

Version

Recommended

MySQL

5.6

Oracle

12c Release 1

Supported

MySQL

5.5

MS SQL Server

2008/2012

Oracle

11g

PostgreSQL1

9.4

Derby DB

> 10.8


1. PostgreSQL JDBC driver 9.4 is used.

Table 14. Talend Data Quality Portal

Support type

Databases used to store the analyses

Version

Recommended

MySQL

5.6

Oracle

12c Release 1

Supported

MySQL

5.5

Oracle

11g

PostgreSQL

9.x

MS SQL Server

2012

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.