<img height="1" width="1" style="display:none;" alt="" src="https://px.ads.linkedin.com/collect/?pid=8366258&amp;fmt=gif">
Skip to content

The Oracle Data Integrator 12C Standalone Collocated Agent

Think

by Raviteja Santosh

The Standalone Collocated Agent comes as additional feature with Oracle Data Integrator (ODI)  12C, which is the blend of both standalone and Java Platform Enterprise Edition (Java EE) agents in ODI 12C.  This can be configured only with an ODI 12C Enterprise Edition Installation.

Oracle Data Integrator 12C standalone collocated agents are now managed through the Web Logic Management Framework. The agent is started as its own binary. Alternately we can start the agent using Weblogic Server.


Features of the Standalone Collocated Agent in ODI 12C:

• UI-driven configuration through Configuration Wizard
• Multiple configurations can be maintained in separate domains
• Node Manager can be used to control and automatically restart agents

Configurations required for this agent are user interface driven by invoking config.bat,  There is no need to define the configurations in odiparams.bat file manually, which is required in ODI 11g.

ODI 12C Standalone Collocated Agent vs ODI 11g Agents.

Features

ODI 12C  Standalone Collocated Agent

ODI 11g Standalone Agent

ODI 11g Java EE agent

Manual agent configuration for odiparams.bat

Not required. It is UI driven configuration through configuration wizard.

Manual intervention is required to configure odiparams.bat file

Not required. It is UI driven configuration through configuration wizard.

Managing through command prompt

Yes. We can start this agent using command prompt using agent.bat

Yes. We can start this agent using command prompt using agent.bat

No.

Managing(Agent startup/shutdown) through web services

Yes. We can manage through restricted Application servers (eg: web logic server).

 

No. we cannot manage through Web services. It will be always through Command prompt using agent.bat

Yes.

Invoking Web services

Yes.

No.                    

Yes.

UI driven

Yes.

No. Managed only through ODI Studio.

Yes.

The Standalone Collocated Agent can be started by either a command prompt or through invoking the ODI server configured through the Weblogic Server (dedicated Weblogic 12C application),

a. Starting collocated agent through command prompt:
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin>agent -NAME=<Agent_Name> -PORT=20910

b. Steps required to Start Standalone Collocated Agents via Weblogic Server:

1. Start the Node Manager.
2. Start the Administration Server.
3. Starting the Collocated standalone agent.


Other ODI 12C agents:

Standalone Agent :
• The ODI 12C Standalone Agent is similar to ODI 11g Standalone Agent.
• No Web logic Server is installed.
• Requires manual configuration of odiparams.bat file.
• Managed only through ODI Studio.
• Comes with only ODI 12C standalone installation mode.

JEE Agent: (Java Enterprise Edition Agent)
• Similar to ODI 11g Java EE agent
• The domain, admin server, managed servers, node managers, and so on is started in the normal Weblogic Server startup. The agent is one of many possible JEE apps running in the domain.
• No manual configurations required. It is all user interface (UI) Driven.
• Managed only through Application servers.
• Comes with only ODI 12 C Enterprise Edition Installation mode.

 

Steps required setting up Standalone Collocated Agent:

Start the Fusion Middleware (FMW) Configuration Wizard to create domain set up for ODI Standalone Collocated Agent.

C:\<Middleware Home>\odi\common\bin
Click on config.bat

Fusion Middleware Configuration Wizard Create Domain screen for ODI 12c standalone collocated agent setup

Select “Oracle Data Integrator Standalone Collocated Agent” from the below given options.

All these options are available only for the Enterprise Edition of ODI 12C installation.

Fusion Middleware Configuration Wizard Configuration Type screen selecting Oracle Data Integrator Standalone Collocated Agent (ODI 12c)

For Standalone installation of ODI 12C, only “Oracle Data Integrator Standalone Agent” will be available, from the below screenshot.

Fusion Middleware Configuration Wizard Templates screen showing Oracle Data Integrator Standalone Agent template selection (ODI 12c)

Provide password for Weblogic User.

Fusion Middleware Configuration Wizard Administrator Account screen setting WebLogic username and password for ODI 12c domain

On the Domain Mode and JDK panel, go by the defaults.

Fusion Middleware Configuration Wizard Domain Mode and JDK selection for ODI 12c collocated agent domain

Change the Hostname and click on Get RCU configuration to test database connections (created using RCU).

Fusion Middleware Configuration Wizard database configuration using RCU data and testing connection for ODI 12c

Provide the Component schema details created during RCU for ODI 12C.

ODI 12c JDBC Component Schema screen listing ODI and OPSS schemas in Fusion Middleware Configuration Wizard

Go by the defaults on the JDBC  Component Schema.

Fusion Middleware Configuration Wizard JDBC Component Schema Test showing successful JDBC connection results for ODI 12c

On the advanced configuration tab, select System Components..

Fusion Middleware Configuration Wizard Advanced Configuration screen with System Components selected for ODI 12c

Go by the defaults on the System Component Panel.

System Components screen adding ODI agent component (OracleDIAgent1) in ODI 12c collocated agent domain

Provide SUPERVISOR Password and Server Listener Port on the ODI Server configuration Screen.

ODI Server Configuration screen setting listener port and SUPERVISOR credentials for ODI 12c collocated agent

Change the Node manager Port to 20910 (required for ODI agent startup )

Machines screen configuring Node Manager listen address and port in ODI 12c WebLogic domain setup

Assign System Components to Machines screen mapping OracleDIAgent1 to LocalODIMachine in ODI 12c domain

Configuration Summary screen reviewing domain settings before creating ODI 12c standalone collocated agent domain

Configuration Progress screen showing ODI 12c domain creation steps running to completion in Configuration Wizard

Configuration Success screen showing WebLogic domain base_domain created successfully for ODI 12c collocated agent

Standalone Collocated agent domain got created

Login into Weblogic  Console for starting up ODI Server.

Using http://<hostname>:PORT/console

WebLogic Server 12c Administration Console login page used to start and manage ODI 12c collocated agent

Under Environments—Servers – ODI Server will be configured and can be managed from this console.

 


Raviteja Santosh is a Senior Consultant at KPI Partners. Raviteja is a business intelligence and data integration expert who has specialized in complex utilization of data integration platforms.   Check out Raviteja's blog at KPIPartners.com.

Comments

Comments not added yet!

Your future starts today. Ready?

kpi-top-up-button