ODI Tutorials & Documentation: Oracle Data Integrator Resources for Beginners
Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes
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.
ODI Training. Learn ODI from the experts.
[big_data_promotion]
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 Books
Discover the Oracle Data Integrator 11g Repository Data Model
Oracle Data Integrator 11g Cookbook
Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial
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
John Goodwin
My own blog Uli Bethke
The official Oracle Data Integration Blog
ODI webcasts
No new webcasts for a while now, but still useful stuff.
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 my own 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 oracledidoc
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
Uli Bethke
Uli has been rocking the data world since 2001. As the CEO of Sonra, the data liberation company, he’s on a mission to set data free. A self-proclaimed data evangelist, Uli doesn’t just talk the talk—he writes the books, leads the communities, and takes the stage as a conference speaker. Uli is a co-founder of DAMA Ireland, helping build a thriving community of data enthusiasts, and a proud Snowflake Data Superhero, leading the charge as the chapter lead of the Snowflake User Group Ireland. Whether sharing insights, empowering others, or championing the coolest data tools, Uli makes data fun. Growing up in Germany and making Ireland his home, Uli brings a global perspective to everything he does. On the academic side, he holds degrees in political science from Freie Universität Berlin, Albert Ludwigs Universität Freiburg, and the University of Ulster, Coleraine, adding a unique interdisciplinary flair to his work.
