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

April 3, 2009

Getting Started and Extending your Knowledge with Oracle Warehouse Builder 11g

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

I already mentioned here and here that I love Apex and OWB since they are Oracle database integrated development environments, this is simply because I am an old school SQL and PL/SQL minded person and these two development environments make you feel more powerful, which is IMHO a really cool feeling during chatting with the Java/SOA guys :)

I have been using OWB 11g for some time now and I want to prepare a getting starting material to assist my colleagues. Apex has a two-days developer guide for this purpose, and OWB has its fantastic OTN OBEs.

If you are already aware of the BI fundamentals and Oracle database fundamentals you can go through these 16 11g OWB OBEs within a day or two and than I am pretty sure you will get the feeling I mentioned. As you may know with 11gR1 now OWB and Apex are a part of the standard database installation, so if you have a 11g installation you already have an OWB practice environment, following the first OBE will be enough to initialize your OWB inside your 11g installation.

These OBEs do not only include typical practices but also information on Warehouse Builder 11g architecture, components, BI concepts like Star Schema and Snowflake Schema or Slowly Changing Dimensions. Also here is an additional viewlet which may give you an idea about OWB. Remember what actions you do inside your mappings they will all deploy a standart PL/SQL package, these old friends are your ETL executables for your each BI need. And OWB is a cost-free(database-licence included) option and it is a highly optimized ETL tool which uses Oracle’s SQL capabilities.

And as some readers may be thinking since Oracle bought ODI OWB will be dead soon, no this not true and you may read the future strategy from OWB’s corporate blog here, to my understanding OWB and ODI will be a part of a combined BI solution strategy together, like a coffee and milk together, so this is not a coffee or a tea choise :)

Leave a Comment »

No comments yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: