Deliver Your News to the World

Oracle Announces General Availability of Oracle(r) Warehouse Builder 10g Release 2


Leading Database Design and ETL Tool Introduces Significant New Features, Core Capabilities Now Included in Oracle Database 10g at No Additional Cost
REDWOOD SHORES, Calif. 26-JUL-2006 Oracle today announced the general availability of Oracle(r) Warehouse Builder 10g Release 2, the database design and Extraction, Transformation and Load (ETL) tool that helps customers manage the lifecycle of data and metadata from design to deployment and maintenance. This latest release introduces significant new data quality, integration and administrative features, among others, for customers seeking an easy-to-use tool for rapidly designing, deploying, and managing data integration projects and business intelligence (BI) systems.

Oracle today also introduced new pricing and packaging for Oracle Warehouse Builder 10g Release 2. The core database design and ETL capabilities of Oracle Warehouse Builder 10g Release 2 are now included with Oracle Database 10g Release 2 Enterprise Edition, Standard Edition, and Standard Edition One at no additional cost. Newly available options and connectors for this tool now provide customers with increased capabilities to help meet their broad range of ETL and data quality needs.

“With the proliferation of data, and growing demand for better quality systems, organizations now more than ever require tools that help them rapidly design data structures and efficiently integrate data from disparate repositories,” said Ray Roccaforte, vice president of Data Warehousing and Business Intelligence Platform, Oracle. “Oracle Warehouse Builder 10g Release 2 represents a major investment by Oracle in data integration, and by including core capabilities with Oracle Database 10g at no extra cost, organizations of all sizes can easily turn raw data into quality information to help meet their users’ requirements.”

“With Oracle Warehouse Builder 10g Release 2, Oracle further enhances its position in the ETL market by combining significant new data integration functionality with data profiling, auditing and auto-correction facilities all on a robust, secure and scalable technology platform,” said Dan Vesset, Research Director, Analytics and Data Warehousing Software, IDC. “Oracle Warehouse Builder offers customers broad ETL management in a single package that can handle data integration projects in organizations of various sizes and with heterogeneous data sources.”

New Features Deliver Higher Quality Information, Help Save Time and Costs
Ensuring high data quality is crucial to organizations seeking to optimize business performance and ensure better decision-making. To address this requirement, Oracle Warehouse Builder 10g Release 2 offers enhanced features designed to improve data quality including name and address cleansing, and match-merge (de-duplication) functionality.

Organizations require not only high quality information, but also need information to be stored in a format that can be drilled into, manipulated, mined, and pivoted within their BI applications and decision support tools to yield information in the right format. Oracle Warehouse Builder 10g Release 2 includes the ability to design relational and OLAP database structures, making it easy to store data in a common Oracle Database repository and offer users a choice of BI tools such as Oracle Business Intelligence Suite, spreadsheets, and many others.

Oracle Warehouse Builder 10g Release 2 also now includes support for targeting non-Oracle Databases, allowing users to choose where their data is ultimately stored. “Experts” is a new, unique feature that helps save users time and costs. It enables organizations to encapsulate their own development standards and best practices as wizards, and also allows a broad range of users, including end users, access to Oracle Warehouse Builder’s declarative functionality.

New Options and Connectors Offer Customers Broad Array of ETL Capabilities
The aforementioned features comprise a small portion of the core functionality bundled with Oracle Database 10g Release 2. Two new options are now available that build upon the core capabilities in Oracle Warehouse Builder 10g Release 2. In addition, new connectors are available to ease the transformation of data from disparate application repositories.

The Oracle Warehouse Builder Enterprise ETL Option supports multi-environment deployments typical of enterprise data warehouse projects by enabling improved performance and scalability of ETL processes. Included in this option are a new, highly interactive lineage and impact analyzer, user defined objects and associations, and a change propagator that facilitates rapid response to changing metadata. The Oracle Warehouse Builder Data Quality Option promotes a comprehensive and systematic approach to data quality by offering data profiling, data rules, data cleansing/auto-correction, and data auditing in one tool.

New Oracle Warehouse Builder Connectors enable customers to extract data quickly and easily, and in some cases, target data to and from their core CRM and ERP applications including the Oracle E-Business Suite and Oracle’s PeopleSoft Enterprise. The existing Oracle Warehouse Builder Connector for SAP has been enhanced and now supports variable substitution within ABAP and direct deployment and execution of ABAP code.

Global Payments Relies on Oracle Warehouse Builder for Data Manipulation and Movement
Atlanta-based Global Payments Inc. is one of the world’s largest transaction processors and offers worldwide, world-class electronic transaction processing services through its high speed, robust electronic information networks. Its networks process billions of business and consumer payment card and money transfer transactions annually for customers in the United States, Canada, Europe and Latin America. Global Payments has accelerated development efforts on several internal high profile projects involving the manipulation and movement of data using Oracle Warehouse Builder 10g.

“We are committed to developing software that is efficient and maintainable,” said Larry Mandras, vice president of Internal Systems, Global Payments Inc. “Oracle Warehouse Builder has helped us to achieve this goal. The tool enables us to re-use code easily, integrate custom code, and to produce code that is maintained in an easier fashion because it is managed with the UI.”

Availability and Pricing
The production version of Oracle Warehouse Builder 10g Release 2 is generally available for 10 platforms including Linux and Windows. A free evaluation version of Oracle Warehouse Builder 10g Release 2 is available at:

The core ETL capabilities of Oracle Warehouse Builder 10g Release 2 are free of charge and are supported for any customer with a license for Oracle Database Standard Edition One, Oracle Database Standard Edition or Oracle Database Enterprise Edition.

The Oracle Warehouse Builder Enterprise ETL option is priced at $10,000 per CPU or $200 a user. The Oracle Warehouse Builder Data Quality option is priced at $15,000 per CPU or $300 a user. The Oracle Warehouse Builder Connectors for the Oracle E-Business Suite, PeopleSoft Enterprise, and SAP are priced at $20,000 per warehouse builder connecter.

Terms, conditions, and restrictions apply.

About Oracle Warehouse Builder 10g
Oracle Warehouse Builder 10g is Oracle’s industry leading enterprise business intelligence integration design tool. It provides data quality, data auditing, fully integrated relational and dimensional modeling and full life cycle management of data and metadata for Oracle Database. Oracle Warehouse Builder 10g delivers all this functionality in an easy to use, graphical environment that allows for the rapid design, deployment and management of data integration projects and business intelligence systems. For more information on Oracle Warehouse Builder 10g Release 2, go to:

About Oracle
Oracle (NASDAQ: ORCL) is the world’s largest enterprise software company. For more information about Oracle, visit our Web site at

# # #

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.


This news content was configured by WebWire editorial staff. Linking is permitted.

News Release Distribution and Press Release Distribution Services Provided by WebWire.