Oracle Warehouse Builder, either available in basic form as part of the Oracle Database or licenseable with more functionality as part of Oracle Data Integrator Enterprise Edition, is the natural choice for organizations that wish to extract data from Oracle and other sources and load it into an Oracle data warehouse.
Leveraging Oracle data warehousing features such as in-database OLAP, partitioning, SQL-based ETL and dimensional modelling, Oracle Warehouse Builder builds on your organization’s use of SQL and PL/SQL and investment in Oracle technology. Now delivered as part of Oracle Database 11g and with integrated security and repository-based modelling, Oracle Warehouse Builder is the natural choice for organizations looking to create a data warehouse for their Oracle-based data.
Consulting Services
Rittman Mead can help with the installation and configuration of Warehouse Builder, and can work with your team to define the data loading, transformation and data cleansing routines that you will build as part of your project. We can help you define your dimensional model and advise you on how to best make use of technologies such as in-database OLAP, partitioning and compression, and show you how Warehouse Builder can also bring in data from non-Oracle sources.
Training Courses
- TRN01: Oracle Warehouse Builder 10gR2 Development and Deployment (3-5 Days)
- TRN05: Oracle Data Warehouse Design (3 Days)
Licensing and Support
Whilst the basic functionality of Oracle Warehouse Builder is provided free with paid-for versions of the Oracle Database, additional functionality can be licensed either as part of Oracle Data Integrator Enterprise Edition or through the Data Quality Option for Oracle Warehouse Builder. Rittman Mead can arrange licenses for these add-ons and can provide ongoing support for new and existing Oracle Warehouse Builder deployments.
Further Information
- Read our blog posts on Oracle Warehouse Builder
- Automatic Data Cleansing and Profiling Using Oracle Warehouse Builder 10gR2 (OTN)
- An Introduction to Oracle Warehouse Builder 10g (DBAZine)
- What to Know Before Selecting OWB ODTUG Kaleidoscope’09, Monterey USA June 2009
- Oracle Warehouse Builder 10gR2 Best Practices and Advanced Features (UKOUG Conference 2007)
- Manage the DW Lifecycle using OWB10gR2 (OUG Scotland BI Tech Day, March 2007)
