Data Integration and Management

Parallel Processing in ODI

By Christophe Dupupet on November 20, 2009 8:11 PM

This post describes how ODI can be leveraged to execute processes in parallel, and beyond the parallelisation how these can then be synchronized.

Comments (0) | TrackBacks (0)

The Benefits of ODI Knowledge Modules: a Template Approach for Better Data Integration

By Christophe Dupupet on November 9, 2009 8:17 AM

An analysis of the benefits of using a template based approach for data integration, and how this approach is made possible by ODI Knowledge Modules.

Comments (0) | TrackBacks (0)

Did You Know that ODI Automatically Summarizes Data Errors?

By Christophe Dupupet on October 9, 2009 10:09 AM

ODI automatically generates a table to summarize all errors identified on a server. We review here the structure of this table, and how to locate it on the server.

Comments (0) | TrackBacks (0)

Connecting to Oracle Business Intelligence EE using Oracle Data Integrator

By julien.testut on October 8, 2009 4:26 PM

Looking for Data Integration at OpenWorld 2009? Click here! The posts in this series assume that you have some level of familiarity with ODI. The concepts of Topology, Data Server, Physical and Logical Architecture are used here assuming that...

Comments (1) | TrackBacks (0)

Creating a New Knowledge Module for Sample Data Sets Generation

By Christophe Dupupet on October 1, 2009 10:01 PM

This post will look into when and how to create a knowledge module. Then it will walk through some of the choices that can be made when designing a Knowledge Module. A complete KM is provided to support the explanations.

Comments (2) | TrackBacks (0)

ODI User Functions: A Case Study

By Christophe Dupupet on September 20, 2009 8:29 PM

Using one of the ODI User Functions that were described in a previous post, we review how to design and use User Functions in ODI.

Comments (0) | TrackBacks (0)

How to Define Multi Record Format Files in ODI

By julien.testut on September 13, 2009 4:18 PM

The posts in this series assume that you have some level of familiarity with ODI. The concepts of Datastore, Model and Logical Schema are used here assuming that you understand them in the context of ODI. If you need more...

Comments (2) | TrackBacks (0)

Generating Sample Data with ODI: A Case Study For Knowledge Modules and User Functions

By Christophe Dupupet on September 9, 2009 9:09 PM

Using ODI to generate random sample data sets out of thin air, using a combination of Knowledge Module and User Functions.

Comments (0) | TrackBacks (0)

Top Ten Best Practises in Oracle Data Integrator Projects

By fx.nicolas on June 25, 2009 11:44 PM

Top Ten Best Practices in Oracle Data Integrator Projects This post assumes that you have some level of familiarity with Oracle Data Integrator. Please refer to the ODI Tutorial for a quick introduction, or to the complete ODI documentation for...

Comments (0) | TrackBacks (0)

Using an ODI Procedure to Loop Through a Command

By julien.testut on June 12, 2009 4:18 PM

The posts in this series assume that you have some level of familiarity with ODI. The concepts of Procedure, Command and Logical Architecture are used here assuming that you understand them in the context of ODI. If you need more...

Comments (0) | TrackBacks (0)

Best Practices for Running ODI-EE in Parallel

By dain.hansen on May 21, 2009 2:45 PM

This latest article by Uli Bethke describes how to execute ELT scenarios in Oracle Data Integrator Enterprise Edition to run in parallel to optimize performance and scalability. In his words: I have been working on Oracle Data Integrator (ODI) over...

Comments (1) | TrackBacks (0)

Using ODI Variables in Topology: Pushing Contexts to the Extreme

By Christophe Dupupet on May 8, 2009 6:07 PM

The posts in this series assume that you have some level of familiarity with ODI. The concepts of Context, Topology, Logical Architecture, Physical Architecture and Variables are used here assuming that you understand them in the context of ODI. If...

Comments (4) | TrackBacks (0)

Executing the Same Code in All Environments: ODI Contexts.

By Christophe Dupupet on April 27, 2009 7:00 PM

The posts in this series assume that you have some level of familiarity with ODI. The concepts of Context, Topology, Logical Architecture and Physical Architecture are used here assuming that you understand these concepts in the context of ODI. If...

Comments (0) | TrackBacks (0)

Using Variables in ODI: Creating a Loop in a Package

By Christophe Dupupet on April 20, 2009 3:30 PM

The posts in this series assume that you have some level of familiarity with ODI. The concepts of Model, Project, Interface and Package are used here assuming that you understand these concepts in the context of ODI. If you need...

Comments (0) | TrackBacks (0)

Using Parameters in ODI: The Dynamic File Name Example

By Christophe Dupupet on April 9, 2009 5:03 PM

The posts in this series assume that you have some level of familiarity with ODI. The concepts of Model, Project, Interface and Package are used here assuming that you understand these concepts in the context of ODI. If you need...

Comments (4) | TrackBacks (0)

Using Variables in ODI: The Timestamp Example

By Christophe Dupupet on March 30, 2009 10:53 AM

The posts in this series assume that you have some level of familiarity with ODI. The concepts of Model, Project, Interface and Package are used here assuming that you understand these concepts in the context of ODI. If you need...

Comments (2) | TrackBacks (0)

Introducing Oracle Data Integrator Enterprise Edition

By dain.hansen on January 30, 2009 12:19 PM

Oracle has unveiled that it will now include both Oracle Data Integrator and Oracle Warehouse Builder Enterprise ETL, formerly an add-on option to Oracle Database, as the two components of Oracle Data Integrator Enterprise Edition (ODI-EE). Going forward, these products...

Comments (0) | TrackBacks (0)

Unwrapping ODI's newly released: 10.1.3.5

By dain.hansen on December 18, 2008 3:43 PM

All I wanted for the holidays: Oracle Data Integrator 10.1.3.5 What's in the box? Well what's notable is that ODI now gives its users an edge in Business Intelligence. Specifically, ODI can be used as the data integration platform of...

Comments (0) | TrackBacks (0)