1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Introduction to Oracle Warehouse Builder

Discussion in 'Other Development Tools' started by Anne, Sep 16, 2008.

  1. Anne

    Anne Forum Advisor

    Likes Received:
    Trophy Points:
    Introduction to Oracle Warehouse Builder

    With the increase in need for more advanced business systems, there is a requirement for applications with better tools and capability to design data structures with more proficiency. New systems should be able to fetch data from data repositories and utilize them efficiently.

    Oracle Warehouse Builder is a database design, ETL (Extraction Transformation Load) Tool. It helps to manage the data lifecycle and metadata in all the phases from designing of the tool, until its deployment and maintenance. Various administrative and integration features are introduced with better data quality features to design, deploy and manage business intelligence and data integration systems easily.

    Oracle Warehouse Builder is automatically integrated with the oracle database as it comes free with the various Oracle database editions. Data quality and ETL requirements can be easily managed with connector capabilities and new options that are available with newer versions of Oracle Warehouse Builder. Oracle Warehouse Builder is a scalable and secure technology that provides data integration facility along with auto-correction, data profiling and auditing methods. It is capable to deal with data integration processes of any size and heterogeneous data sources in a single package of Oracle Warehouse Builder.

    You can design OLAP and relational database structures with the help of Oracle Warehouse Builder. Storing enterprise data in an Oracle Database repository is also an easy task with data structures in OLAP and relational structure format. This helps to take better decisions and hence optimizes business profits and performance as present day businesses require information storage system that can be easily accessed and manipulated.

    Even if your organization does not have Oracle database, the new version Oracle Warehouse Builder 10g is capable to support various non-Oracle databases also. It saves the time and cost otherwise spent on manipulating developing standards and conversion.

    Oracle Warehouse Builder consists of two components, namely,
    • Design environment and
    • Runtime environment.
    The Design environment of Oracle Warehouse Builder deals with metadata directly. It consists of Oracle Warehouse Builder client and various utility programs. The runtime environment converts the metadata into physical designs, database process flows and objects. It is also used to create packages and scripts that help to retrieve data from database and store in warehouse objects. The warehouse is loaded using the program code generated by Oracle Warehouse Builder.

    The best part of creating source definitions with Oracle Warehouse Builder is that the definitions are stored in the central repository, which may be used as documentation for future purposes. If any changes are made in the source data then these definitions are automatically reconciled. Building warehouse objects is easy with graphical interface of Oracle Warehouse Builder.

    Even though the graphical interface is an easy and better method for defining warehouse objects, Oracle Warehouse Builder also supports data mappings to define a mapped canvas the data of which can be processed using SQL or PL/SQL functions.