Oracle Warehouse Builder - what does the future hold?

View previous topic View next topic Go down

Oracle Warehouse Builder - what does the future hold?

Post  robber on Sat Feb 28, 2009 3:58 pm

I have a client implementing an analytic solution which uses OWB for ETL. I have concerns over OWB's future given the Sunopsis acquisition which they now call ODI (I think). Part of the appeal of OWB is it's low cost, I'm assuming that advantage will diminish as Oracle pushes ODI. Anyone else using OWB and concerned about it's future?

robber

Posts : 41
Join date : 2009-02-28
Location : Canada

View user profile

Back to top Go down

Re: Oracle Warehouse Builder - what does the future hold?

Post  DilMustafa on Sun Mar 01, 2009 2:56 am

Very valid concern. I recently downloaded ODI as well as DP,DQ component of the ODI. I do not think that there is any formal announcement from Oracle for one or another. I do see ODI closely tied to fusion middleware. I guess future versions of ODI are going to have best from OWB and Sunopsis, again this is my best guess.

DilMustafa

Posts : 49
Join date : 2009-02-03
Location : Calgary, Canada

View user profile

Back to top Go down

ODIEE

Post  ubethke on Sun Mar 01, 2009 5:13 am

There is a statement of direction by Oracle on this

http://www.oracle.com/technology/products/oracle-data-integrator/sod.pdf

Basically over the next couple of years the two products will merge and you will get the best of two worlds. There will be upgrade paths etc. for both products, so your investment will be secured whichever product you choose now.

uli @ www.business-intelligence-quotient.com

ubethke

Posts : 28
Join date : 2009-02-03

View user profile http://www.business-intelligence-quotient.com

Back to top Go down

Re: Oracle Warehouse Builder - what does the future hold?

Post  robber on Sun Mar 01, 2009 10:29 am

The SOD to merge the best features and functions into one product is good but at what cost? I'm not sure of the current pricing but I believe OWB is low cost or even included with the RDBMS?? I see there is an Enterprise version of OWB, what additional features does that include and at what sort of cost increment?

What does ODI cost now? I'm not looking for exact pricing but order of magnitudes, is it tier 1 pricing (100's K) like Informatica and Data Stage or is tier 2 pricing (say under 100K), or what I'll call tier 3 pricing like SSIS or OWB?

Rob

robber

Posts : 41
Join date : 2009-02-28
Location : Canada

View user profile

Back to top Go down

Re: Oracle Warehouse Builder - what does the future hold?

Post  ubethke on Mon Mar 02, 2009 7:54 am

http://www.oracle.com/corporate/pricing/technology-price-list.pdf

As far as I see it is 23 K per processor on target DW plus around 5K support

Of course, this is before any discounts are applied, which you should get in the current climate...

ubethke

Posts : 28
Join date : 2009-02-03

View user profile http://www.business-intelligence-quotient.com

Back to top Go down

Re: Oracle Warehouse Builder - what does the future hold?

Post  robber on Mon Mar 02, 2009 9:42 am

Thanks for that.
I noticed OWB was not listed, is it considered part of the enterprise database product?

robber

Posts : 41
Join date : 2009-02-28
Location : Canada

View user profile

Back to top Go down

Re: Oracle Warehouse Builder - what does the future hold?

Post  ubethke on Mon Mar 02, 2009 11:20 am

As far as I know OWB core is licensed as part of Oracle Enterprise Edition.

There used to be three separate OWB Enterprise options around Data Quality, Connectors to ERP systems, and I think advanced features such as SCD2 support and use of Control Centres in deployment. Apart from the connectors these have disappeared from the price list, so I presume you don't need a separate license for them anymore.

I would check with your local Oracle sales guy. He should know. All this licensing is a bit like rocket science. I remember in one of my workplaces we had a consultant just dedicated to advise clients on Oracle licensing... The devil is in the detail here.

uli

ubethke

Posts : 28
Join date : 2009-02-03

View user profile http://www.business-intelligence-quotient.com

Back to top Go down

Re: Oracle Warehouse Builder - what does the future hold?

Post  robber on Mon Mar 02, 2009 11:37 am

Uli, Excellent feedback much appreciated. Have you used both OWB and ODI in anger?
Aside from cost how would you compare the two?

Rob

robber

Posts : 41
Join date : 2009-02-28
Location : Canada

View user profile

Back to top Go down

Re: Oracle Warehouse Builder - what does the future hold?

Post  ubethke on Mon Mar 02, 2009 12:02 pm

I have used both, but ODI not in action (just for an internal pilot).

Both are very good products. I really like the whole E-LT approach. All your transformations are transparent in SQL & PL/SQL. So you don't have to upskill here on some proprietray language etc. Also you don't have to purchase a separate server, as your ETL tool sits on top of your DW server(s). From a performance point of view SQL will always beat some proprietary language as it was written to deal with huge data sets.

If you are an Oracle only shop I would recommend OWB.

However, if you are in a heterogenuous environment where you need to extract from different source technologies I would go for ODI. The problem with ODI at the moment is that documentation is very thin and you won't find many skilled people. So you will pay exorbitant rates.

ubethke

Posts : 28
Join date : 2009-02-03

View user profile http://www.business-intelligence-quotient.com

Back to top Go down

upgrade

Post  Rik Declercq on Fri Mar 06, 2009 8:57 am

I hope they do a better job then BusinessObjects. There first integrated BO-Crystal product (XI) is a nightmare for BO users to upgrade to.

Rik Declercq

Posts : 10
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Oracle Warehouse Builder - what does the future hold?

Post  ubethke on Tue Mar 10, 2009 1:34 pm

Where in your BOBJ upgrade did you have issues?

ubethke

Posts : 28
Join date : 2009-02-03

View user profile http://www.business-intelligence-quotient.com

Back to top Go down

BOBJ

Post  Rik Declercq on Mon Mar 16, 2009 4:41 am

ubethke wrote:Where in your BOBJ upgrade did you have issues?
They completely changed the security model, making it more flexible but also more complex. This combined with a poor management interface made the upgrade very hard (should be better in the new version). Also, it is nearly impossible to get info out of the metadata repository.

Rik Declercq

Posts : 10
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Oracle Warehouse Builder - what does the future hold?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum