You can create external procedures that run on 32-bit or 64-bit Integration Service machines. Complete the following steps to create an Informatica-style external procedure:
In the Transformation Developer, create an External Procedure transformation.
The External Procedure transformation defines the signature of the procedure. The names of the ports, datatypes and port type (input or output) must match the signature of the external procedure.
Generate the template code for the external procedure.
When you execute this command, the Designer uses the information from the External Procedure transformation to create several C++ source code files and a makefile. One of these source code files contains a “stub” for the function whose signature you defined in the transformation.
Modify the code to add the procedure logic. Fill out the stub with an implementation and use a C++ compiler to compile and link the source code files into a dynamic link library or shared library.
When the Integration Service encounters an External Procedure transformation bound to an Informatica procedure, it loads the DLL or shared library and calls the external procedure you defined.
Build the library and copy it to the Integration Service machine.
Create a mapping with the External Procedure transformation.
Run the session in a workflow.
The BankSoft example illustrates how to implement this feature.
ASK INFAPreview
