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
Database | Version | Supported driver | Support type |
---|---|---|---|
MySQL4 | 8.0 | mysql-connector-java-8.x.jar | Recommended |
5.7 | Supported | ||
Oracle | 19c | ojdbc10.jar ojdbc8.jar ojdbc7-11g.jar ojdbc7.jar |
Recommended |
18c | Supported | ||
12c release 1 | Supported | ||
11g | Supported | ||
Azure SQL | mssql-jdbc-7.4.1.jre8.jar | Supported | |
H2 1 | 1.4 | h2-1.4.187.jar | Supported |
MariaDB 2 | 10.1 | mariadb-java-client-1.1.7.jar | Supported |
MS SQL Server 3 | 2017 | jtds-1.3.1.jar mssql-jdbc-7.4.1.jre11.jar mssql-jdbc-7.4.1.jre8.jar |
Supported |
2016 | Supported | ||
2014 | Supported | ||
2012 SP2 | Recommended | ||
PostgreSQL | 11 | postgresql-42.2.10.jar | Supported |
10 | Supported | ||
9.6 | Supported | ||
9.5 | Supported |
1 Embedded for developement, test, and demo purposes. Not suitable for a production enviornment.
2 When you create a database schema using
MariaDB 10.1, you must use UTF8 encoding. For example: CREATE DATABASE <YOUR_DATABASE_NAME> DEFAULT
CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
3 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher. MSSQL cluster is supported for Talend Administration Center.
4 MySQL InnoDB cluster is supported by
Talend Administration Center. When using
the InnoDB cluster, you may need to change the JDBC url as the cluster
systerm env, for example, JDBCUrl:jdbc:mysql://192.168.1.32:6446/TAC?useSSL=true&connectTimeout=15000&socketTimeout=15000&autoReconnect=true
.
IP address 192.168.1.32 and port 6446 are the IP address of the mysqlrouter
host and the RW port of mysql router.
My MySQL Route Classic protocol: Read/Write Connections: localhost:6446 Read/Only Connections: localhost:6447
Talend Identity and Access Management
Use the same database type and version for oidc
and idp
databases.
For more information about the databases supported by Apache Syncope, see Apache Syncope documentation.
Database | Version | Supported drivers | Support type |
---|---|---|---|
MySQL | 8.0 1, 3 | mysql-connector-java-8.x.jar | Recommended |
Oracle | 19c |
ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar ojdbc10.jar |
Recommended |
18c | Supported | ||
12c release 1 3 | Supported | ||
11g | Supported | ||
Azure SQL | jtds-1.3.1_patched.jar | Supported | |
H2 4 | 1.4 | h2-1.4.187.jar | Supported |
MS SQL Server 2, 3 | 2017 | jtds-1.3.1.jar | Supported |
2016 | Supported | ||
2014 | Supported | ||
2012 (SP2) | Supported | ||
PostgreSQL 3 | 11 | postgresql-42.2.2.jre7.jar | Supported |
10 | Supported | ||
9.6 | Supported | ||
9.5 3 | Supported |
1 Google Cloud SQL is supported.
2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.
3 Amazon RDS is supported.
4 Embedded for developement, test, and demo purposes. Not suitable for a production enviornment.
Talend Activity Monitoring Console
Database | Version | Supported drivers | Support type |
---|---|---|---|
MySQL | 8.0 1, 3 | mysql-connector-java-8.x.jar | Recommended |
Oracle | 19c |
ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar ojdbc10.jar |
Recommended |
18c | Supported | ||
12c release 1 3 | Supported | ||
11g | Supported | ||
H2 4 | 1.4 | h2-1.4.187.jar | Supported |
MS SQL Server 2, 3 | 2017 | jtds-1.3.1.jar | Supported |
2016 | Supported | ||
2014 | Supported | ||
2012 SP2 | Supported | ||
PostgreSQL 3 | 11 | postgresql-42.2.2.jre7.jar | Supported |
10 | Supported | ||
9.6 | Supported | ||
9.5 | Supported |
1 Google Cloud SQL is supported.
2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.
3 Amazon RDS is supported.
4 Embedded for developement, test, and demo purposes. Not suitable for a production enviornment.
Talend DQ Portal
Talend DQ Portal is deprecated from Talend 7.1 onwards.
Database | Version | Supported drivers | Support type |
---|---|---|---|
MySQL | 8.0 1, 3 | mysql-connector-java-8.x.jar | Recommended |
5.7 | Supported | ||
Oracle | 19c | ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar ojdbc10.jar |
Recommended |
18c | Supported | ||
12c release 1 3 | Supported | ||
11g | Supported | ||
Azure SQL 4 | jtds-1.3.1_patched.jar | Supported | |
MS SQL Server 2, 3 | 2017 | jtds-1.3.1.jar | Supported |
2016 | Supported | ||
2014 | Supported | ||
2012 SP2 | Supported | ||
PostgreSQL 3 | 11 | postgresql-42.2.2.jre7.jar | Supported |
10 | Supported | ||
9.6 | Supported | ||
9.5 | Supported |
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.
1 Google Cloud SQL is supported.
2 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.
3 Amazon RDS is supported.
4 The jTDS-1.3.1.jar patched driver is the only supported driver.
Database used to store the portal configuration | Version | Support type |
---|---|---|
HSQL 1 | 2.3.2 | Supported |
1 Embedded in the product.
Talend Repository Manager
Database | Version | Supported driver | Support type |
---|---|---|---|
MySQL | 8.0 1, 5 | mysql-connector-java-8.x.jar | Recommended |
5.7 | Supported | ||
Oracle | 19c | ojdbc7-11g.jar ojdbc7.jar ojdbc8.jar ojdbc10.jar |
Recommended |
18c | Supported | ||
12c release 1 5 | Supported | ||
11g | Supported | ||
Azure SQL | jtds-1.3.1_patched.jar | Supported | |
H2 2 | 1.4 | h2-1.4.187.jar | Supported |
MariaDB 3 | 10.1 | mariadb-java-client-1.1.7.jar | Supported |
MS SQL Server 4, 5 | 2017 | jtds-1.3.1.jar | Supported |
2016 | Supported | ||
2014 | Supported | ||
2012 SP2 | Supported | ||
PostgreSQL 5 | 11 | postgresql-42.2.2.jre7.jar | Supported |
10 | Supported | ||
9.6 | Supported | ||
9.5 | Supported |
1 Google Cloud SQL is supported.
2 Embedded for developement, test, and demo purposes. Not suitable for a production enviornment.
3 When you create a database schema
using MariaDB 10.1, you must use UTF8 encoding. For example: CREATE DATABASE <YOUR_DATABAE_NAME> DEFAULT
CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
4 Talend supports the Always Encrypted feature of Microsoft SQL Server 2016 or higher.
5 Amazon RDS is supported.
Talend Data Preparation
Database | Versions | Support type |
---|---|---|
MongoDB | 4.2 | Supported (embedded in the product) Note: Version not recommended for production
environment as it does not support active/active
clustering.
|
4.x | Recommended (external to the product) | |
3.6 | Recommended (external to the product) |
Talend Data Stewardship
Database | Versions | Support type |
---|---|---|
MongoDB | 4.2 | Supported (embedded in the product) Note: Version not recommended for production
environment as it does not support active/active
clustering.
|
4.x | Recommended (external to the product) | |
3.6 | Recommended (external to the product) |
Talend Dictionary Service
Database | Versions | Support type |
---|---|---|
MongoDB | 4.2 | Supported (embedded in the product) Note: Version not recommended for production
environment as it does not support active/active
clustering.
|
4.x | Recommended (external to the product) | |
3.6 | Recommended (external to the product) |