Using Stored Procedure from External DB

Unknown

Using Stored Procedure from External DB

Unknown

Can we add a Stored Procedure from an External Database into Decisions?

Unknown

Yes, we can add Stored Procedures from external SQL into Decisions.

First, we will need to integrate the external Database with Decisions. We can do this through System → Integrations → Databases → Create Connection and then add details for your external DB. Refer to our documentation on External Database Integration for more details.[url=http://documentation.decisions.com/docs/insert-update-delete-steps-integration-database]http://documentation.decisions.com/docs/insert-update-delete-steps-integration-database[/url]

We can then add Procedures through Create Datatypes/Integration → Database Integration → Add Procedure → Choose the connection as the External DB → select your desired Procedure.
[i]edited by sonali@decisions.com on 12/20/2019[/i]