Category Archives for odi

How to access ODI Studio on Linux

Oracle Data Integrator (ODI) Studio is used by Developers and Administrators to access  ODI Repository (Master and Work Repository) To launch ODI Studio on Linux, launch it from ODI ORACLE_HOME/oracledi/client/odi.sh (This will open GUI so run this command with X server running or from VNC) To connect ODI Studio to Master Repository or Work Repository […]

Read More

#OFMW 11.1.1.6 (SOA, WebCenter, IdM, OBIEE, OHS, ADF, CEP…) is now available

Oracle Fusion Middleware (OFMW) 11.1.1.6 is now available to download from eDelivery for following products Oracle WebLogic Server 10.3.6 Oracle SOA Suite 11g R1 PS5 (11.1.1.6) Oracle Web Tier – OHS/WebCache 11g R1 PS5 (11.1.1.6) Oracle Identity Management 11g R1 PS5 (11.1.1.6) #OID/OVD/OIF Oracle WebCenter Portal 11g R1 PS5 (11.1.1.6) Oracle WebCenter Content 11g R1 […]

Read More

Installing ODI 11g (including Agents) in High Availability (Active-Active Cluster) : Overview

               Image from Oracle HA Guide This post covers Oracle Data Integrator (ODI) High Availability (HA) deployment, for overview of ODI 11g components check my previous post here ODI high availability uses WebLogic ( with Java EE Agent) which give you Load Sharing, Connection Pooling, and ability to re-start automatically using WebLogic Server.  For these […]

Read More

Oracle Data Integrator (ODI) 11g : Architecture & Installation Overview

. Oracle Data Integrator (ODI) is an E-LT (Extract – Load & Transform) based data transformation and integration tool. This post covers overview (and architecture) of ODI 11g, for ODI 10g (earlier Sunopsis) click here   ODI consists of following components 1. ODI Studio – is a design time components which consists of Designer, Operator, Topology […]

Read More

Oracle Fusion Middleware 11g R1 PS4 (11.1.1.5) is available now

On Friday 6 May 2011, Oracle announced availability of Oracle Fusion Middleware 11g R1 PS4 i.e. 11.1.1.5 via Oracle My Support (earlier Metalink) note “1316076.1 Announcing Oracle Fusion Middleware 11g Release 1” . Here are some key points from this announcement 1. Oracle Fusion Middleware 11g R1 PS4 (11.1.1.5) is base release for use in Oracle […]

Read More

Upgrade Oracle Data Integrator 10.1.3.5 to 10.1.3.6 (9377717)

If you are new to ODI (Oracle Data Integrator) then first look at ODI Architecture and Installation here 1. Oracle Data Integrator (ODI) 10.1.3.6 is now available as patch 9377717 2.ODI 10.1.3.6 (9377717) is patchset and NOT complete software . You can apply it on top of existing 10.1.3.5.X 3. To check current version of […]

Read More

ODI – Oracle Data Quality (Trillium) configuration issues on Solaris 10 : Error creating Loader Connection pkgOracleAdapter.so ld.so.1 libclntsh.so.10.1

Oracle Data Quality and Profiling is product from Trillium and Oracle ship it as part of Oracle Data Integrator (ODI) software. More on ODI here and here  ODI – Oracle Data Integrator ODP – Oracle Data Profiling ODQ – Oracle Data Quality Entity creation failed while creating Loader Connection to Data source (Oracle Database) – For more […]

Read More

ODI – Data Quality : Metabase Manager

This post covers overview of Oracle Data Quality Products (in ODI) and connect to Data Quality Repository using Metabase Manager (windows tool) ODI – Oracle Data Integrator ODP – Oracle Data Profiling ODQ – Oracle Data Quality Oracle Data Integrator Suite (more info here and here) consists of Oracle Data Integrator and Oracle Data Quality Products. “Oracle Data […]

Read More

Oracle Data Integrator (ODI)/Sunopsis – Architecture & Installation overview

Oracle Data Integrator (ODI) is  – product from Sunopsis acquired by Oracle in 2006 and now part of Oracle Fusion Middleware Family. 1. ODI is built on E-LT(Extract , Load and Transform) Architecture. 2. Oracle Data Integrator 10g (10.1.3.5.0) suite includes three products a) Oracle Data Integrator b) Oracle Data Quality and c)  Oracle Data Profiling 3. ODI uses […]

Read More