Can I execute a CAP function on a HANA database trigger?

[shinjan]

Hi,

I have a scenario where some table data is getting replicated into HANA from an ECC system with the help of SLT.

The requirement is to send these records over to an external system as soon as they reach HANA using an HTTP POST. The table has timestamps allowing me to identify the latest records.

My question is:

1. Is there a way to hookup some XSODATA or CAP odata to perform a post call on database triggers?
2. Is there a way for CAP Events to respond to table record changes in a schema as soon as this happens?
3. Do I have to create a job that will periodically read this table and compile it for post calls from a CAP project?

Thank you for your help.

[Cocquerel · Accepted solution]

you can use SLT in cascade. In the second SLT configuration, your HANA system would be the source and the external system would be the target.

For this, you can use the SLT SDK: see https://help.sap.com/docs/SAP_LANDSCAPE_TRANSFORMATION_REPLICATION_SERVER/007c373fcacb4003b990c6fac2...

In the SLT BADI, you would use CL_HTTP_CLIENT ABAP Class to call your external system API and post data.