Configuring Talend Administration Center to run on a different database than MySQL - 8.0

Talend Installation Guide

Version
8.0
Language
English
Operating system
Windows
Subscription type
Subscription
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend LogServer
Talend MDM Server
Talend MDM Web UI
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
Last publication date
2022-10-30
By default, the Talend Administration Center Web application is configured to run with the default MySQL database.

Before you begin

  • The external database must have been created with a utf8 collation.
  • If you want to use a MySQL, Oracle, or MS SQL database for Talend Administration Center, install the right database driver in the application server as described in Installing database drivers in your Web application server.
  • For MySQL users: to prevent further transaction issues when resuming a trigger on the Job Conductor page of Talend Administration Center, it is recommended to configure the transaction isolation level under the [mysqld] group in the mysql.ini or mysql.conf configuration file as follows: transaction-isolation=READ-COMMITTED.

Procedure

  1. Start the application server, then open a Web browser and type the URL of the Talend Administration Center Web application.
  2. On the Login page, click Go to db config page, then enter the administrator password (by default, it is admin).
    Note that if you are starting Talend Administration Center for the first time, you already are on the database configuration page.
    Note:

    Depending on the database security setting, you may need to add additional parameters to your connection URL. For Windows users connecting to a MySQL database, you must load the time zone data into the time zone tables. You can do this by adding the serverTimeZone parameter to the URL:

    jdbc:mysql://hostname:{ip_address}:3306/{db_name}?useSSL=false&serverTimezone={server_time_zone}&allowPublicKeyRetrieval=true

  3. In the Database type list, select your database. As a result, the Driver and URL fields are automatically updated with the template corresponding to this database.
  4. In the URL field, replace the parameters in brackets with your database details.
    Note that you can click the Reload from file button to reload your previous database as changes are not saved until you click Save.
  5. Click Save to take your changes into account.