Oracle OWI and
Oracle Database Tips by Donald Burleson
After acquiring the Sunopsis company product, Oracle has introduced
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
"[ODI] - is more for real-time [integration scenarios], which if you
think about it is consistent with the hot-pluggable commitment we have [with
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
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
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts.