Video: Data Mapping Function Call Stored Procedure

Example 1 – Map to Target Element DBQuery Syntax

DBQuery {'EXEC StoredProcedureName ‘param1’ , ‘param2’  ' ,$varDBConnectionInfo , true }

Example 2 – Steps to Create Target Records from a Multiple Record Result Set

1.       Create local variable on Root level target node

a.       varSPResult = DBQuery {‘EXEC StoredProcedureName ‘param1’, ‘param2’ ’ , $varDBConnectionInfo, true}

2.       Create For Each on Record level target node

a.       $varSPResult//Record

3.       Map database column names to appropriate target schema elements using Textual Rules

a.       i.e. DBColumn1Name