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

Six Stars

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

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

Community Manager

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

How the data is loaded from Mysql server to SAP Haha? Is it achieved by another job in Talend or other application?
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

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

yes it is done by another job.

it is just one to one mapping.

Six Stars

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

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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog