Oracle data integrator agents
1 / 15

Oracle Data Integrator Agents - PowerPoint PPT Presentation

  • Uploaded on

Oracle Data Integrator Agents. 10. Understanding Agents. Local (No Agent) vs. Agent. The GUI acts as a local agent Pros: No need to start an agent All in one component Cons Not taking advantage of the distributed architecture When you stop the GUI, you loose the Agent.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Oracle Data Integrator Agents' - lavonn

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Local no agent vs agent
Local (No Agent) vs. Agent

  • The GUI acts as a local agent

    • Pros:

      • No need to start an agent

      • All in one component

    • Cons

      • Not taking advantage of the distributed architecture

      • When you stop the GUI, you loose the Agent


Purpose of the agent
Purpose of the Agent

  • The agent is the component that orchestrates the processes.

  • The Agent is the component that will

    • Finish the code generation (based on the context selected for the execution of the scenarios)

    • Establish the connection with the different databases

    • Send the generated code to the different databases

    • Retrieve the return code from the databases or operating system

    • Update the repository with the return codes and processing statistics


Different types of agents
Different Types of Agents

  • You can start the agent in different “modes” that will have different behaviors

    • Listener Only: this agent is started with the bin\agent.bat script (or on Unix)

    • Listener and Scheduler: this agent is started with the bin\agentscheduler.bat (or on Unix).

      • Note: Scheduler agents will have to connect to the repository to retrieve the schedule. Check out later in this presentation how to update the snpparams.bat (or .sh) file to establish this connection


Agent location
Agent Location

  • The agent has to be in a central location so that it can access

    • All databases (source and target)

    • All database utilities (to load/unload for large volumes of data)

    • The ODI Repository (Master and Work Repository)

  • Typical location is on the target server

  • It is possible to install several agents:

    • either on the same machine (different ports)

    • or on different machines


Agent installation
Agent Installation

  • Agents can be installed with the graphical setup

  • Agents can be installed manually: simply copy over the \bin, \drivers and \lib directories

  • Once installed, an agent can be set as a service on a Windows machine, run the script agentservice.bat.

    • Installation as a listener only:

      • Agentservice –i –a AgentName AgentPort

    • Installation as a listener and scheduler:

      • Agentservice –i –s AgentName AgentPort

    • AgentName is only mandatory for scheduler agents or agents used for load balancing

    • AgentPort is only mandatory if the port is different from the default (20910)


Agent configuration
Agent Configuration

  • For scheduler agents only, you will have to update the file odiparams.bat (or .sh) in the bin directory

    • Update the parameters to connect to the Master repository

    • Encrypt passwords with the following command (from a DOS or Unix prompt:

      • Agent encode MyPassword

        (Replace MyPassword with your password)

  • Define the agents in Topology (see following section)


Sample odiparams file
Sample ODIPARAMS file

  • JDBC driver to access the Master Repository:

    • set ODI_SECU_DRIVER=oracle.jdbc.driver.OracleDriver

  • JDBC URL to access the Master Repository:

    • set ODI_SECU_URL=jdbc:oracle:thin:@

  • Database Username to access the Master Repository:

    • set ODI_SECU_USER=odi1013m

  • Database Password to access the Master Repository:

    • set ODI_SECU_ENCODED_PASS=b9yHYSNunqZvoreC6aoF0Vhef

  • Name of the Work Repository:


  • ODI Username for ODI Security:


  • ODI Password for ODI Security:



Creating a physical agent
Creating a Physical Agent

  • Right-click Agents in the Physical Architecture view

  • Select Insert Agent

  • Fill in the agent’s parameters:

    • Agent Name (MACHINE_PORT)

    • Host Name or IP address

    • Agent Port

  • Click the Test button if the agent is already running

  • Optional load balancing:

    • Set the Maximum number of sessions.

    • Define the linked agents on the Load Balancing tab.


Important note
Important Note

Always test the connection to check that the agent is correctly configured.


Important note1
Important Note

One physical agent per agent started.


Creating a logical agent
Creating a Logical Agent

  • Go to the Logical Architecture view

  • Right-click the Agents node.

  • Click Insert Logical Agent

  • Fill in the agent Name

  • Click OK.

  • You can associate this logical agent with physical agents here.