Oracle Data Integrator and OWB Oracle Tips by Burleson Consulting

After acquiring the Sunopsis company product, Oracle has introduced their new Oracle Data Integrator OIDI) product, evidently to supplement their Oracle Warehouse Builder (OWB) offering.

Oracle notes that ODI will supplement their fusion middleware project, but it is not clear how or when ODI will merge with the proven OWB offering.

This article notes that ODI and ODM complement each other:

""[W]e have a number of customers that use [OWB] to build out data warehouses that run in the [Oracle] database. Using Oracle Warehouse Builder, customers can pull information quite easily from an Oracle database and make it accessible in something like an interactive dashboard or ad hoc analysis," says Rick Schultz, vice-president of Fusion Middleware with Oracle.

"[ODI] … is more for real-time [integration scenarios], which if you think about it is consistent with the hot-pluggable commitment we have [with Project Fusion]."

The idea, officials say, is that customers can tap ODI in tandem with Oracle’s revamped Business Intelligence Suite Enterprise Edition to agglomerate and analyze data from Oracle’s universe of Project Fusion applications."

Oracle warehouse guru Mark Rittman also notes that Oracle is unclear on their plans to merge OWB and ODI:

""[T]he big question is whether Oracle will maintain both OWB and Data Integrator, whether they merge the code bases, or whether they keep just one and take some of the best features of the other,"

"Who outside Oracle knows? Certainly there’s a Statement of Direction on Data Integrator on OTN, but they don’t—yet—address the question as to how it will relate to OWB going into the future."

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.