How to connect to Sql server database and execute store procedure.

0
How to connect to Sql server database and execute store procedure.   Thanks in Advance!!
asked
3 answers
1

Where are you stuck with the database connector?

The database connector has two microflow actions to execute sql statements, one for querying, and one for executing statements that return no data.

You probably need the execute statement action, provide it the jdbc url of the database you want to connect to, and the sql statement you need to execute the stored procedure. This usually looks something like;

{ call storedProcedureName(parameter1, parameter2)}

 

answered
0

Are you looking to connect to an external database? Take a look at the database replication module in the app store, this might help.

answered
0

Maybe App Database Connector? It should let you trigger a stored procedure.

answered