This Integration Template allows the capability to call DB Stored Procedure from Informatica Cloud by using the Custom Integration Task (CIT). Import the Integration Template .xml file and configure template parameters.
Understanding the Template
The template uses filter transform for filtering out data sets. The SP transform executes the stored procedure call to the DB connection defined when setting the CIT parameters.
Setting up the display properties during the import process of the Template
Creating custom integration task based on the templates
- Choose the Integration Template
2. Choose the source
3. Choose the target
4. Complete the filter, connection information, and other parameters
Above is an example of the field coming in from the source and the input field for the Stored Procedure, in this example they both are Item_ID but they can be different and not necessarily the same.
Above is an example of the field coming out from the Stored Procedure call, and getting mapped to the Target system fields.
Sample Stored Procedure Used in this example
Above is an example of calling a Stored Procedure with two input and two output fields.