Answered

How to execute a Microsoft SQL Server stored procedure?

Dear support team,

How to execute a stored procedure into a button Bizagi form (created in the same data base as the BizAgi Project - MSQL)?

Thanks a lot,

Pedro Gentil

Best Answer
photo

Dear Pedro,

Thank you very much for your interest in Bizagi.

This integration is possible by first developing a component (class library) which manages a connection to the external or internal database (Oracle and SQL Server) and provides the methods to execute the stored procedures.

Then, by registering the component in Bizagi Component library (a feature available in the Enterprise .NET and Enterprise JEE edition), it will be possible to execute those stored procedures from business rules in Bizagi.

To illustrate this idea, the following diagram represents this how-to architecture and workings:architecture-overviewIn order to develop and implement the component, follow this article where there is an example: http://help.bizagi.com/bpmsuite/en/index.html?stored_procedures_howto.htm

Best Regards

Comments (1)

photo
0

Dear Pedro,

Thank you very much for your interest in Bizagi.

This integration is possible by first developing a component (class library) which manages a connection to the external or internal database (Oracle and SQL Server) and provides the methods to execute the stored procedures.

Then, by registering the component in Bizagi Component library (a feature available in the Enterprise .NET and Enterprise JEE edition), it will be possible to execute those stored procedures from business rules in Bizagi.

To illustrate this idea, the following diagram represents this how-to architecture and workings:architecture-overviewIn order to develop and implement the component, follow this article where there is an example: http://help.bizagi.com/bpmsuite/en/index.html?stored_procedures_howto.htm

Best Regards