Database Execute Stored Procedures Configuration

Version 22.0.8473


Database Execute Stored Procedures Configuration

Version 22.0.8473


The Execute Stored Procedures action treats data coming into the Database connector as input for stored procedures. The connector executes the stored procedure that you choose, and then it passes the result down the flow (if applicable).

Follow these steps to configure a stored procedure in a connector:

  1. Select a stored procedure from the drop-down menu. The available stored procedures depend on the connector and cannot be customized from within CData Arc.

  2. Click Show Sample Data to open the Stored Procedure Inputs modal.

  3. Enter the requested information and click Execute.

  4. The Preview XML Output modal opens. Click Save Sample Data to make the data accessible to other connectors.

You can connect the Database connector to an XML Map connector. The results of the Execute Stored Procedure appear as inputs under the Source tree.