Oracle Beefs Up Data Warehouse Technology - InformationWeek
IoT
IoT
Software // Information Management
News
7/26/2006
12:12 PM
50%
50%

Oracle Beefs Up Data Warehouse Technology

The company moved core data transformation functions to its Oracle 10g database and expanded the range of applications from which it can extract information.

Oracle is bundling more of its data extraction, transformation, and loading (ETL) capabilities for building data warehouses with its flagship database software. The move is part of a new release of the vendor's data warehouse toolset it began shipping Wednesday.

Oracle Warehouse Builder 10g Release 2 provides enhanced data quality management capabilities, including name and address cleansing and de-duplication for identifying and removing redundant data. The new release also offers the ability to design relational and online analytical processing database structures, support for loading data into non-Oracle databases, and a tool for encapsulating an organization's development standards and best practices as wizards.

Oracle is bundling those features, along with other ETL functions at the core of Oracle Warehouse Builder, with the Oracle Database 10g Release 2 Enterprise Edition, Standard Edition, and Standard Edition One at no extra charge, says Paul Narth, a senior group manager at Oracle. The Oracle database is the foundation for the Oracle Warehouse Builder product. Using the database as the data transformation engine provides better performance than competing ETL products from vendors such as IBM and Informatica, Narth says.

Warehouse Builder 10g Release 2 also includes new options that work with the core ETL functions in the Enterprise Edition database. A data quality option, priced at $15,000 per CPU or $300 per user, provides data profiling and rules functions and the ability to audit data transformation tasks and take corrective action when quality remains low. An ETL option, priced at $10,000 per CPU or $200 per user, includes a data lineage and impact analyzer and a change propagator for responding to changing metadata.

Oracle also offers connectors for extracting data from ERP and CRM applications and loading it into a data warehouse. There are connectors for Oracle's E-Business Suite and PeopleSoft applications, as well as SAP R/3 applications. Connectors are priced at $20,000 per connector per target database. The connectors now support IBM's DB2 and Informix databases and Microsoft SQL Server.

This week Oracle also announced that it is embedding an industry-standard IT governance methodology, called COBIT 4.0, into its Oracle Internal Controls Manager product that's used to document, test, and certify that IT controls comply with regulations such as Sarbanes-Oxley. COBIT (Control Objectives for Information and Related Technology) 4.0 is the latest set of IT-control best practices and metrics developed by the Information Systems Audit and Control Association.

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
2017 State of the Cloud Report
As the use of public cloud becomes a given, IT leaders must navigate the transition and advocate for management tools or architectures that allow them to realize the benefits they seek. Download this report to explore the issues and how to best leverage the cloud moving forward.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of November 6, 2016. We'll be talking with the InformationWeek.com editors and correspondents who brought you the top stories of the week to get the "story behind the story."
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.
Flash Poll