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.
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:
From the toolbar on the Activity Monitoring Console page, click the [+] button to open the [Edit/Create Connection] configuration window.
Enter the relevant connection information:
Name of the connection entry in the connection list.
The database type to which you want to connect
URL address the server hosting the log database, including the host, port and the name of the log database to connect to.
If required, set the data source for the selected database
Login name to the database
Password to the database
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.
Name of the table gathering the information caught through the tStatCatcher component in the Job.
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.
How to edit the details of a database connection
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.
Make the relevant changes to the database connection details where necessary.
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.
You cannot delete a connection that is being used by another user.