Oracle Warehouse Builder

Oracle Warehouse Builder, or OWB, is a data warehousing-centered data integration solution that comes pre-installed with Oracle Database 11gR2. It can be installed and used alongside 10gR2 and 11gR1.

This specific warehouse-centered integration solution is best used for small to middle-sized warehousing projects. Some of the highlights include very good performance of ETL processing, since the solution uses Oracle database as a transformation engine.

The visual design of the tool is up to modern standards, it allows users to create pl/SQL codes automatically, and it’s very well structured. It provides users with data quality, data auditing, dimensional and integrated relational modelling, as well as full lifecycle management of data and metadata.

It can be used to create data warehouses, migrate data from old systems, consolidate data from other data sources, as well as filter data to provide quality information. In short, Oracle Warehouse Builder aims to be the best tool when it comes to data integration.

Oracle provides a comprehensive set of documentation articles in regards to the latest OWB libraries, and SDKs. The project’s whitepaper with the latest updates and features can also be accessed from the General Information section.