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

[TalendSolutionExpert]

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.

   

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

   

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: