topic Maintaining Talend Audit Table in Talend Studio

Maintaining Talend Audit Table

seelam_sreeram — Thu, 04 Apr 2019 05:55:36 GMT

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

Re: Maintaining Talend Audit Table

Anonymous — Thu, 04 Apr 2019 06:56:55 GMT

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 🙂

Re: Maintaining Talend Audit Table

seelam_sreeram — Sat, 06 Apr 2019 14:50:11 GMT

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

Re: Maintaining Talend Audit Table

Anonymous — Mon, 08 Apr 2019 06:26:29 GMT

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 🙂