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.
| Table of Contents | ||
|---|---|---|
|
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.
| Info |
|---|
| The Stored Procedure Layouts having the Output Mode as XML Stream only will be available on the list, and this list will be GAC controlled. |
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.
| Note |
|---|
| You cannot pass or use a stored procedure in a Mapping Function, for example, String, Math, Date etc. |
To know more about the stored procedure, you can view its definition details clicking Information on the More Action menu. See the screenshot below.
| Info |
|---|
You can also obtain the stored procedure definition by clicking the Info ( ) icon of that stored procedure in the parameters panel. |
| Panel | ||||
|---|---|---|---|---|
| ||||
What's newBest practicesTraining guidesFrequently asked questionsAdeptia Connect APIsAdeptia security report |