Skip to Content

Trigger HANA Stored procedure after SLT job

Hi Experts,

We have a requirement to trigger a HANA Stored Procedure after successful completion of the SLT process.

To explain in detail, we have a custom ABAP program in SAP which loads the data into a table in SAP and we are currently replicating this table into HANA. After all the records are replicated, we wanted to trigger a Stored Procedure in HANA which reads this replicated table and performs a business logic and stores the data in another table.

I'm struck here, I don't know how to find if the replication of all records are done successfully.

Since this SAP table is a drop and re-load, my thought was to stop the replication of this table and by using a scheduling tool like Control M, I will run the initial replication job for this table by using an ABAP program which will trigger the initial load. After the completion of this job, I will schedule my stored procedure.

But I'm not sure if I can trigger the Initial Load using any ABAP program or is there any way that I can sequence this process.

Kindly let me know if you need anymore details.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 08, 2018 at 08:13 AM

    That's not what SLT is made for. Your scenario would be better suited by using SDI or SDA where you can completely control when the data transfer should happen.

    Add comment
    10|10000 characters needed characters exceeded