Skip to Content
avatar image
Former Member

SAP HCI PI - How to store an editable variable outside the integration flow?

I created an integration flow that queries a database and upserts the results to a SAP HANA database every hour. The initial database table I am replicating in SAP HANA has a field with the timestamp at which each entry's data was altered. To increase performance, instead of selecting each entry in the original database, every time, I want to send a query to retrieve the results of only the entries that were altered or created in the last hour. For this, I need a variable outside of the iFlow that I can call and update with the timestamp of when the iFlow ran the last time and use it in the query.

The iFlow start event is a Timer Start Event set to run hourly and I've tried to store this variable using the "Write Variables" block and set it to Global Scope. But when the integration flows ends and runs an hour later, it resets this variable.

How is the better way for me to do this?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers