Managing connections to log tables - 6.3

Talend Administration Center User Guide

EnrichVersion
6.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 Real-Time Big Data Platform
task
Administration and Monitoring
Deployment
EnrichPlatform
Talend Administration Center

Warning

Only users that have the Operation Manager role and rights can create connections. Other users, depending on their roles, can have either read-only access or no access to this page. For further information on access rights, see User roles/rights in the Administration Center. When a user of the Administration Center opens this page, he/she will have access only to the items for which the user has been granted the right authorization by the Administrator.

To be able to view the log information relative to the monitored Jobs, you need to connect to the relevant tables that hold the data caught by the tStatCatcher and tLogCatcher components (or the relevant log options in your Job).

From the Activity Monitoring Console page, you can add, edit or remove a connection to the log tables.

Adding a new database connection

Prerequisite:

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 the Talend Installation Guide.

To add a new database connection to a log table:

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

  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.

Editing/Deleting a database connection

How to edit the details of a database connection

  1. On the Connections field of the Activity Monitoring Console page, select the database connection you want to modify and click the icon. Its details display in the [Edit/Create Connection] configuration window.

  2. Make the relevant changes to the database connection details where necessary.

  3. Check the connection and click Save to validate the changes.

How to delete a database connection

  • On the Connections field of the Activity Monitoring Console page, select the database connection you want to delete and click the icon. The connection is removed from the connection list.

Note

You cannot delete a connection that is being used by another user.