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

Talend Big Data Installation Guide for Windows

EnrichVersion
7.1
EnrichProdName
Talend Big Data
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend Log Server
Talend Runtime
Talend Studio

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

For more information on Talend Administration Center database, see Database.

Before you begin

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).
    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 settings, you may need to add additional parameters to your connection URL. For Windows users connecting to a MS SQL 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://{ip_address}:3306/{db_name}?useSSL=false&serverTimezone={timeZone}& 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.