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.
-
Add a tLogCatcher component, click the Edit schema [...] button, select all of the columns, then click the Copy selected items icon.
![0693p000008uOXeAAM.jpg 0693p000008uOXeAAM.jpg](https://community.qlik.com/t5/image/serverpage/image-id/122989iB91975662F9948A1/image-size/large?v=v2&px=999)
-
Add a tCreateTable component, click the Edit schema [...] button, then click the Paste icon.
![0693p000008uOXjAAM.jpg 0693p000008uOXjAAM.jpg](https://community.qlik.com/t5/image/serverpage/image-id/121657iF0D860073B274AA8/image-size/large?v=v2&px=999)
-
Do the same thing for the other two tables. You can delete the tLogCatcher, tStatCatcher, and tFlowMeterCatcher components once you're done.
-
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:
![0693p000008uNpfAAE.jpg 0693p000008uNpfAAE.jpg](https://community.qlik.com/t5/image/serverpage/image-id/123794i7DC83E10CF299D23/image-size/large?v=v2&px=999)