Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

December 30, 2008

Oracle’s Warehouse Builder for any kind of your Extraction-Transformation-Loading needs within Oracle database

Filed under: Oracle Business Intelligence — H.Tonguç Yılmaz @ 1:06 pm

Warehouse Builder is a cost-free(part of the database license) ETL tool which produces PL/SQL when its mappings are deployed. The components you use to develop your data flows are based on Oracle’s SQL and PL/SQL capabilities.

In my opinion you really don’t need to own a warehouse to use OWB, with 11g now it is even coming installed with your database. So if you are also an Oracle database minded developer you better plan to check OWB 11g, similar to Apex I can guarantee that you will be having lots of fun and most probably some opportunity to develop your knowledge :)

Here is a hint showing how it can be possible to automate generation from your standard SQLs to OWB mappings.

And here you will find some important OWB hints.


1 Comment »

  1. […] by H.Tonguç Yılmaz on April 3, 2009 I already mentioned here and here that I love Apex and OWB since they are Oracle database integrated development environments, this […]

    Pingback by Getting Started and Extending your Knowledge with Oracle Warehouse Builder 11g « H.Tonguç Yılmaz - Oracle Blog — April 3, 2009 @ 1:08 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: