RE: Looking for folks that have had a positive experience with OWB

From: Herald ten Dam <>
Date: Wed, 22 Apr 2009 11:43:06 +0200
Message-ID: <BACE06B587FB3C47AC31296417C11434016BE70753DD_at_thnms004.TheHumanNetwork.local>

A long time ago I worked on a project with Oracle Owb 10. After looking at the tool and looking at the people avaiblable that moment, we took the decission that the business people made the mappings in OWB (after just a midday of training first). Just the mappings, they did not the generation. If they were ready, they mentioned it to the developer, sometimes the DBA. These persons made the generation and optimized the code generated. This worked great.

If the Business Analysts didn't get the mapping, they asked a developer to support them. Sometimes we need an function programmed for this, the developer did, put it in OWB and the Business Analyst coud use it.

The initial setup is essential for a later deplyment into production. We made two OWB repositories, one development/test and one for acceptance/production. This worked very well.

Herald ten Dam

Van: [] namens Frits Hoogland [] Verzonden: woensdag 22 april 2009 9:23
Aan: CC:;; Oracle-L Freelists Onderwerp: Re: Looking for folks that have had a positive experience with OWB

same experience here: developers just dragging and dropping together the data transformations, which led to extremely inefficient database usage.

my experience with OWB was the developers were making their thing, but let the DBA's do OWB, and DBA's finding it a tool for developers, so they all pushed the responsibility away. it only works if somebody/some group takes ownership of it.


On Wed, Apr 22, 2009 at 4:05 AM, Joel Wittenmyer <<>> wrote: I don't know what the tool is like today, but can say that in previous releases it should only have been used by DBAs. It used to make some really counter-productive design decisions regarding performance. Do not let ignorant people this tool unless you have oversight. I had a entry-level developer at a Fortune 100 company bring the database to it's knees through a combination of arrogance and ignorance. (Ignorance = not knowing what you don't know.) The reasoning? If OWB did it, it must be right.

-----Original Message-----
From:<> [<>] On Behalf Of Niall Litchfield
Sent: Tuesday, April 21, 2009 9:31 AM
To:<>; Oracle-L Freelists Subject: Re: Looking for folks that have had a positive experience with OWB

Hi carol I'm currently on site for a dwh project that uses owb extensively. It isn't an end user tool, or for that matter one for people who don't have good dw development experience to use to develop things in. It does do the job fairly well though - although the generated code can be hard to read. It also really really likes memory on the workstation of the developers budget on at least 2gb each. It does use oracle features. It does do auditing.

On 4/20/09, Carol Dacko <<>> wrote:
> The Data Warehousing group in our organization continues to say that their
> sources indicate that Oracle Warehouse Builder (OWB) "is not worth a
> Some non-technical folks in our organization tried out the product for
> Oracle 10g and scrapped the product.
> Does anyone have any positive experiences with this product? We are
> together a Strategic Plan for the next 3 years, and I'd like to have a
> better understanding of what the acceptance of OWB is in the marketplace.
> Thanks kindly for your appreciation regarding this request!
> Carol Dacko
> University of Michigan

Sent from Google Mail for mobile |<>

Niall Litchfield
Oracle DBA


Received on Wed Apr 22 2009 - 04:43:06 CDT

Original text of this message