Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse > Optional Customization Procedures >
Linking Workflows
You may require running consecutive workflows from the Siebel_DW_REP folder and the Custom_Folder. For example, you may customize your Data Warehouse and wish to link a workflow in the custom folder (in the Siebel_DW_Rep repository) to one of the standard workflows. The Informatica Session Manager does not allow you to schedule sessions from two different folders. Therefore, to start the customization workflow, which is defined in your custom folder, upon completion of a standard workflow, such as Full_Load_Siebel_DW, you must use Informatica's pmcmd utility. You may also link the Full_Extract_Siebel_DW and the Full_Load_Siebel_DW workflows to load your initial Siebel Data Warehouse.
Linking Example
If the following command is entered on the Post Session Commands and Email On Success of the last session, it executes a workflow named Custom_Workflow in the Custom folder.
"$PMRootDir\bin\PMCMD" start %INFA_USER %INFA_PASSWORD 4001 Custom:Custom_WORKFLOW 0 0
The environment variables %INFA_USER and %INFA_PASSWORD hold the Informatica user name and password. 4001 is the port number. If your Informatica Server listens on a different port then use the appropriate port. Custom:Custom_WORKFLOW is the name of the Custom_WORKFLOW in the Custom folder. The first 0 means it is a workflow and the second is for the nowait option. You can also use the command PMCMD startworkflow. In this case you need to put a trailing percentage after each environment variable. "$PMRootDir\bin\PMCMD" startworkflow %INFA_USER% %INFA_PASSWORD% 4001 Custom:Custom_WORKFLOW 0 0
For detailed information on how to use pmcmd, see the Informatica documentation.
Environment Variables
You must set up environment variables to start a session or workflow. Environment variables are strings that contain information such as account name, drive, path, or file name. Environment variables control the behavior of various programs. In the case of linking workflows, use an environment variable to control the behavior of Informatica.
Account passwords must be encrypted when used in environment variables. Informatica provides the pmpasswd utility to encrypt them. For example, if the account password is Administrator, you would issue this command:
The pmpasswd utility responds with:
Informatica PowerMart Password Encryption Utility
Encrypted string -->]T288<ibjbpoq9okq<--The text between the "-->" and the "<--" symbols is the encrypted password. If the encrypted text includes a special character, such as the "<" in this example, then use quotation marks around the text when creating the environment variable. For example, in AIX or Solaris you would use this command:
export PMPASS="]T288<ibjbpoq9okq"
where PMPASS is the name of the environment variable you are creating. On Windows, use the Control Panel to define the environment variable (Start > Settings > Control Panel > System > Environment).
Create one environment variable for the account name and password in a command. For example, if the account name for your repository is Administrator, and the account password is also Administrator, you would create an environment variable for each, like this (for AIX and Solaris):
export PMUSER=Administrator
export PMPASS="]T288<ibjbpoq9okq"When using pmcmd, you specify a command, the environment variable for the account name, the environment variable for the password, and any other parameters the command requires. All environment variables must be proceeded by a percent symbol (%) to signify to pmcmd that the value that follows is an environment variable. For example, the ping command requires the account name, password, and a machine identifier, like this:
pmcmd ping %PMUSER %PMPASS columbo:8159
The pmcmd utility responds with:
pmcmd is starting.
Connecting to pmserver at ...
[Transport: TCP/IP, Address: 10.1.21.23, Port: 8159]
pmcmd exiting with successful value for ping
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide Published: 09 September 2004 |