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)

Live Webcast: How Your Business Can Profit from Oracle GoldenGate

By dain.hansen on November 2, 2009 8:31 PM

Through its recent acquisition of GoldenGate Software, Oracle has accelerated its product strategy to deliver a comprehensive data integration platform and increase uptime for customers' mission-critical systems. But how can your business profit from Oracle GoldenGate products - and...

Comments (0) | TrackBacks (0)

Day 4: Hasta la Vista Oracle Open World

By dain.hansen on October 15, 2009 7:28 AM

I hope everyone enjoyed the blockbuster keynote with Arnold and Larry - my favorite quote of the night was from Gov. Shwarzeneggar in speaking how much he loved the tech industry: "I love tech. I love all kinds of tech......

Comments (0) | TrackBacks (0)

Day 3 Oracle OpenWorld: the Innovator meets Terminator

By dain.hansen on October 14, 2009 8:42 AM

For all those geeks like me who idolize both the innovators and the terminators in the world, today is your day. Day 3 promises to keynote both Larry Ellison and Gov. Schwarzenegger. And if you're like me - and I...

Comments (0) | TrackBacks (0)

Day 3 Oracle OpenWorld: the Innovator meets Terminator

By dain.hansen on October 14, 2009 8:42 AM

For all those geeks like me who idolize both the innovators and the terminators in the world, today is your day. Day 3 promises to keynote both Larry Ellison and Gov. Schwarzenegger. And if you're like me - and I...

Comments (0) | TrackBacks (0)

Live from Oracle Open World: "Art of the Possible" ... and your must see on Day 1

By dain.hansen on October 12, 2009 6:49 AM

I'm sitting here on one of just a handful of the Oracle Open World official bean bags waiting for the Charles Phillips keynote, "Art of the Possible". I thought I would send you what I think some important noteworthy sessions...

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)

Designing and Loading Your Own Staging Tables

By Christophe Dupupet on September 3, 2009 5:20 PM

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

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)

How to Customize ODI-EE through Knowledge Modules

By dain.hansen on June 12, 2009 9:19 AM

In this article entitled "Developing a Knowledge Module in Oracle Data Integrator", Uli Bethke outlines what Knowledge Modules (KMs) are and how to customize and build an Integration Knowledge Module. Uli writes: The power of KMs lies in their reusability...

Comments (0) | 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)

Connecting Visibility to Value: Data Integration and Business Intelligence

By dain.hansen on April 29, 2009 1:23 PM

Recently I just posted an article on BeyeNETWORK, entitled Connecting Visibility to Value: Data Integration and Business Intelligence. The article summarizes five important factors that are critical for Business Intelligence platforms: - Optimized data movement - Data quality - Real-time...

Comments (0) | 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)