Skip to main content
sarahb0004
September 17, 2021
Question

How to use Execute Stored Procedure in process model

  • September 17, 2021
  • 1 reply
  • 0 views

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
    September 17, 2021

    I think this plugins should get you started.

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