How to create AMC tables for any Talend version to any database

Question

How do you create Activity Monitoring Console (AMC) tables for any Talend version to any database?

 

Answer

The easiest way to do this is from a Talend Job, using the schema of the tLogCatcher, tStatCatcher, and tFlowMeterCatcher components.

  1. Add a tLogCatcher component, click the Edit schema [...] button, select all of the columns, then click the Copy selected items icon.

    tLogCatcherSchema.jpg

     

  2. Add a tCreateTable component, click the Edit schema [...] button, then click the Paste icon.

    tCreateTable.jpg

     

  3. Do the same thing for the other two tables. You can delete the tLogCatcher, tStatCatcher, and tFlowMeterCatcher components once you're done.

  4. Use a tDBConnection component to specify your database details, and configure all three tCreateTable components with Use an existing connection.

The Job should look like this:

AMC_JOB.jpg

Version history
Revision #:
3 of 3
Last update:
‎11-18-2019 07:35 AM
Updated by:
 
Contributors