Connecting to the H2 Web Console - 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

From Talend Administration Center, you can access the H2 administration console.

For more information about H2 use and troubleshooting, refer to the H2 online documentation on http://www.h2database.com.

Procedure

  1. From the main Menu, click Configuration to access the Configuration page.
  2. On the Configuration page, expand the Database node to display the parameters.
  3. In the Web Console field, click the link to access the H2 Web Console.
  4. The H2 Web Console's Login page displays:
  5. In the User Name and Password fields, type in the connection login and password to the database, by default tisadmin and tisadmin.
  6. The JDBC URL field reads by default:
    jdbc:h2:/<ApplicationPath>/WEB-INF/database/talend_administrator;AUTO_SERVER=TRUE;MVCC=TRUE;LOCK_TIMEOUT=15000
    where <ApplicationPath> is the location where org.talend.administrator was deployed.
    Warning: If you have moved the H2 embedded database location, then fill out the JDBC URL field with the updated URL information. Prior to clicking Connect, click the Test Connection button in order to check the new URL. In case of a mistyped URL, the JDBC URL will revert back to the original URL information.
  7. Click Connect.

Results

The Web database administration page displays.