Skip to main content
sarahb0004
Participating Frequently
Sep 17, 2021 11:48 AM UTC
Question

How to use Execute Stored Procedure in process model

Hello everyone,

I am working with an SQL developer and he created a stored procedure where each time a I saved a record in his staging table, I need to execute his stored procedure to transfer the records to our main table.

I am just not exactly sure how I will add it in my process model. 

I am adding records to his staging table through process model too by using Import CSV to Database v6. Next step should be calling his stored procedure to transfer the records to main table.

Any help will be highly appreciated. Thank you.

    1 reply

    stefanhelzle0001
    Brainy
    Sep 17, 2021 11:55 AM UTC

    I think this plugins should get you started.

    community.appian.com/.../execute-stored-procedure