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
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:
Link to download:
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
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_220.127.116.11.0_odi.jar
It should look like this:
C:\Java1\jdk1.8.0_112\bin\java -jar fmw_18.104.22.168.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:
And re-run the command: java -jar fmw_22.214.171.124.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 “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:
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!