Maintaining Talend Audit Table

[seelam_sreeram]

Hi All, 

I have created an audit table in db mysql and i want to insert the data into the table when job fails and success. I dont want to use any flowmetercatcher or statmetercatcher. 

I just want to use tjava and and insert every variable such as job start and job end time to no of rows inserted. 

Any help please !

Thanks,

Murthy

[Anonymous]

Hi Murthy,

      The prebuilt components are a medium to reduce your developement efforts to capture these details. If you want to load them manually, you will have to capture the system time details of your own using tjava and assign them to context variables.

      Then you can load them to database later using tMySQLOutput component.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[seelam_sreeram]

Hi Nikhil, 

Thanks for your reply !

Could you please help me with a use case and implement it using a job through practical ways. 

Thanks,

Murthy 

[Anonymous]

Hi,

    Please refer the below links for getting more details about Audit part in Talend.

https://help.talend.com/reader/RK~CAb9nJ1erxR8SrBbKoQ/4Pjemscy9lFQcASrDvDktw

https://www.talend.com/resources/data-integration-amc-studio-features/

https://help.talend.com/reader/kFNwf~5Dq7LSoA2KgSHa1g/n4GDrkZoz7Zdg_uSn~jvGw

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂