0 
0 Today I looked into a pre release of Oracles Warehouse Builder 10gR2 (Paris). This comprehensive tool can be used to create complex data warehoused holding data from many different data sources like tables (in different databases), files etc.
I was really pleased by the very good reverse engineering capabilities of the tool. It’s very easy to load a schema into the Design Center of OWB. Adding new tables is also very straightforward. This functionality will compete directly with Oracles own Designer tool. To me it looks like OWB is better equiped to model complex datamodels than Designer.
The following picture shows the data object editor. Here you can define tables, keys, constraints etc.
The main goal of OWB is of course to create a data warehouse. For this you should be able to extract transform and load data (ETL) from different data sources into your warehouse. This can all be done with a graphical tool. All the code needed for deployment will be generated automatically. The following example shows a simple mapping from data from a source table to a destination table. All copying code is generated by OWB.
The tool is very stable allthough Paris is a pre-release. This version will only run on Windows (including the repository database), but I am sure Oracle will fix that in their final release.
Related posts:
Oracle Warehouse Builder 10gR2 (beta), a first impression 
Oracle Warehouse Builder – 10gR2 Paris release – Even if you do not build warehouses… Oracle Data Mining – from SQL and PL/SQL Oracle BAM with a Bang – Business Activity Monitoring 10.1.3.1 available on OTN My first steps with Oracle BI Publisher Enterprise Edition 10.1.3.2: create a report based on the OraBlogs rss-feed
Studio Photography
hey great stuff
[…] veloper, it is worthwhile looking at what Oracle Warehouse Builder can do. See for example Paris for the Designer from the AMIS Blog – by my colleague Andre Crone. […]