ODI 12c Installation and ODI 12c Repository upgrade from 11g

ODI 12c Installation and ODI 12c Repository upgrade

ODI 12c version is releases and it has come with lot of exciting features. You can find the new features that has been shipped with 12c version in the link ODI 12c new features of oracle documentation.

1. Multiple Target support - Now mappings can load multiple targets as part of the new flow.

2. Re-usable mappings - We can create mapping once and can be re-used across objects which is very good for huge mapping which involves xml, table, complex files.

3. Step by Step debugger - mapping, package, procedure and scenarios can be debugged step by step.

4. Standalone Agent with Weblogic - Standalone agents can be managed through weblogic management framework

5. XML Improvements - lis, union, substition group, mixed context and annotation are supported in 12c version for XML technology.

Oracle's go-forward strategy is to have data warehousing/data integration to be done through Oracle data integrator and phase-out Oracle Warehouse builder to ODI by providing migration tools. Based on this strategy lot of integration from OWB and ODI features introduced as well as OWB migration to ODI is also made easy.

In this post, I would like to show my experience on 12c ODI installation and upgrade of the repository from 11g to 12c. 

Download the 12c ODI generic version from oracle downloads. I have downloaded 12.1.2 generic version which is the current version when this post is written.

ofm_odi_generic_12.1.2.0.0_disk1_1of1.zip

Extract this zip file. we can see the main jar for installation and patches zip file to apply the patches. Extract the patch zip file. ODI 12c installation has 2 steps.

1. Install ODI 12c jar

2. Apply the patches

Installing ODI 12c

Run the jar file in command prompt for installation. we need to run this jar with admin rights in windows (run as administrator option). Also ODI 12c is certified above 1.7.0_15 or above. Be sure to use latest JDK 1.7.

In windows, to run the command with admin rights, type cmd in run and use cntrl-shift-enter to launch it. select yes in the confirmation for running the commands with admin privilege in the cmd window.

 type the command java -jar odi_121200.jar (make sure java executable is from jdk 7 latest version)

Provide oracle home for the installation

Select enterprise installation option. Complete the wizard to complete the installation.

Apply ODI 12c patches

Read the readme file present in the patch directory for pre-requisites which may be different for your configuration before running opatch.

Verify the OUI inventory before running opatch. It needs to run without errors before applying the patches. Run the command "opatch lsinventory" to check this.

Go to the unzipped directory of odi patches and run the command "opatch napply odi_1212_opatch" to apply the patches. Ignore the error "There is an error with library regeneration" which is coming in the command prompt. Patch readme file says it is as expected and we can ignore it.

Lets check the OUI inventory again to check the applied patches.

Upgrading ODI repository from 11g to 12c

Before upgrading the repository, please make sure of the following so that you dont lose your repository if there are any errrors during upgrade.

1. All affected data is backed up (middleware home, oracle home, master and work repository schemas and data)

2. Datbase version is certified to work with ODI 12c

3. Certification and system requirements are met.

To run the upgrade, Go to <Oracle_Home>/oracle_common/upgrade/bin directory and run the ua command.

Select schemas to upgrade repository.

Select ODI for schema for repository upgrade.

Check the prerequiresites and check them to agree that you have completed them.

Provide sysdba user and master repository schema details.

Select all options for upgrading.

Provide supervisor user details

Please note down the upgrade key detail for future reference and work with support for any issues.

Complete the wizard to complete the upgrade. It will take some time to do the upgrade and confirm the upgrade is successful.

Lets connect to the repository using the new 12c ODI client.

ODI client  odi.exe  or odi64.exe can be found in <Oracle_Home>/odi/studio. Lauch the exe for odi studio client.

Oracle has made the look and feel same for Jdeveloper 12c and ODI 12c client. It is evident that OFM is standardized across tools and infrastructure in 12c.

If asked for import earlier version configs, select yes to carry them to 12c client. You will asked to create wallet for storing passwords. Provide a password of your choice for wallet password. It will be prompted for this wallet password while connecting to repository.

Lets connect to our upgraded repository. Select connect to repository and provide wallet password.

It automatically shows all existing repository connections for you to select and provide password. select the work repository and provide password.

Here is how upgraded repository objects looks. we can see that 11g interfaces are renamed to mapping in 12c (not suprisingly, interface is confusing and mapping term looks straightforward).

we can also see that UI and layout has been revamped in the 12c version. 

I will talk about 12c ODI new features with hands on in my next  posts.

Thank You and share your comments if any.