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)

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)

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)

5 Ways to Cut Costs for Data Warehousing

By dain.hansen on March 9, 2009 12:21 PM

Are you trying to better understand what doing "more with less" means for data warehousing? Or are you making the mistake of trying to catch falling knives? Well if it is the former, hopefully you didn't miss the I-Seminar today,...

Comments (0) | TrackBacks (0)

From EII to Full Data Integration

By Alex Kotopoulis on February 26, 2009 5:25 PM

I never liked the term EII much to describe federated data services such as Oracle Data Service Integrator, so when I read the blog entry “Whatever happened to EII?” by Rob Karel and James Kobielus from Forrester, I felt confirmed...

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

SOAsaurus Shrugged

By dain.hansen on January 9, 2009 12:12 PM

It’s tempting. It’s all too easy to be the first to predict that SOA is dead. I’m the first to admit that I’m eager helping pick out the plot and the right size coffin. But let’s be thankful before we...

Comments (1) | TrackBacks (0)

2008 Year in Review for Data Integration and Management

By dain.hansen on December 22, 2008 2:18 PM

So rather than my own ramblings of the best and worst in 2008, I thought I would point you to other folks who have also reviewed the landscape. Consider this a review of other year in reviews! Number 5: Fernando...

Comments (1) | TrackBacks (0)

Bull Market on BI in 2009

By dain.hansen on December 16, 2008 10:40 AM

Recently Timo Elliot, wrote four top reasons for "What Might Go Wrong in Business Intelligence in 2009". In his reason #2 he cites: Corporate cutbacks, "thou shalt not buy anything" policies, and new levels of sign-off will encourage some people...

Comments (0) | TrackBacks (0)

Unified Data is Key to your Bottom Line

By dain.hansen on December 11, 2008 2:50 PM

According to Chris Kanaracus from Computerworld, Gartner has lowered its worldwide enterprise software spending forecast from $229.2 billion, instead of the $231.2 billion that it predicted in September. This was impacted by "a combination of economic, technical and regional forces."...

Comments (0) | TrackBacks (0)

750 Billion reasons for using Data Management

By dain.hansen on November 20, 2008 8:58 AM

Ok we've seen these blogs all over the place now. We know we're in a recession. We know we want to do more with less in our IT budgets. Tell us something we don't already know. But this is taking...

Comments (0) | TrackBacks (0)

The Results are In! Check out the State of the Data Integration Market Report

By dain.hansen on November 14, 2008 8:52 AM

The growth of the Data Integration segment has exceeded market expectations as companies recognize the fundamental importance of unified enterprise data. The market is now expected to exceed US $3 billion by 2012. Because the business drivers for data integration...

Comments (0) | TrackBacks (0)

Ask the experts your toughest Data Integration question

By dain.hansen on October 17, 2008 9:00 AM

For those of you who are trying to navigate the complex world of Data Integration and stuck with an issue. This is definitely a great place to bounce some ideas off our industry experts. Ask us your toughest questions and...

Comments (1) | TrackBacks (0)

Tough times require tough Data Management approaches

By dain.hansen on October 7, 2008 4:35 PM

These are tough financial times, no matter where you sit. All of us in IT are retreating back to what's basic, what's essential, and what's critical for the business. Alas, there's one ray of hope for all those Data Integration,...

Comments (0) | TrackBacks (1)