Home » SQL & PL/SQL » SQL & PL/SQL » Role of ETL Tool - OWB
Role of ETL Tool - OWB [message #224535] Wed, 14 March 2007 10:55 Go to next message
Messages: 20
Registered: November 2006
Location: Pittsburgh, USA
Junior Member


I am in the designing and implementation of a Datawarehouse Profitability Solution for our client. I am working in the datawarehouse environment for the first time.
I have read that for ETL it's good to use OWB or some other ETL tools. However ETL can also be written through PL/SQL coding, so why do we need OWB? what is the significance of using OWB in datawarehouse environment. What role does OWB play in datawarehouse environment? Please guide me...
Thanks a lot in advance....

Re: Role of ETL Tool - OWB [message #224608 is a reply to message #224535] Wed, 14 March 2007 14:06 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
The OWB User Guide has a part named "Benefits of using OWB":

My own opinion: OWB does a lot of stuff for you, so you don't have to code it yourself. On the other hand, you have to learn a new tool (and the people maintaining and administering the DWH too). But since datawarehousing comes with a lot of special techniques and methods you have to learn anyway, why not learn a tool too while you're at it...
Previous Topic: Data model design
Next Topic: Top 20% of Customers
Goto Forum:

Current Time: Sun Aug 20 08:47:26 CDT 2017

Total time taken to generate the page: 0.40810 seconds