ODI Snippets: Installing multiple ODI agents on one server

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes

Sometimes it may come in handy to have multiple agents running on the same server, e.g. if you want to use a particular agent to execute scenarios for a particular project.

I had a requirement recently where users were dropping Excel files into shared folders on a server. We had one folder for Dev, one for UAT, and one for PRD. ODI would then pick up these files and load them into the corresponding environment. As we just had the one file server for all three environments we had to install multiple agents on this server.

To set up mutliple agents on one server take the following steps:

Create new folder in oracledi dir, e.g. prd_bin

Copy files agent.bat, agentscheduler.bat, agentservice.bat, agentstop.bat, agentweb.bat, odiparams.bat, startscen,bat from bin folder to new folder

Update odiparams.bat with information for work repository you want to connect to.

Create physical agent in Topology Manager

Create context and assign new physical agent to context in Topology Manager

Finally create new Windows service for agent, e.g.
oraclediagent_prd>agentservice -i -s Sched_Agent_PRD 20908

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.