Re: Oracle Data Warehouse builder

The 9i version, which I have been using on a project for about 4 months now, isn't bad overall. Especially when you compare its price to say, Informatica. If your main goal is to generate PL/SQL ETL processes quickly, then you should at least download OWB and give it a good look. Some more details below.

The good:

Generates decent, flexible PL/SQL packages and SQL Loader scripts to load and transforms your data.

Some good performance enhancing capabilities - e.g. hints and partition swapping.

Basic auditing and error handling included.

The bad:

One or two bugs/oversights (e.g. no COUNT DISTINCT, we had to edit the repository manually to get that going), but no show stoppers so far.

The table creation facilities are abysmal - don't even consider using Warehouse Builder to create database objects, use a real tool

The data dictionary reports are next to useless. Plan to generate your own documentation.

The ugly

The interface can be somewhat clunky and irritating at times. It's Java and it shows. Still possible to be reasonably productive.

David.

"MD" <mdmisc_at_mail.com> wrote in message news:9e462167.0207171250.5f46ee6b_at_posting.google.com...
> Hi,
>
> In my project we are thinking about using Data Warehouse Builder. So
> does anybody have any experiance with this tool and could give some
> review of it? What it does and what it doesn't do, is it usefull or
> useless, what features are good what are bad.
>
> Thanks a lot.
> MD
Received on Fri Jul 19 2002 - 17:55:31 CEST