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 15. 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 16. 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 17. 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.
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.
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 18. 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 19. 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 20. Talend Data Preparation
Support type |
Database |
---|---|
Recommended (external to the product) |
MongoDB 3.4 |
Supported (embedded in the product) |
MongoDB 3.4 |
Table 21. Talend Data Stewardship
Support type |
Database |
---|---|
Recommended (external to the product) |
MongoDB 3.4 |
Supported (embedded in the product) |
MongoDB 3.4 |
Table 22. Talend Dictionary Service
Support type |
Database |
---|---|
Recommended (external to the product) |
MongoDB 3.4 |
Supported (embedded in the product) |
MongoDB 3.4 |