How to Install ODI 12c Step by step

In this post, we go through the steps to install and configure ODI 12c, but before that, I would like to point out some of the changes from the 11g version to 12c version(which came out around 2014 but there are still customers upgrading to that version).

What we have seen in this version is that Oracle has put a lot of effort to improve a tool that was already great but needed to keep up with the ongoing changes in the market and support the clients to better integrate several internal and external data sources, as well as supporting big data with the structured and unstructured data by implementing new knowledge Modules for Hbase (Hadoop,Hive, pig etc.…) and also to better integrate Jason files, XML files when consuming and deploying web services .

This new version was launched in 2014 and has had some big (good) changes from 11g to 12 C, below you can see some of many changes:

  • New built-in connection capabilities to Hadoop
  • Now ODI developers have mappings instead of Interfaces(11g names)
  • Now it is possible to have multiple target data stores(tables)
  • Web services enhancements
  • New components such as joiner, splitter, aggregate etc… just like in OWB, so migration from OWB to ODI 12C is made easier
  • XML files integration enhancement
  • New Big data Knowledge Modules:

-LKM SQL to Hive SQOOP

-LKM SQL to File SQOOP Direct

-LKM SQL to HBase SQOOP Direct

-LKM HBase to SQL SQOOP

-LKM File to SQL SQOOP

-LKM Hive to SQL SQOOP

Reference: http://www.oracle.com/us/products/middleware/data-integration/odi-12c-new-features-wp-2226353.pdf

To install, download the files, if you don’t have an account it is really straight forward to create one, these steps are in windows server but it also applies to Linux.

1- Make sure you have the correct version of JDK installed at least 1.8 version, otherwise you get the below error:Java error

Link to download:

http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Run the installer:

Follow the next steps in order to install the JDK and remember to remove the spaces in the path:

2-Download the ODI installer

Link: http://www.oracle.com/technetwork/middleware/data-integrator/downloads/ 

Open the command prompt and navigate to the directory where your JDK is installed and from there you invoke the “Jar” file, example below:

  • cd C:\Program Files\Java\jdk1.8.0_112\bin\;
  • java-jar fmw_12.2.1.2.0_odi.jar

It should look like this:

C:\Java1\jdk1.8.0_112\bin\java  -jar fmw_12.2.1.2.0_odi.jar

If you get the error “Unable to access JarFile” as in the below figure:

Copy the ODI jar file into the following directory:

C:\Program Files\Java\jdk1.8.0_112\bin\

And re-run the command: java  -jar fmw_12.2.1.2.0_odi.jar:

It will open the installer wizard, click “next:

  • If you are not installing in a corporate environment skip the updates and click “next”:

  • In this step set the Oracle home, here we can change the path and click next:

  • In this step we need to choose the type of installation since we will install a standalone Agent, I set that option marked below.

In ODI 12c there is a significant change in the options of the types of agents and topology, the JavaEE and collocated agents are now a “managed server” in a WebLogic domain, the benefit of the JavaEE is that you can enable ODI to communicate with other Java-based applications such as OBIEE and the SOA framework, this will be explained in detail in another post, for now we go ahead and click “next”:

  • Prerequisite checks run, click “Next”:

Click “next”:

Click “yes” on the pop-up warning:

  • You can save the response file and log file of the installation process, in the image below you can also see some new features such as the Big data driver for Hive connection and SOA libraries. Click Install :

  • Installation in progress, when it is finished click next:

Install was completed:

Double click on ODI studio and point it to the JDK path:

JDK

 

That is it! The ODI 12c installation is completed, there are other configuration steps that we will need to perform to have a complete implementation of ODI 12c, the master and work repositories need to be created so that the data integration development work can be done.

See you soon!

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s