Configuring Talend Administration Center to run on a different database than H2

Talend MDM Platform Installation Guide

EnrichVersion
6.1
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
Talend Identity Management
Talend Administration Center
Talend Artifact Repository
Talend Activity Monitoring Console
Talend MDM Server
Talend Project Audit
Talend Studio
Talend ESB
Talend SAP RFC Server
Talend DQ Portal
Talend JobServer
Talend CommandLine
Talend Log Server
Talend Installer
Talend Repository Manager
Talend Runtime
Talend MDM Web UI

By default, the Talend Administration Center Web application is configured to run with the default H2 embedded database.

To run Talend Administration Center on another database:

  1. 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 (Tomcat or JBoss). For more information, see the article How to install MySQL, Oracle and MS SQL drivers for Talend Administration Center.

    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 MySQL as described in the documentation about preventing transaction issue when resuming a Job Conductor trigger with a MySQL database on Talend Help Center (https://help.talend.com).

  2. Start the application server (Tomcat or JBoss), then open a Web browser and type the URL of the Talend Administration Center Web application.

  3. 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.

  4. 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.

  5. 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.

  6. Click Save to take your changes into account.