Informatica Agent Guide

Informatica
Agent Guide v3.2.0
Automic Software GmbH
ii Copyright
Copyright
Automic® and the Automic logo® are trademarks owned by Automic Software GmbH (Automic). All
such trademarks can be used by permission only and are subject to the written license terms. This
software/computer program is proprietary and confidential to Automic Software and is only available
for access and use under approved written license terms. This software/computer program is further protected by copyright laws, international treaties and
other domestic and international laws and any unauthorized access or use gives rise to civil and
criminal penalties. Unauthorized copying or other reproduction of any form (in whole or in part),
disassembly, decompilation, reverse engineering, modification, and development of any derivative
works are all strictly prohibited, and any party or person engaging in such will be prosecuted by
Automic.
No liability is accepted for any changes, mistakes, printing or production errors. Reproduction in
whole or in part without permission is prohibited.
© Copyright Automic Software GmbH. All rights reserved.
Informatica Agent Guide v3.2.0 iii
Contents
1 The Rapid Automation Informatica Agent Integration
1
1.1 Introduction to the Rapid Automation Informatica Agent
1
1.2 About Rapid Automation Agents
2
1.3 Help Files Location and Agent Guide Format
3
2 Working with the Informatica Agent Integration
5
2.1 Informatica Administration
5
2.2 Installing the Agent in an Existing Automation Engine System
6
2.3 Loading Rapid Automation Component .jar Files into Applications Manager v8.0
9
2.4 Creating Informatica Connection Objects
11
2.5 Creating an Informatica Agent
12
2.6 Automatically Creating Informatica WorkFlow Jobs
14
2.7 Manually Creating Informatica WorkFlow Jobs
17
2.8 Manually Creating Informatica Session, Task, or Worklet Jobs
21
2.9 Adding Informatica Specific Status Columns to the Applications Manager Backlog
24
2.10 Requesting Jobs That Cannot Run Concurrently in Informatica
25
2.11 Managing Output and Execution Options with the RA Tab
26
2.12 Setting Trace
28
2.13 Setting Debug in Applications Manager v8.0
30
iv
Contents
Informatica Agent Guide v3.2.0 1
1 The Rapid Automation Informatica
Agent Integration
1.1 Introduction to the Rapid Automation
Informatica Agent
Informatica is the leading ETL tool in the market place. The Informatica Rapid Automation agent
integration runs jobs using Informatica Integration Service. It is designed to work with Automation
Engine v9, Operations Manager and Applications Manager. It includes special panels for connection
objects, agents, and jobs.
For the Informatica Rapid Automation agent integration, you will need to create one or more:
l
l
l
Connection objects (referred to as logins in Applications Manager)
Agents
Jobs to run Informatica WorkFlows, Tasks, Sessions, or Worklets
About Rapid Automation Panels
Rapid Automation agent integrations such as Informatica appear the same in the following
Automation Engines:
l
l
l
l
v10
v9
Operations Manager v8.00
Applications Manager v8.0
The panels are designed to work identically in any of them.
The topics in this guide describe how to use these objects, not how to use the Automation Engines
listed above. For this reason, topics on creating connection objects, agents, jobs, etc. describe the
Rapid Automation objects, but not how to create objects.
2
Chapter 1 The Rapid Automation Informatica Agent Integration
1.2 About Rapid Automation Agents
After loading a Rapid Automation .jar file in to the Automation Engine, you will be able to define
agent-specific connection, agent, and job objects with unique panels.
After loading a Rapid Automation .jar file in to the Automation Engine, you will be able to define RA
agent-specific connection, agent, and job objects with unique panels. The topics in the Rapid
Automation agent guides describe how to use these RA panels, not how to define connection,
agent, and job objects. For information on creating these objects, see your Automation Engine
documentation.
Overriding Settings on RA Agent-specific Tabs in Automation
Engine v9 and v10
You can override settings on the RA agent-specific tab (requires Automation Engine v9 Service
Pack 4 or Above) for:
l
l
l
A single run of a Rapid Automation job you execute. To activate this option for a job, the
Request task parameters option must be checked on the RA tab of a job’s definition. For
more information, see Managing Output and Execution Options with the RA Tab .
Rapid Automation jobs added as tasks in a workflow (referred to as process flows prior to
Automation Engine v9 Service Pack 4). For more information on editing workflow tasks, see
your Automation Engine documentation.
A single run of a non-running task in the Activities window by right-clicking and selecting
Modify Task Parameters.
Using Object Variables Instead of :PUT_ATT Commands in
Operations Manager v8.00, Automation Engine v9 and v10
Attributes of Rapid Automation jobs may change when new versions of the Rapid Automation
agents are released. When this happens, :PUT_ATT commands defined in earlier versions of the
agents will no longer work. Therefore, in Rapid Automation jobs, we recommend that you always
use object variables for field replacements, not :PUT_ATT commands.
To change a job from using a :PUT_ATT command to an object variable, do the following:
1. Remove the :PUT_ATT command from the job’s Process or Pre-Process tab.
2. Add a variable to the Variables & Prompts tab of job.
3. In the field where you wish to replace a value, enter the object variable in the format
&<variable># where <variable> represents the variable name you entered on the Variables
& Prompts tab.
Informatica Agent Guide v3.2.0 3
1.3 Help Files Location and Agent Guide
Format
Help files for each Rapid Automation agent exist as their own JavaHelp project.
The help files for each Rapid Automation agent are updated when you upgrade your agent, not when
you upgrade your Automation Engine. Therefore they exist as their own JavaHelp project. To open
the Rapid Automation agent help, click the help button on the bottom of the RA agent-specific tab of
your agent or job objects.
Agent Guide Format
This agent Guide is written as a series of topics. Each topic begins with a heading followed by a
summary paragraph. The summary paragraph states the key concepts presented in the topic.
To get a quick overview of a chapter, read the summary paragraph for each topic and look at the
images and their captions.
4
Chapter 1 The Rapid Automation Informatica Agent Integration
Informatica Agent Guide v3.2.0 5
2 Working with the Informatica
Agent Integration
2.1 Informatica Administration
The basic steps for implementing the Rapid Automation Informatica agent are described below.
The basic steps for implementing the Rapid Automation Informatica agent include:
1. Setting the following environment variables for the OS user that runs the Informatica agent
as shown in the examples below.
For UNIX/Linux:
INFA_HOME=/informatica/9.x
INFA_DOMAINS_FILE=$INFA_HOME/domains.infa
For Windows:
INFA_HOME=C:\informatica\9.x
INFA_DOMAINS_FILE=%INFA_HOME%\domains.infa
2. Setting the library path variable for the user that runs the Informatica agent as shown in the
examples below.
For UNIX/Linux:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INFA_HOME/server/bin
For AIX:
LIBPATH=$LIBPATH:$INFA_HOME/server/bin
3. Creating one or more Informatica connection objects that will be used by your Informatica
jobs to connect to the Informatica repository.
4. Creating an Informatica agent object.
5. Create jobs:
l Manually for Informatica WorkFlows, Tasks, Sessions, and Worklets.
l Automatically for Informatica WorkFlows using the Create Jobs sub-tab in the
Informatica agent.
6
Chapter 2 Working with the Informatica Agent Integration
2.2 Installing the Agent in an Existing
Automation Engine System
This topic describes how to install the Informatica agent in an existing Automation Engine system.
This topis is not relevant when your Automation Engine is Applications Manager. For information
on loading Rapid Automation .jar files into Applications Manager, see Loading Rapid Automation
Component .jar Files into Applications Manager v8.0.
Java Requirements
On the host and each machine where an Automation Engine UserInterface is installed, check the
current version of your system’s Java Virtual Machine (VM) using the following command:
java -version
The required Java version is 1.6 on every machine.
For platform-specific Java requirements on your Automation Engine machine, see your Automation
Engine release notes.
You can get the necessary files to install Java from
http://www.oracle.com/technetwork/java/index.html.
Supplied Files
The files that belong to the RA agent are stored in the Automation Engine's
IMAGE:AGENTS\RAPIDAUTOMATION directory.
File name
Description
ucxjcitx.jar Agent for Rapid Automation
ucxjcitx.ini Configuration file
*.jar
Libraries
uc.msl
Message library
setup.exe
The Windows installation executable
Setting Up a New or Upgraded Agent
To set-up an RA agent, you need:
l
l
l
l
A license loaded in the database for the agent.
To put the agent files on the host machine.
To edit the ucxjcitx.ini file.
To load the RA solution.
Informatica Agent Guide v3.2.0 7
License File Requirement
License files for RA agents need to have a EX.RA.<AGENT TYPE> line in them and be loaded into
the database. For more information on loading keyfiles, see your Automation Engine
documentation.
Putting Agent Files on the Host Machine
On the host machine, create a directory for the RA agent and copy the supplied files to it. We highly
recommend installing the agent in its own directory. For example, AE/agent/rapidautomation or
C:\AE\agent\rapidautomation. For UNIX, unpack the file using the following command:
cat ucxjcitx.tar.gz |uncompress |tar vxf On Windows, run the setup.exe file.
Creating the cache Directory
The RA Solution to be used by the agent will be stored in the directory named cache. Create this
directory in the installation directory.
Editing the ucxjcitx.ini File
Edit the required parameters in the ucxjcitx.ini file for the RA agent described in the table below.
Parameter Description
system
Automation Engine system name. This entry must be identical to the entry in the .ini
file of the Automation Engine server.
name
Name of the agent. The agent name is limited to 32 of the following characters: “AZ”, “0-9”, “_”, “.”, “$”, “@”, “-” and “#”.
cache_
directory
Directory to which the agent should store the RA solutions. This will be set to cache
by default and does not need to be altered unless you want to change it.
cp
Address of the communication process in the Automation Engine system to which
the agent should connect itself. The format is:
<DNS name or TCP/IP address>:<port number>
ra
Used for additional trace.
For information on the additional parameters in the ucxjcitx.ini file, see your Automation Engine
documentation.
A sample ucxjcitx.ini file is shown below. The required parameters are shown in bold:
[GLOBAL]
system=AE
name=RA01
logcount=10 logging=../temp/CIT_LOGG_##.TXT
max_logging_kb=50
language=E helplib=uc.msl
[AUTHORIZATION]
InitialPackage=
KeyStore=
8
Chapter 2 Working with the Informatica Agent Integration
[RA]
cache_directory=cache
[TCP/IP]
connect=20
cp=localhost:2217
[VARIABLES]
uc_host_jcl_var=CIT
[TRACE]
file=../temp/CIT_TRACE_##.TXT
max_trace_kb=8000
tcp/ip=0
trccount=10
ra=0
[CP_LIST]
2218=PC01
Loading the RA Solution
On the host machine, start the utility AE.DB Load and select the RA Solution’s .jar file. The utility
will then load it to the Automation Engine database. The .jar file can be loaded via the graphical
interface or the Java batch mode (ucybdbld.jar) of the utility AE DB Load. Loading with the AE DB
Load in batch mode (ucybdbld.exe) under Windows is not possible.
The RA agent can only connect to one RA Solution. If you intend to use several RA Solutions,
keep in mind that each solution requires its own RA agent.
You cannot load the same JAR file of an RA Solution to several systems at a time. Any attempt
to do so can cause the utility AE DB Load to abort.
Informatica Agent Guide v3.2.0 9
2.3 Loading Rapid Automation Component
.jar Files into Applications Manager v8.0
To load a Rapid Automation component .jar files into Applications Manager, go to the Tools menu
and select Rapid Automation Loader. This opens the Rapid Automation Loader window where you
can browse to a directory where components are located, pick one and load it.
This topis is not relevant when your Automation Engine is Operations Manager v8.00, v9, or v10.
For information on loading Rapid Automation .jar files into those Automation Engines, see
Installing the Agent in an Existing Automation Engine System.
You load Rapid Automation agent component .jar files into Applications Manager with the Rapid
Automation loader.
keyfile.ini Requirements
With Applications Manager, RA agents requires two lines in the keyfile.ini, one that allows the user
to load the agent .jar file and the other that allows the specific type of agent to run. If you have
purchased an RA agent, your keyfile.ini will have the appropriate lines. However, if they are not
present, or if you grab a keyfile.ini from a different instance, you will either not see the Rapid
Automation Loader menu item (in the case of not having the RA line) or not be able to start the RA
agent. Text from a sample keyfile.ini file with the RA loader and two RA agents is shown below:
RA=06-03-2013x12-31-2013x999
FTPAGENT=06-03-2013x12-31-2013x999
BANNERAGENT=06-03-2013x12-31-2013x999
Using the Rapid Automation Loader
To use the Rapid Automation Loader:
1. Go to the Tools menu and select Rapid Automation Loader.
Applications Manager opens the Rapid Automation Loader window shown in below.
Browse to an RA component directory, pick a component and load it.
2. From the Rapid Automation Loader window, browse to a directory where RA components
are on your PC using the Browse button.
3. Select a component from the Available Components box.
4. Optionally enter an ID number for the component in the ID field. If you don’t enter an ID
number the next available number will be used.
10
Chapter 2 Working with the Informatica Agent Integration
In most cases you would not need to worry about ID numbers. You would only need to set
one in rare cases such as when an agent with references is deleted out of the database and it
needs to be recreated with the same number in the SO_OPERATORS table.
5. Click OK or Apply.
OK saves the changes and closes the window. Apply saves the changes and keeps the
window open. In either case a confirmation window will tell you that the component was
loaded and the component will be added to the Loaded Components box.
You will now be able to define agents of this type in Applications Manager.
6. If you are upgrading an existing RA agent type that you have agents defined for, you must
stop and restart the AgentService process for all previously defined agents.
7. For some agents, such as Business Objects, you must log out and log back in to the
Applications Manager Client.
Deleting Loaded Components
To delete a loaded component, select the component and click Delete. In order to delete a
component, you must first delete any objects from Applications Manager that reference this
component.
Comparing Build Information
To compare build information between available and loaded components, select an available
component from your PC in the Available Components box and a loaded component from the
Loaded Components box and click Build Info. Applications Manager opens the Build Info window
shown below where you can compare the information for the two builds.
Compare available and loaded builds from the Build Info window.
Informatica Agent Guide v3.2.0 11
2.4 Creating Informatica Connection Objects
Informatica connection objects are used by Informatica jobs to connect to the Informatica
repository.
To create Automation Engine jobs from an Informatica repository, you must first create an
Informatica connection object (referred to as a login object in Applications Manager). An Informatica
connection object includes the panel shown in Figure A. You assign the connection object to the
jobs during job creation.
A sample Informatica connection object
The fields are described in the table below.
Field
Description
Repository-Name
The Informatica repository name.
Domain of
Repository
The location of Informatica repository. Required if the agent is not installed
on the Informatica Server
Security Domain
Determines the Authentication method used. Required if using LDAP.
Domain Name
The domain name.
Integration Service Integration service name.
Name
User Name
The user name.
Password
The password.
For information on defining connection objects, see your Automation Engine documentation.
12
Chapter 2 Working with the Informatica Agent Integration
2.5 Creating an Informatica Agent
On the General sub-tab of the Informatica agent, you specify the path to the pmrep and pmcmd
directory, the connection timeout, job status polling interval.
Install an Informatica agent in your Automation Engine. The Informatica agent must reside in a
location where the Informatica Client or Informatica Server is installed.
Informatica agents include an Informatica tab with General and Create Job sub-tabs.
Specifying General Settings
The General sub-tab for a sample Informatica agent is shown in Figure A.
The Informatica agent’s General sub-tab
The fields are described in the table below.
Field
Description
Path to
pmrep
and
pmcmd
Directory
The path to the pmrep, pmcmd, and infacmd directory where the agent is installed.
Job Start The number of seconds before you want Informatica jobs to timeout after they are
Timeout
started in the Automation Engine, if they have not been started by the Integration
(seconds) Service. Default value is 180.
Informatica Agent Guide v3.2.0 13
Field
Description
Job
The number of seconds between job status updates. Default value is 20.
Status
Polling
Interval
(seconds)
Job
Finish
Status
Check
After
Started
(seconds)
The number of seconds to hold before making a check to see whether the job has
finished. The reason you might want to set this to a value other than 0, is to free
resources to prioritize any newly requested jobs to start before making this status
check. A value other than 0 would be beneficial if you have a lot of jobs launched at
the same time. If you need to use this setting, you would only set it to a few seconds.
This setting will have a minimal effect on your Informatica jobs, because they take
more than a few seconds to finish anyway. Default value is 0.
Session
Log File
Transfer
Option
Determines the default behavior for when the Informatica agent transfers Session
logs for WorkFlow jobs. Whether or not you transfer Session log files affects how
long it takes for the jobs to complete in the Automation Engine. The options are:
l
l
l
l
Always: Transfers log files for all Sessions in WorkFlows.
For Failed Sessions or WorkFlows: Transfers log files for failed Sessions
in WorkFlows and/or all Sessions for failed WorkFlows.
Only for Failed Sessions: Transfers log files for failed Sessions in
WorkFlows.
Never: Does not transfer log files for Sessions in WorkFlows. When this
option is selected, the Session log file name is not listed in the job report. The
word "null" is written in its place.
The option you select here can be overridden in individual WorkFlow job definitions.
For more information, see topic Manually Creating Informatica WorkFlow Jobs.
WorkFlow log files are always transferred.
14
Chapter 2 Working with the Informatica Agent Integration
2.6 Automatically Creating Informatica
WorkFlow Jobs
Create Informatica WorkFlow jobs on the Create Jobs sub-tab by selecting a folder, the
WorkFlows, and a template job, optionally adding a prefix and/or suffix for the job names, and
clicking Create Jobs.
You can automatically create Informatica WorkFlow jobs using the Create Jobs sub-tab. Before
creating jobs, you must have a template Informatica WorkFlow job defined. The template job you
select determines what settings will be used on all the job’s tabs other than the Informatica tab.
To automatically create Informatica WorkFlow jobs:
1. Open the Informatica agent definition and select the Informatica tab and then the Create
Jobs sub-tab shown in Figure A.
If you are using Automation Engine v9 or Operations Manager v8.00, you should view the
Informatica agent from the numbered client where you wish to create the jobs.
The Informatica agent’s Create Jobs sub-tab
2. From the Connection to Repository field, select a connection object. The connection
object you select here will:
l Activate the Select button for the Folder Name field.
l Activate the Select button for the WorkFlow Name field, once a folder is entered in
the Folder Name field.
l Be selected as the connection object in the WorkFlow jobs you create.
Make sure you select a connection object that can connect to the agent of the job you select
in the Template Job field below.
Informatica Agent Guide v3.2.0 15
3. From the Folder Name field, select the Informatica folder where the WorkFlows you wish to
create jobs for exist by doing one of the following:
l Typing the Informatica folder name.
l Using the Select button to select the folder from a pop-up window.
4. From the WorkFlow Name field, select the Informatica WorkFlows you wish to create jobs
for exist by doing one of the following:
l Typing in the WorkFlows using commas with no spaces as delimiters.
l Using the Select button to select the WorkFlows from the WorkFlow Names window
shown in Figure B. On the WorkFlow Names window, you select the WorkFlows and
move selection from Unassigned panel and Assigned panel using the arrow button.
You can type the first few letters of a search in the Search field, and the Informatica
agent will filter the results. The Search field also supports UNIX regular expressions
and the Oracle % wildcard for multiple characters. For more information on the
Search fields, see About Rapid Automation Agents.
The WorkFlow Names window
The display of the WorkFlow Names window will be different, depending on whether
the Exclude Existing Jobs box on the Create Jobs sub-tab is checked.
If the
Exclude
Existing
Jobs box
is:
Informatica WorkFlows that already have Automation Engine
jobs created for them will:
Checked
(default)
Not be listed under the Unassigned panel in the WorkFlow Names
window.
Unchecked Be listed under the Unassigned panel in the WorkFlow Names
window, and there will be a read-only check in the checkbox under
the Job Exists column checked as read-only. In Operations Manager
v8.00 and Applications Manager v8.0, entries in the Job Exists
column display true or false rather than read-only checkboxes.
If you wish to create jobs for Informatica WorkFlows with existing
jobs, you need to make sure that a different syntax is used in the New
Job Name field on the Create Jobs sub-tab.
After assigning WorkFlows to create jobs for on the WorkFlow Names window, click
OK to save.
5. In the Template Job field, select a template job.
16
Chapter 2 Working with the Informatica Agent Integration
The template job is an existing Informatica WorkFlow job that determines what settings will
be used on all the job’s tabs other than the Informatica tab. For information on manually
creating Informatica WorkFlow jobs, see Manually Creating Informatica WorkFlow Jobs.
6. In the New Job Name field, optionally add a prefix and/or suffix before and/or after the
{WORKFLOW} replacement value.
Add a prefix and/or suffix will give the Informatica WorkFlow jobs you create a unique name.
You may want to do this out of preference, or necessity if you are creating two or more
Automation Engine jobs for the same Informatica WorkFlow.
To automatically create Automation Engine WorkFlow jobs from the Create Jobs sub-tab for
WorkFlows with existing Automation Engine WorkFlow job definitions, you must do the
following before creating jobs:
Uncheck the Exclude Existing Jobs checkbox.
Include a prefix and/or suffix that has not been used in an existing job definitions.
7. Optionally uncheck the Exclude Existing Jobs box. The selection will affect whether
WorkFlows with Automation Engine Jobs created for them will be included on the WorkFlow
Names window when you create Informatica WorkFlow Jobs from the Create Jobs sub-tab
later.
l When this box is checked (default): WorkFlows that already have Automation
Engine Jobs created for them will be excluded from the list on the WorkFlow Names
window.
l When this box is unchecked: WorkFlows that already have Automation Engine
Jobs created for them will be included in the list on the WorkFlow Names window.
8. Optionally check the Skip Population of Parameters box.
l When this box is checked: The parameter file or Job parameters will not be
transferred from Informatica to the Automation Engine Job definitions. You can
retrieve the parameter file or the Job parameters later from the Automation Engine Job
definitions individually.
l When this box is unchecked (default): The parameter file or Job parameters will be
transferred from Informatica to the Automation Engine Job definitions.
9. Click Create Jobs to create the Job object(s).
In Automation Engine and Operations Manager, the Jobs will be created in the <No Folder>.
l
l
Informatica Agent Guide v3.2.0 17
2.7 Manually Creating Informatica WorkFlow
Jobs
Manually define jobs that run Informatica WorkFlows by creating WORKFLOWJOB job types and
using the Informatica tab in a job definition.
To manually create an Informatica WorkFlow job:
1. Add a new job by picking Informatica as your job type and selecting WORKFLOWJOB.
2. From the job definition, select your Informatica agent.
3. Go to the Informatica tab and enter the following information. On Informatica WorkFlow
jobs, the Informatica tab includes the panel shown in Figure A.
The Informatica tab for a sample WORKFLOWJOB.
Respond to the fields described below:
Field
Description
Connection The connection object you created. Make sure you select a connection
to
object that can connect to the agent you selected for the job.
Repository
Folder
Name
The Informatica folder that contains the WorkFlow. This field is inactive until
you select a connection to repository.
18
Chapter 2 Working with the Informatica Agent Integration
Field
Description
WorkFlow
Name
The WorkFlow you wish to run. This field is inactive until you select a folder
name.
Start from
Task
An optional Task, Session, or Worklet to start running from. Tasks to start
from may include reusable or non-reusable Worklets. For examples, see the
Starting from a Task, Session, or Worklet in a Non-Reusable Worklet below.
Parameter
File Name
An optional Informatica parameter file.
Run
Instance
Name
An optional field to specify a string to pass to the Informatica Power Center
Monitor. If the replacement value {JOB_RUNID} is used, the run ID will be
used as part of the string, as shown in Figure A. When this field is empty, the
Automation Engine Run ID will be used.
Abort on
Kill
When checked, the job will abort when a kill command is issued from the
Automation Engine. When unchecked (default), the job is stopped.
Agent
Default
This non-editable field shows the current value set for the Session Log File
Transfer Option setting specified on the General tab of the Informatica
agent. You can override this setting using the Override check box and its
radio buttons below.
Override
Allows you to override the Session Log File Transfer Option setting specified
on the General tab of the Informatica agent for this job. This option decides
whether the Informatica agent should transfer Session logs for WorkFlow
jobs. Whether or not you transfer Session log files affects how long it takes
for the jobs to complete in the Automation Engine.
l
When this box is checked: You can override the agent’s Session
Log File Transfer Option setting by selecting one of the following
options:
l Always: Transfers log files for all Sessions in this WorkFlow.
l For Failed Sessions or WorkFlows: Transfers log files for
failed Sessions in this WorkFlow and/or all Sessions when the
WorkFlow fails.
l Only for Failed Sessions: Transfers log files for failed
Sessions in this WorkFlow.
l Never: Does not transfer log files for Sessions in this
WorkFlow.
l
When this box is unchecked (default): The value set for the
agent’s Session Log File Transfer Option setting is used.
For more information, see topic Creating an Informatica Agent.
WorkFlow log files are always transferred.
4. Add/edit job parameters.
To:
Do this:
Use a parameter
file.
Enter the parameter file name in the Parameter File Name field
above. When a parameter file is used, the parameters in the Job
Parameters table are ignored.
Informatica Agent Guide v3.2.0 19
To:
Do this:
Get and set
values for
parameters
already defined in
Informatica.
Leave the Parameter File Name blank and click Get Parameters,
The Informatica agent adds the parameters defined in Informatica to
the Job Parameters table. You can edit the parameter values by
editing the Value column.
Add a custom
parameter to the
Job Parameters
table.
Click Add, the Informatica agent adds a row where you can specify
the name and value.
Default values will be used for parameters that are already defined
in Informatica, but they will not be displayed in the Value column.
Edit a custom
Edit the Value column.
parameter from
the Job
Parameters table.
Delete a custom
Select a row and click Delete.
parameter from
the Job
Parameters table.
Starting from a Task, Session, or Worklet in a Non-Reusable
Worklet
To start from a Task, Session, or Worklet in a non-reusable Worklet:
1. Click the Select button for the Start from Task field.
2. In the task selection pop-up window shown to the right in Figure B, select the Task,
Session, or Worklet you wish to start from the Start task drop-down list.
A Session in a Worklet highlighted in the Informatica PowerCenter and selected in the task selection
window.
For non-reusable Worklets, the Start task drop-down list includes all:
l Of the Worklet’s Tasks, Sessions, reusable Worklets, and non-reusable Worklets.
l Tasks, Sessions, and Worklets belonging to non-reusable Worklets.
When Tasks, Sessions, and Worklets are included in non-reusable Worklets, they will be
listed in the Start task drop-down list with their Worklet name followed by a period, and their
name. When non-reusable Worklets include nested non-reusable Worklets, each nonreusable Worklet is listed separated by a period, For example, in Figure B:
20
Chapter 2 Working with the Informatica Agent Integration
The non-reusable Worklet NWL21 includes the non-reusable Worklet NWL22.
l The non-reusable Worklet NWL22 includes the Session se_NWL3.
For example, to start from the Session se_NWL3 from the non-reusable Worklet NWL22,
which is included in the non-reusable Worklet NWL21, you would select
NWL21.NWL22.seNWL3 from the Start task field.
l
Informatica Agent Guide v3.2.0 21
2.8 Manually Creating Informatica Session,
Task, or Worklet Jobs
Define jobs that run Informatica Tasks, Sessions, or Worklets by creating SESSIONORTASKJOB
job types and using the Informatica tab in a job definition.
To create an Informatica Task, Session, or Worklet job:
1. Add a new job by picking Informatica as your job type and selecting
SESSIONORTASKJOB.
2. From the job definition, select your Informatica agent.
3. Go to the Informatica tab and enter the following information. On Informatica
SESSIONORTASKJOB jobs, the Informatica tab includes the panel shown in Figure A.
The Informatica tab for a sample SESSIONORTASKJOB.
Respond to the fields described below:
Field
Description
Connection The connection object you created. Make sure you select a connection
to
object that can connect to the agent you selected for the job.
Repository
Folder
Name
The Informatica folder that contains the WorkFlow. This field is inactive until
you select a connection to repository.
WorkFlow
Name
The WorkFlow assigned to the Task, Session, or Worklet. This field is
inactive until you select a folder name.
22
Chapter 2 Working with the Informatica Agent Integration
Field
Description
Task or
Session
Name
The Task, Session, or Worklet you wish to run. This field allows you to
select Tasks, Sessions, and Worklets from inside non-reusable Worklets.
For examples, see the Running a Task, Session, or Worklet in a Nonreusable Worklet below.
Parameter
File Name
An optional Informatica parameter file.
Run
Instance
Name
An optional field to specify a string to pass to the Informatica Power Center
Monitor. If the replacement value {JOB_RUNID} is used, the run ID will be
used as part of the string. When this field is empty, the Automation Engine
Run ID will be used.
Abort on
kill
When checked, the job will abort when a kill command is issued from the
Automation Engine. When unchecked (default), the job is stopped.
4. Add/edit job parameters.
To:
Do this:
Use a parameter
file.
Enter the parameter file name in the Parameter File Name field
above. When a parameter file is used, the parameters in the Job
Parameters table are ignored.
Get and set
values for
parameters
already defined in
Informatica.
Leave the Parameter File Name blank and click Get Parameters,
the Informatica agent adds the parameters defined in Informatica to
the Job Parameters table. You can edit the parameter values by
editing the Value column.
Add a custom
parameter to the
Job Parameters
table.
Click Add, the Informatica agent adds a row where you can specify
the name and value.
Default values will be used for parameters that are already defined
in Informatica, but they will not be displayed in the Value column.
Edit a custom
Edit the Value column.
parameter from
the Job
Parameters table.
Delete a custom
Select a row and click Delete.
parameter from
the Job
Parameters table.
Running a Task, Session, or Worklet in a Non-reusable Worklet
To run a Task, Session, or Worklet in a non-reusable Worklet:
1. Click the Select button for the Task or Session Name field.
2. In the Task selection pop-up window shown to the right in Figure B, select the Task,
Session, or Worklet you wish to run from the Tasks drop-down list.
Informatica Agent Guide v3.2.0 23
A Session in a Worklet highlighted in the Informatica PowerCenter and selected in the Task
selection window.
For a non-reusable Worklets, the Tasks drop-down list includes all:
l Of the Worklet’s Tasks, Sessions, reusable Worklets, and non-reusable Worklets.
l Tasks, Sessions, and Worklets belonging to non-reusable Worklets.
When Tasks, Sessions, and Worklets are included in non-reusable Worklets, they will be
listed in the Tasks drop-down list with their Worklet name followed by a period, and their
name. When non-reusable Worklets include nested non-reusable Worklets, each nonreusable Worklet is listed separated by a period, For example, in Figure B:
l The non-reusable Worklet NWL21 includes the non-reusable Worklet NWL22.
l The non-reusable Worklet NWL22 includes the Session se_NWL3.
For example, to run the Session se_NWL3 from the non-reusable Worklet NWL22, which is
included in the non-reusable Worklet NWL21, you would select NWL21.NWL22.seNWL3
from the Start task field.
Killing Failed Session or Task Jobs
If a SESSIONORTASKJOB job type task fails in Informatica, and you issue a Cancel command on
it from Automation Engine v9 or Operations Manager or a Kill command on it from Applications
Manager; the Informatica agent will kill the Session or Task’s parent WorkFlow. This is done,
because these WorkFlows only have one Session or Task in them. This way, the WorkFlow status
will match the status of its only child.
24
Chapter 2 Working with the Informatica Agent Integration
2.9 Adding Informatica Specific Status
Columns to the Applications Manager
Backlog
Add the SO_REF1 and SO_APPLICATION_STATUS columns to the Applications Manager
Backlog and History to show the Informatica Run ID and WorkFlow status.
There are two Informatica columns you can add to the Applications Manager Backlog and History:
l
l
SO_REF1: Shows the Informatica Run ID number.
SO_APPLICATION_STATUS: Shows the Informatica WorkFlow status.
To add these columns to the Backlog:
1. In Applications Manager desktop, open the Options menu and select Tables.
2. Select Backlog.
Applications Manager displays the Setup: Backlog window shown in Figure A.
Displaying the Informatica columns in the Backlog
3. Locate the SO_REF1 and SO_APPLICATION_STATUS entries in the DB_NAME column in
the lower pane and click the boxes in the VISIBLE column.
4. Optionally rename the columns to Run ID and WorkFlow Status.
5. To save the changes, click OK.
6. Optionally repeat for History.
Informatica Agent Guide v3.2.0 25
2.10 Requesting Jobs That Cannot Run
Concurrently in Informatica
If you request a job that does not allow concurrent runs in Informatica and another instance is
already running, the task will fail and the message below will be displayed in the task’s system
output file.
If you request a job that does not allow concurrent runs in Informatica and another instance is
already running, the task will fail and a message like the following will be displayed in the task’s
system output file:
java.lang.RuntimeException: workflow start error: pmcmd> ERROR:
Workflow [RepFolder1:wf_for_tail[version CheckedOut]]: Could not
acquire the execute lock for Workflow [wf_for_tail] []. Please check
the Integration Service log for more information.
pmcmd> ERROR: Unknown command [ENDENDENDENDENDENDEND!!].
26
Chapter 2 Working with the Informatica Agent Integration
2.11 Managing Output and Execution
Options with the RA Tab
You can specify how job reports are saved, whether they include agent log information, and whether
the information from the RA agent-specific tab is displayed when executing the job using the RA tab
in Operations Manager v8.00, Automation Engine v9 and v10.
You can specify how job reports are saved, whether they include agent log information, and whether
the information from the RA agent-specific tab is displayed when executing the job using the RA
tab. A sample RA tab for a job is shown below.
A sample RA tab for a job
Options on the RA tab for jobs are described in the table below.
Field
Description
Database
When checked, the job report is managed in the Automation Engine. After the
execution of a job, the process protocol is transferred to the Automation Engine
database via file transfer.
File
When checked, the job report is managed in the Automation Engine. After the
execution of a job, the process protocol is available in the target system as a file.
Generate
on error
only
When checked, the job report is stored in the Automation Engine database and/or a
file in the target system only if the job has been canceled. This function is only
available when Database and/or File are checked.
Agent log
When checked, job reports will include an agent log tab with an agent log when
there are errors. Keeping this box checked is recommended for troubleshooting
purposes.
Request
When checked, the information from the job’s RA agent-specific tab is available in
task
the pop-up window when you execute the job. From this window, you can make one
parameters time changes for a single run of the job. Some fields from RA agent-specific tabs
can only be set in job definitions. These fields are not included in the pop-up window
when the job is requested and the Request task parameters option is checked. A
pop-up window for a sample job is shown below.
This option is available in Automation Engine v9 Service Pack 4 and above.
Informatica Agent Guide v3.2.0 27
When Request task parameters is checked, you can edit the information from the job’s RA-specific tab for a
single run when executing the job.
28
Chapter 2 Working with the Informatica Agent Integration
2.12 Setting Trace
When you need to troubleshoot a Rapid Automation agent used with Automation Engine v10,
Automation Engine v9, or Operations Manager v8.00, you can turn on Rapid Automation trace for
AGENT and JOBS objects from either the System Overview window in the Automation Engine
UserInterface or the ucxjcitx.ini file. You can turn on Rapid Automation UserInterface trace from the
uc4config.xml file.
Turning Rapid Automation Trace On or Off From the System
Overview Window
To turn on trace for Rapid Automation AGENT and JOBS objects in the UserInterface, go to
System Overview window, right-click the agent, pick Properties. In the window that pops up, set
RA to 9 to turn trace on or set RA to 0 to turn trace off.
Turning Rapid Automation Trace On or Off From the ucxjcitx.ini
File
To turn on trace for Rapid Automation AGENT and JOBS objects with the ucxjcitx.ini file:
1. Stop the agent(s) from the ServiceManager window or command line.
2. Edit the ucxjcitx.ini file.
To turn trace: Set: On
ra=9
Off
ra=0
3. In the code below, ra=9 turns Rapid Automation trace on:
[TRACE]
file=..\temp\RA_TRACE_##.TXT
max_trace_kb=8000
tcp/ip=0
ra=9
trccount=10
4. Restart the agent(s).
Turning On Rapid Automation UserInterface Trace
To turn on Rapid Automation UserInterface trace:
1. Exit out of the Automation Engine UserInterface.
2. From the uc4config.xml file, add ra="9" to the trace line as shown below:
<trace ra="9" count="10" xml="0" tcp="0">..\temp\UCDJ_TRC_
##.TXT</trace>
3. Open the UserInterface.
Turning Off Rapid Automation UserInterface Trace
To turn off Rapid Automation UserInterface trace:
Informatica Agent Guide v3.2.0 29
1. Exit out of the Automation Engine UserInterface.
2. From the uc4config.xml file, add ra="0" to the trace line as shown below:
<trace ra="0" count="10" xml="0" tcp="0">..\temp\UCDJ_TRC_
##.TXT</trace>
3. Open the UserInterface.
For more information on setting trace, see your Automation Engine documentation.
30
Chapter 2 Working with the Informatica Agent Integration
2.13 Setting Debug in Applications Manager
v8.0
When you need to troubleshoot, there are various debug setting available.
There are different types of Rapid Automation debug that can be set in Applications Manager.
For more information on setting debug, see your Applications Manager documentation.
To set debug
for:
Do the following:
An agent
Check the Agent Debug box on the General tab in the agent definition.
Job submit and
run for a single
task
Select an option from the Debug Level field on the Submit window.
Job submit and
run for all tasks
Add radebuglevel=9 to the agent’s awenv.ini file. To turn this debug off, set
radebuglevel=0. Debug information will be written to the task’s system output
log file.