 Oracle
Unveils New Data Management Software
Oracle recently released its 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.
The new release introduces significant new data
quality, integration and administrative features for
customers seeking an easy-to-use tool for rapidly
designing, deploying, and managing data integration
projects and business intelligence (BI) systems.
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.
But this is just a small portion of the core
functionality bundled with Oracle Database 10g
Release 2. Two new options are also 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.
Melissa Data offers advanced data quality tools that
are designed exclusively for Oracle users. For
example, Address Validator is used with Oracle
Warehouse Builder and Clean Address is a component
for verifying and standardizing addresses via Oracle
database applications. The Web Service and Address
Object also are compatible with a variety of
operating systems and database applications.
All of these data quality solutions can be easily
integrated into applications utilizing the Web,
Oracle Forms, PL/SQL, C++, .NET or Java.
Clean up that
dirty data already! Get a quote for Address
Validator for OWB!
|
