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)

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 2 OpenWorld: 1 Umbrella. 2 Espressos. And the Innovation Across the Stack

By dain.hansen on October 13, 2009 8:37 AM

With a 2 hour commute through what appears to be horizontal rain, I'm enjoying my double espresso in preparation for today's excitement. Stay dry and try not to miss the important sessions below: Check out Thomas Kurian talk about the...

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)

Oracle Welcomes GoldenGate at OpenWorld

By dain.hansen on October 1, 2009 10:40 AM

Oracle has completed the acquisition of GoldenGate Software, a leading provider of real-time data integration solutions, making GoldenGate a wholly owned subsidiary of Oracle. We're especially excited to welcome Oracle GoldenGate. We invite you to learn more about GoldenGate...

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

Best Practices building Data Services with ODI-EE

By dain.hansen on June 3, 2009 1:22 PM

If you've been reading some of the earlier posts on best practices for loading Essbase using ODI. you can definitely respect how thorough John Goodwin is in his analysis and explanations. In the same spirit, John has taken a comprehensive...

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

Rittman Mead BI Forum 2009: ODI Recap

By dain.hansen on May 18, 2009 8:48 AM

Thanks to the folks at Rittman Mead for a stellar event at the BI Forum. If you'd like to see any of the presentations, feedback, and blog posts from the forum, you can take a look at Mark's recap post...

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)