Oracle Ships New Warehouse Builder Tool - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.


Oracle Ships New Warehouse Builder Tool

Users can buy optional features to allow the software to work in heterogeneous environments.

Oracle this week shipped release two of its Oracle Warehouse Builder 10g database tool, which solution providers can use to cleanse data and build analytics applications.

Oracle Warehouse Builder 10g Release 2, a database design and Extraction, Transformation and Load (ETL) application, helps customers manage the life cycle of data and metadata. Oracle said it also plans to embed core ETL capabilities into the various versions of its database software.

Users of Oracle 10g Enterprise Edition Release 2, too, can purchase additional ETL capabilities via a Warehouse Builder Enterprise ETL option for heterogeneous environments, with support for user-defined objects and associations. In addition, a Data Quality option adds data profiling and rules, cleansing, auto-correction and auditing.

The ETL option costs $10,000 per CPU or $200 per user. The Data Quality option runs $15,000 per CPU or $300 per user. Connectors for PeopleSoft Enterprise, Oracle E-Business Suite and SAP are $20,000 per connector per target application.

Rich Niemiec, CEO of TUSC, a Chicago-based Oracle partner, is bullish on the new Warehouse Builder offering.

"The biggest benefit is the ability to easily integrate data from internal and external heterogeneous sources with one tool and one company," Niemiec said in an e-mail. "Oracle is providing one tool for multiple functions, which provides consistency across teams and a reuse of skills and processes. Connectors for Oracle E-Business, PeopleSoft and SAP are a huge benefit for partners."

The new Warehouse Builder release eases deployment and scheduling, providing many more options than it did previously, and helps execute the data integration processes, Niemiec added.

Another perk is the product's ability to automate management of slowly changing dimensions for business intelligence. "You can store current and historical data," Niemiec said.

Oracle's new tool also reflects a trend in which the worlds of data warehouses, traditionally used for historical data, and operational databases, typically used for everyday tasks, are becoming more closely linked.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
The State of Cloud Computing - Fall 2020
The State of Cloud Computing - Fall 2020
Download this report to compare how cloud usage and spending patterns have changed in 2020, and how respondents think they'll evolve over the next two years.
2021 Outlook: Tackling Cloud Transformation Choices
Joao-Pierre S. Ruth, Senior Writer,  1/4/2021
Enterprise IT Leaders Face Two Paths to AI
Jessica Davis, Senior Editor, Enterprise Apps,  12/23/2020
10 IT Trends to Watch for in 2021
Cynthia Harvey, Freelance Journalist, InformationWeek,  12/22/2020
Register for InformationWeek Newsletters
Current Issue
2021 Top Enterprise IT Trends
We've identified the key trends that are poised to impact the IT landscape in 2021. Find out why they're important and how they will affect you.
White Papers
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Sponsored Video
Flash Poll