You define a user-defined program to the Data Warehouse Center so that one or more steps can use the program for processing. If you are defining a stored procedure, you must ensure that the stored procedure exists in the target database. If you are defining any other type of program, you must install the program on one or more Data Warehouse Center agent sites before you define the program to the Data Warehouse Center.
After you define a user-defined program to the Data Warehouse Center, the program definition is available for use as a step in the Process Modeler.
To define a user-defined program to the Data Warehouse Center:
Specify information for your program:
In the Name field, type a new name for the step.
In the Administrator field, type the name of the person who is responsible for the maintenance of this program.
In the Description field, type a business description for your program. This description can be a maximum of 255 characters.
In the Notes field, type detailed information that might be helpful to users who can access this step.
In the Program type field, select the type of program that you are defining.
In the Program Name field, type the fully qualified name of the program.
If the program type is dynamic link library, type the function name in the Function Name field.
Optional: Click the Parameters tab to add system parameters and system tokens to a Data Warehouse Center program definition.
Depending on the type of program that you are defining, click the Agent sites tab or the Targets tab.
If you are defining an agent site, from the Available Agent Sites list, select the agent site on which the program is installed, and click Add. The name of the agent site moves to the Selected Agent Sites list. Repeat this step for each agent site on which the program is installed.
If you are defining a target, from the Available Targets list, select the target on which the stored procedure exists and click Add. The name of the target moves to the Selected Targets list.
Click OK to save your changes and close the notebook.
Related information