Skip to main content

ODI Tutorials & Documentation: Oracle Data Integrator Resources for Beginners

I have put together a link list of all the ODI resources I know off on the web. If you know any other relevant resources contact me and I will add it to the list below.
In my opinion the best place to get started with is the Data Warehouse Best Practices using Oracle Data Integrator Enterprise Edition guide. This explains the concepts very well and also has some detailed examples on Knowledge Modules, the Substitution API, setup, deployment etc.
ODI OTN Discussion Forums
I monitor the ODI forum on OTN at the end of each day to see if any relevant items have been discussed.
Oracle By Example: Oracle Data Integrator
The Oracle By Example (OBE) series should be one of the starting points for learning any new Oracle technology. The OBE for ODI series is a must.
Documentation
Download all relevant PDFs on Knowledge Modules, the Substituion API, Jython, ODI Tools etc. from the documentation page.
ODI homepage on the Oracle website
Blogs
Rittman/Mead
ODI Experts
John Goodwin

The official Oracle Data Integration Blog

Oracle Data Integration (ODI) Resource Kit LinkedIn Groups
Oracle Data Integration: Warehouse Builder (OWB), Data Integrator (ODI), Data Profiling and Quality
Oracle Data Integrator (ODI)
Metalink
Metalink has very useful information on Oracle Data Integrator. To get an overview what is available, log on to Metalink and search for ODI FAQ.
This will return a list of valuable documents

Oracle Data Integrator, Change Data Capture (CDC), and (near-)realtime data integration requirements

Mark Rittman – An Introduction to Real-Time Data Integration
Gartner: ODI and CDC for Activity Monitoring
Improve Data Integration with Changed Data Capture (PDF)
Installation
Complete installation guide including Lightweight Designer, Axis 2 etc.

Knowledge Modules
Have a look at article on OTN for an introduction to knowledge modules
Uli Bethke – Developing a Knowledge Module in Oracle Data Integrator

Oracle Data Integrator documentation library: XML guide, LDAP guide, Java APIs Reference etc.
No link here. This is installed when you install ODI. Access via \ oracledi\doc

ODI Data Quality
Data Quality Tutorial

Misc.
Import Export Best Practices PDF: Metalink document 549318.1
ODI 10.1.3 Work Repository Documentation: Note 579751.1 on Metalink

Craig Stewart has put together a superb set of ODI video tutorials.
How to define a PostgreSQL in ODI – then reverse engineer in the Designer to access the data
Defining a PostgreSQLserver in ODI
ODI has some automatic features which will generate the Group By Statement for you when you use any of the aggregation functions, this is a short demo of how to use it
How to use Aggregation Functions in ODI
What is the Common Format Designer (CDF), and what can we do with it? Short demo of the features, generating schemas and generating interfaces automatically.
ODI’s Common Format Designer
Short demo on the Metadata Navigator of ODI
ODI’s Metadata Navigator
OdiZip is a useful tool and this short screencam illustrates its use
OdiZip How to use
Sybase ASE to IQ knowledge module
Sybase ASE to IQ KM demo
How to use custom Java classes in your ODI procedures
Using custom Java code in ODI
Using Excel in ODI, including getting round the problem with the limitation of fixed named ranges
Using Excel in ODI
How to define and use Flexfields to extend ODI’s metadata
Using FlexFields in ODI
Defining XML file in Topology and reverse engineering
XML 1 Defining
What does the XML structure look like in ODI?
XML 2 The Rendered Data Structure
When the definition doesn’t work, how do you find out what has gone wrong?
XML 3 Topology
How to use ODI to populate a simple XML structure
XML 4 Populating Simple XML
Populating a more complex XML structuire – requiring the use of multiple interfaces. Writes to a file with a dynamic name – in this case the session_id.xml
XML 5 Populating Complex XML
How to configure external database storage for the JDBC Driver for XML- useful when dealing with large XML files
XML 6 External Database Storage
How to set up the file name for the XML file so that it accommodates the use of multiple different file names
XML 7 Reading a Dynamically named XML file
In order to master scripting in ODI I recommend the following books.
Java BeanShell
Scripting in Java: Languages, Frameworks, and Patterns
Jython
Great Jython cheat sheet by the guys from ODI experts. Covers a lot of the recurring Jython code snippets that you need for ODI. Thanks Cezar and Dev.
The Definitive Guide to Jython: Python for the Java Platform.
Jython Essentials (O’Reilly Scripting)

Comments

Popular posts from this blog

ODI KM Adding Order by Option

You can add Order by statement to queries by editing KM.I have edited IKM SQL Control Append to provide Order by.  1) Add an option to KM named USE_ORDER_BY, its type is Checkbox and default value is False. This option determines you want an order by statement at your query. 2)Add second option to KM named ORDER_BY, type is Text. You will get order by values to your query by this option. 3) Editing Insert New Rows detail of KM. Adding below three line code after having clause. That's it! <% if (odiRef.getOption("USE_ORDER_ BY").equals("1")) { %> ORDER BY <%=odiRef.getOption("ORDER_BY" )%> <%} %>  If USE_ORDER_BY option is not used, empty value of ORDER_BY option get error. And executions of KM appears as such below; At this execution, I checked the KM to not get errors if ORDER_BY option value is null. There is no prove of ORDER BY I'm glad.  Second execution to get  Ord...

Creating Yellow Interface in ODI

Hello everyone! In Oracle data integrator (ODI), an  interface  is an object which populates one datastore, called the  target , with data coming from one or more other datastores, known as  sources . The fields of the source datastore are linked to those in the target datastore using the concept of  Mapping . Temporary interfaces used in ODI are popularly known as  Yellow Interfaces . It is because ODI generates a yellow icon at the time of creation of a yellow interface as opposed to the blue icon of a regular interface. The advantage of using a yellow interface is to avoid the creation of  Models each time you need to use it in an interface. Since they are temporary, they are not a part of the data model and hence don’t need to be in the Model. So let’s begin and start creating our yellow interface! Pre-requisites : Oracle 10g Express Edition with *SQL Plus, Oracle Data Integrator 11g. Open *SQL Plus and create a new table  Sales ...

Synchronous and Asynchronous execution in ODI

In data warehouse designing, an important step is to deciding which step is before/after. Newly added packages and required DW data must be analyzed carefully. Synchronous addings can lengthen ETL duration. Interfaces, procedures without generated scenario cannot be executed in parallel. Only scenario executions can be parallel in ODI. Default scenario execution is synch in ODI. If you want to set a scenario to executed in parallel then you will write “-SYNC_MODE=2″ on command tab or select Synchronous / Asynchronous option Asynchronous in General tab. I have created a package as interfaces executes as; INT_JOBS parallel  INT_REGIONS synch  INT_REGIONS synch  INT_COUNTRIES synch  INT_LOCATIONS parallel  INT_EMPLOYEES parallel (Interfaces are independent.) Selecting beginning and ending times and durations from repository tables as ODI 11g operator is not calculating these values. It is obvious in ODI 10g operator. SELECT    sess_no...