The following tables provide information on the recommended and supported
databases you can use with Talend server
modules.
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.
Talend Administration Center
Note: If you want to use a MS SQL database for Talend Administration Center, Talend only supports the jTDS
driver version 1.3.1.
| Support type | Database | Note |
|---|---|---|
| Recommended | MySQL 5.7 |
Warning: Make sure to use
mysql-connector-java-8.x.jar as the
MySQL driver.
|
| Oracle 18c | ||
| Supported | Azure SQL | 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. |
| H2 1.4 | Embedded, for development, test and demo purposes. Not suitable for production environments. | |
| MariaDB 10.1 | ||
| MS SQL Server 2017 | ||
| MS SQL Server 2016 | ||
| MS SQL Server 2014 | ||
| MS SQL Server 2012 (SP2) | ||
| MySQL 8.0 | ||
| Oracle 12c Release 1 | ||
| Oracle 11g | ||
| PostgreSQL 10 | ||
| PostgreSQL 9.6 | ||
| PostgreSQL 9.5 |
Note: All the databases stated above are supported regardless of the hosting mode,
Google Cloud Platform and Amazon RDS included.
Talend Identity and Access Management
Use the same database type and version for oidc and
idp databases. For more information, see Changing Talend Identity and Access Management database.
For more information about the databases supported by Apache Syncope, see Apache Syncope documentation.
| Support type | Database | Note |
|---|---|---|
| Recommended | MySQL 5.7 | The corresponding Amazon Relational Database Service (Amazon
RDS) is supported. Google Cloud SQL is supported. |
| Oracle 12c Release 1 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| Supported | Derby DB > 10.8 | |
| MS SQL Server 2017 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| MS SQL Server 2016 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| MS SQL Server 2014 | ||
| MS SQL Server 2012 (SP2) | ||
| Oracle 11g | ||
| PostgreSQL 10 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| PostgreSQL 9.6 | The corresponding Amazon Relational Database Service (Amazon
RDS) is supported. Google Cloud SQL is supported. |
|
| PostgreSQL 9.5 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. |
Talend Activity Monitoring Console
| Support type | Database | Note |
|---|---|---|
| Recommended | MySQL 5.7 | The corresponding Amazon Relational Database Service (Amazon
RDS) is supported. Google Cloud SQL is supported. Warning: Make sure to use
mysql-connector-java-8.x.jar as the
MySQL driver.
|
| Oracle 12c Release 1 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| Supported | IBM DB2 10.5 | |
| MySQL 8.0 | ||
| Oracle 11g | ||
| PostgreSQL 10 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| PostgreSQL 9.6 | The corresponding Amazon Relational Database Service (Amazon
RDS) is supported. Google Cloud SQL is supported. |
|
| PostgreSQL 9.5 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. |
Talend DQ Portal
Talend DQ Portal is deprecated from Talend 7.1 onwards. You can connect the data quality data mart to your own reporting tool.
Note:
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 = 64MThe 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.
| Support type | Database used to store the analyses | Note |
|---|---|---|
| Recommended | MySQL 5.7 | The corresponding Amazon Relational Database Service (Amazon
RDS) is supported. Google Cloud SQL is supported. |
| Oracle 12c Release 1 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| Supported | MS SQL Server 2017 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. |
| MS SQL Server 2016 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| MS SQL Server 2014 | ||
| MS SQL Server 2012 (SP2) | ||
| MySQL 8.0 | ||
| Oracle 11g | ||
| PostgreSQL 10 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| PostgreSQL 9.6 | The corresponding Amazon Relational Database Service (Amazon
RDS) is supported. Google Cloud SQL is supported. |
|
| PostgreSQL 9.5 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. |
| Support type | Database used to store the portal configuration |
|---|---|
| Supported (embedded in the product) | HSQL 2.3.2 |
Talend Repository Manager
| Support type | Database | Note |
|---|---|---|
| Recommended | MySQL 5.7 | The corresponding Amazon Relational Database Service (Amazon
RDS) is supported. Google Cloud SQL is supported. |
| Oracle 12c Release 1 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| Supported | Azure SQL | |
| H2 1.4 | ||
| MariaDB 10.1 | ||
| MS SQL Server 2017 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| MS SQL Server 2016 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| MS SQL Server 2014 | ||
| MS SQL Server 2012 (SP2) | ||
| MySQL 8.0 | ||
| Oracle 11g | ||
| PostgreSQL 10 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. | |
| PostgreSQL 9.6 | The corresponding Amazon Relational Database Service (Amazon
RDS) is supported. Google Cloud SQL is supported. |
|
| PostgreSQL 9.5 | The corresponding Amazon Relational Database Service (Amazon RDS) is supported. |
Talend Data Preparation
| Support type | Database |
|---|---|
| Recommended (external to the product) | MongoDB 3.4 |
| Supported (embedded in the product) Note: Version not recommended
for production environment as it does not support active/active
clustering.
|
MongoDB 3.4 |
Talend Data Stewardship
| Support type | Database |
|---|---|
| Recommended (external to the product) | MongoDB 3.4 |
| Supported (embedded in the product) Note: Version not recommended
for production environment as it does not support active/active
clustering.
|
MongoDB 3.4 |
Talend Dictionary Service
| Support type | Database |
|---|---|
| Recommended (external to the product) | MongoDB 3.4 |
| Supported (embedded in the product) Note: Version not recommended
for production environment as it does not support active/active
clustering.
|
MongoDB 3.4 |