| What
Is OracleBI Warehouse Builder?
OracleBI
Warehouse Builder, also known as Warehouse Builder, is a tool that
enables the design, deployment, and management of enterprise data
integration and consolidation processes, including data warehouses,
data marts, operational data stores, and e-business intelligence
applications. As a data integration tool,
Warehouse Builder facilitates
the use of the industry strength Oracle database as a single data
and metadata consolidation platform.
To
design data sources, targets, and data integration processing,
Warehouse Builder provides
a user-friendly graphical environment, thus avoiding manual coding
and maintenance of large data integration procedures. It also leverages
the latest data integration features of the Oracle database transparently
and offers one of the best price-performance ratios in the industry.
Typical
Usage Pattern
The
typical
Warehouse Builder usage
pattern is:
- Designing the data objects and integration processes by using
Warehouse Builder's powerful graphical user interface:
- Integrating
the data sources into the design - Data sources can include
database objects, such as tables and views (Oracle or third
party), flat files, pre-packaged applications, queues, XML files,
and so on.
- Designing
the target data model (data store) - The target model
can be relational or multidimensional (OLAP).
- Designing
the integration processes - These processes will extract
data from sources, process it, and load it into the target.
- Deploying the design into the target environment - Based on
the design in the previous step, Warehouse Builder will
generate code (PL/SQL code for the Oracle database, ABAP
code for SAP®, SQL Loader files, and so on). The deployment
step generates the code that creates both data objects and procedures
designed in the previous step. This step also runs the generated
code against the target database schema. The result of this step
is the creation of links from the target database to the source
data locations (typically database links, file locations, and
so on), which enables the data integration procedures to access
the data sources.
- Running
the processes designed and deployed in the previous steps
as a continuous operation (with the frequency appropriate to the
user’s data acquisition cycle) and monitoring the processing outcomes
and resolving day-to-day operational issues - Periodically it
might be necessary to modify the design and re-deploy the modified
objects due to changes in data source, targets, processing logic,
or hardware and software reconfigurations.
Enterprise
Metadata Management
Metadata
is a valuable asset. To handle the business intelligence metadata,
Warehouse Builder provides a
scalable and open metadata store.
Leveraging an Oracle database makes the metadata secure and accessible.
It also provides for comprehensive metadata reporting and ensures
metadata quality through validation and guided design.
Enterprise
Data Integration
Warehouse Builder allows the metadata integration based on the latest
Oracle technology. By leveraging the Oracle database features, Warehouse
Builder guarantees performance and scalability. It offers
extensive run-time and operations management.
Complete
System Design
System
design is one of Warehouse Builder’s most valued features. The tool
allows you to design
the entire business intelligence system including relational
schemas, dimensional models, target environments, and data integration
processes. Warehouse Builder metadata can be exported to OracleBI
Discoverer, as well as to the Analytic Workspace in
Oracle database
for analysis. Once the design is completed and deployed, Warehouse
Builder can be used to run and manage the data integration processes.
The design and run-time features are both included in a single flexible
tool.
Integrated
Quality
Warehouse Builder combines ETL functionality with data
cleansing capabilities such as parsing, correction, standardization,
and intelligent deduplication of data elements, ensuring the accuracy
of data loaded in the Data warehouse. It includes name and address
cleansing, where existing customer data coincides with up-to-date
postal databases, using advanced algorithms that significantly improve
data quality by eliminating multiple records that refer to the same
entity or when multiple records must be grouped under a single entity
as in the case of "householding" (grouping multiple members
of a single household under a single mailing address).
Open
and Extendable
Warehouse Builder offers a variety of ways for accessing its metadata
and services, giving the user unprecedented flexibility. Java APIs
and the OMB extensions to the Tcl scripting language are available
to use Warehouse Builder’s features in external applications and
operating system scripts. Standard formats such as Common Warehouse
Metamodel (CWM™) allow seamless integration with a variety of third-party
tools. Documented public views provide a convenient way for the
metadata inspection. Finally, users can extend Warehouse Builder's
metadata repository to include custom design information.
Availability
Warehouse Builder is available on the Oracle Business Intelligence
Tools CD. This component is also available in Oracle Developer Suite.
|
