Job to check data is loaded or not from MySql to Hana

[Prakhar1]

I need to create a job which will check that data is loaded from MySql server to Sap Hana and if the status is true than it will run a stored procedure in Hana.

I need to know from where I can start

[Anonymous]

How the data is loaded from Mysql server to SAP Haha? Is it achieved by another job in Talend or other application?

[Prakhar1]

yes it is done by another job.

it is just one to one mapping.

[Raghuram_Puram]

In the other job, Maintain a Status Global variable or Context variable with default value as failure.

After data is loaded to Hana, with an "OnComponentOK" link, connect to a 'tJava' component and in that tJava assign the Status variable with value as Success.

Then with a 'Run If' link, you can check the status and trigger the stored procedure accordingly.

Cheers.