Informatica

Follow

Informatica Job's through both Windows and Linux/Unix can be automated and managed through JAMS by creating a simple Job, or creating a template with an Execution Method.

Informatica for Windows

Below is an example of a Windows Batch script utilizing PMCMD.exe. The Execution Method used would be Command, ensuring you have the Windows Agent installed on the target Informatica server and defined within the Job's Properties.  

The Source of the Job would contain the Windows batch script that might look something like below.

pmcmd startworkflow -sv MyIntService -d MyDomain -u seller3 -p jackson -f SalesEast wf_SalesAvg

Any operations that could be performed through PMCMD.exe could be executed using a JAMS Job.

Here is a link to the command line reference for using PMCMD from Informatica's support site.

Informatica for Unix

Below is an example of a shell script utilizing PMCMD. The Execution Method used would be SSHAgent, ensuring you have JAMSAgentX installed on the target Informatica server and defined within the Job's Properties.  

Any operations that could be performed through PMCMD could be executed using a JAMS Job.

#!/usr/bin/bash
# Sample pmcmd script
# Check if the service is alive

pmcmd pingservice -sv testService -d testDomain

if [ "$?" != 0 ]; then

# handle error
echo "Could not ping service"
exit
fi

# Get service properties
pmcmd getserviceproperties -sv testService -d testDomain
if [ "$?" != 0 ]; then

# handle error
echo "Could not get service properties"
exit
fi

# Get task details for session task "s_testSessionTask" of workflow

# "wf_test_workflow" in folder "testFolder"
pmcmd gettaskdetails -sv testService -d testDomain -u Administrator -p adminPass -folder testFolder -
workflow wf_test_workflow s_testSessionTask
if [ "$?" != 0 ]; then

# handle error
echo "Could not get details for task s_testSessionTask"
exit
fi

  

Have more questions? Submit a request

Comments