ODI 12C Installation Step by Step Oracle Data Integrator 12c is finally available. Now the hard part begins - learning how to use it. In this tutorial, my goal is to install ODI Studio 12c on my laptop and configure the repositories in an Oracle Database. ODI 12c consists of several components - ODI Studio, WebLogic (Agent, Console. Aug 23, 2010 Hi ODI 11g experts. Hi ODI 11g experts I need to add a JDBC driver to my installation (I host my repositories on DB2 UDB). Could someone tell me where to add new JDBC driver.jar files (under ODI 10 it was under oracledi/drivers/., does not seem to be the case any more). Oracle Data Integrator 12c: Getting Started - Installation and Configuration 08 November 2016 on odi12c, Oracle Data Integrator, data integration, ODI12c Getting Started I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. ODI 12c Standalone Agent: Place the driver or jar file in: odi agent lib Do not forget to stop and restart the Agent from either •the command.
Learn about standalone, Java EE, and colocated agents, which are located on the server and listen to a port for incoming requests.
Join the DZone community and get the full member experience.
Join For FreeWhat Is an Agent?
An agent is a Java process that's usually located on the server and listens to a port for incoming requests. It runs the requested scenario, reverse-engineers requested datastores, etc.
When a job submitted through ODI Studio GUI or through the startscen.sh agent gets scenario from the work repository and topology definitions from master repository, it combines and converts them into a runnable job, usually consisting of more than one code block. Then, it sends code blocks to destination environments, which may be DB servers, file servers, Hadoop name nodes, etc. Finally, the agent gets job statuses from these environments and writes into work repository tables for us to see from the Operator tab of ODI Studio.
Agent diagram from Oracle A-Team blog
Agent Types
Standalone Agent
It is the basic agent of ODI. It does not require an application server like JEE Agent. It is easy to configure, start, and stop this agent from the shell. I’ve always used this agent and never tried other versions. This is the most lightweight and low footprint choice.
JEE Agent
When it comes to the Java Enterprise Edition agent, which requires an application server, in most documentation, you can see the name of the WebLogic Server since it’s another Oracle product.
Depending on this CertMatrix of Oracle, ODI 11.1.1.7.0 only supports WLS and does not support Tomcat or other application servers. You may — or may not — configure them to run together, but this is not supported.
This agent is first delivered with ODI 11g and it still exists in ODI 12c.
Some pros of JEE agent are:
- High availability: Through Web Logic Server’s cluster architecture, even if a node is down, agents may run on other nodes.
- Configurable connection pooling: Connection pool can be configured through WLS.
- Monitoring: Oracle Enterprise Manager can monitor, configure, alert, and manage ODI JEE agents. But there is a plug-in to be installed to achieve this tasks from OEM.
Drivers Location In Odi 12c Tutorial For Beginners
Colocated Agent
This is the newest agent type that arrived with ODI 12c. It's like a combo of other two types. The agent is a standalone agent, but it can be monitored and configured through WLS. Unfortunately, it does not take advantage of connection pooling or high availability. Our agent will be in the WLS domain and can be managed through WLS — and that’s all. It is lighter than the JEE agent. Companies that prefer JEE Agent as production agents should choose the colocated agent as their dev/test agent.
Agent types diagram from Gerard Nico’s website
Where to Locate an Agent
To decrease network I/O, it is better to locate the agent for the target DB server. Since the agent submits code to DB Engine, it is better for them to be on the same machine. Don’t forget that ODI is an ELT tool, which means it will load data into target server and then transform your data. So, most of the load will be on the target server, which also means that most of the code will be submitted to the target server.
Also, since an agent is a local Java process, the agent will write files to the machine upon which it is set up. If you have a file server other than the DB server, it's better to have another agent on the file server to handle read/write file processes. Mounting the file server directory to the DB server as a directory and setting up only one agent is another solution.
Also, these solutions will prevent any firewall-related problems.
Thanks for reading — don’t forget to share and comment!
Like This Article? Read More From DZone
Drivers Location In Odi 12c Tutorial 2017
Published at DZone with permission of Canburak Tumer . See the original article here.
Opinions expressed by DZone contributors are their own.