It defines how to run task like command task, session task, e-mail task, etc. To track everything is streamlined and executed in the desired order, we need a Workflow Monitor. Workflow monitor is a tool with the help of which you can monitor the execution of workflows and task assigned to the workflow. Step 1 — In Informatica Designer or Workflow manager toolbox, click on the workflow monitor icon.
In the workflow monitor tool, you will see the repositories and associated integration services on the left side. Under the status column, you will see whether you are connected or disconnected to integration service. There is a time bar which helps us to determine how long it took a task to execute. Step 3 — The workflow monitor is in a disconnected mode by default. To connect to integration service. Task view displays the workflow runs in report format, and it is organized by workflow runs.
It provides a convenient approach to compare workflow runs and filter details of workflow runs. Configure a Microsoft Outlook User Step 2.
Configure Logon Network Security Step 3. Create Distribution Lists Step 4. Back Next. Relational Database Connections. Use a relational connection object for each source, target, lookup, and stored procedure database that you want to access. The following table describes the properties that you configure for a relational database connection:. Name you want to use for this connection.
The connection name cannot contain spaces or other special characters, except for the underscore. Use Kerberos Authentication. Indicates that the database to connect to runs on a network that uses Kerberos authentication. If this option is selected, you cannot set the user name and password in the connection object. The connection uses the credentials of the user account that runs the session that connects to the database. The user account must have a user principal on the Kerberos network where the database runs.
User Name. Database user name with the appropriate read and write database permissions to access the database. Not available if the Use Kerberos Authentication. Use Parameter in Password. Password for the database user name. Connect String. Connect string used to communicate with the database. For syntax, see Native Connect Strings. You can select the following provider types: ODBC.
If you do not select the Use DSN option, you must provide the database and server names. PowerCenter Rename Saved Search. Overwrite saved search. Save Cancel. Confirm Deletion. OK Cancel. Table of Contents Search. No Results.
Getting Started Getting Started Back Next. Configuring Database Connections in the Workflow Manager. Before you can create a session, you need to provide the Integration Service with the information it needs to connect to the source and target databases.
Configure database connections in the Workflow Manager. Database connections are saved in the repository.
0コメント