Compatible databases

^{1 Embedded for developement, test, and demo purposes only. H2 is not supported if you migrate from previous versions. To migrate from a previous version, you need to migrate from H2 to MySQL or other supported databases first in the source version, and then trigger the upgrade of Talend Administration Center to the target version.}

^{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, with these additional parameters: jobserver.log.retriever.deprecated=true and org.quartz.jobStore.clusterCheckinInterval = 240000.}

^{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}

^{5 Talend Administration Center supports the MySQL setup in failover configuration with Red Hat clustering. For more information, see https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/high_availability_add-on_administration/index. Note that you may need to add some parameters to JDBC connection url, as shown in 4.}

^{6 Please update your H2 database to 2.1 version following the procedure: https://help.talend.com/r/en-US/7.3/migration-upgrade-guide/upgrading-administration-database}.

^{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 only.}

^{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 development, test, and demo purposes only.}