Calling a Stored Procedure from Data Mapper

This page guide you where do you find the stored procedure layouts in Data Mapper and how can use these layouts as rules in mapping. It contains the following two sections.

Stored Procedure Layout in the Data Mapper

You can find Stored Procedure listed as one of the layout types on the Select Layout screen that you can open by clicking the Load Layout option on the Open () Menu in the Data Mapper. See the screenshot below.

Click Load to load the layouts defined during the creation of the stored procedure. See the screenshot (example) below.

Stored Procedure as a Rule in Mapping

You can use a stored procedure as a Rule in Mapping. In the Parameters panel, you can find Stored Procedure listed as a category, and it has all the stored procedures (GAC controlled) available in Adeptia Connect. Refer to the screenshot below.

You can double-click a stored procedure from this list to use as a Rule on a Destination element. In or InOut parameters can serve as inputs for this rule. See a screenshot (example ) below.

To know more about the stored procedure, you can view its definition details clicking Information on the More Action menu. See the screenshot below.

You can also obtain the stored procedure definition by clicking the Info () icon of that stored procedure in the parameters panel.