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

The same question

Best Answer

Juan Zuluaga ● 7 years ago

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-overview In 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)

Juan Zuluaga ● 7 years ago ●

Dear Pedro,

Thank you very much for your interest in Bizagi.

Best Regards

Reply URL