Adding a new database connection - 7.3

Talend Administration Center User Guide

EnrichVersion
7.3
EnrichProdName
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
EnrichPlatform
Talend Administration Center
task
Administration and Monitoring

Before you begin

To establish a connection to a database in the Monitoring node, you must first put the corresponding .jar file in the Tomcat lib folder, otherwise your database connection can not be initialized. For more information about the databases compatible with Talend Activity Monitoring Console, see Compatible databases.

About this task

To add a new database connection to a log table:

Procedure

  1. From the toolbar on the Activity Monitoring Console page, click the [+] button to open the Edit/Create Connection configuration window.

    Example

  2. Enter the relevant connection information:

    Field

    Description

    Label

    Name of the connection entry in the connection list.

    DB type

    The database type to which you want to connect

    URL

    URL address the server hosting the log database, including the host, port and the name of the log database to connect to.

    Datasource

    If required, set the data source for the selected database

    Username

    Login name to the database

    Password

    Password to the database

    Log table

    Name of the table gathering the information caught through the tLogCatcher component in the Job.

    Flow meter table

    Name of the table gathering the information caught through the tFlowMeterCatcher component in the Job.

    Stat table

    Name of the table gathering the information caught through the tStatCatcher component in the Job.

  3. Click Check connection to test the database connection, then click Save to add the database connection or click Cancel to close the window without saving any changes.
    To access the Talend Activity Monitoring Console Web application, the same connection you have configured in the Studio preferences (Preferences > AMC > Datasource Type) should be added in this window.