Hi d90.nas/All,

d90.nas makes the point quite well...when moving between EDW datab ases it is not the front end that is the problem it is the back end. The ETL to populate the thing.

As newer, faster, cheaper databases come out, my opinion is, companies are

well advised to give up a bit of the 'our database only' features to be able to move to a "newer, faster, cheaper database" if it is well cost justified.

In recent times we have seen numerous very promising technologies that can

dramatically cut the cost of owning large EDWs.....in my direct experience Sybase IQ is one of those.....the ability to migrate to it quick ly and easily would save many an oracle EDW client a lot of money. But in many cases the cost of migration seems to outweight the benefits of IQ...

..and I

am sure Oracle are pleased with the number of clients who tied themselves to the database by the use of OWB or PL/SQL in the ETL layer...

Another one that is showing great promise now is MySQL 5.0....an

d the

ability of many an SQL Server EDW client to migrate painlessly to MySQL 5.

0

would also assist those companies to save some money I would think...

....We

have been able to run our ETL software on MysQL 5.0 and we are currently

testing our new BI product across to MySQL....the results are stil

l out on

that one though....but so far MySQL 5.0 seems to be very promisi

ng indeed...

I would be very interested to hear other peoples experiences around MySQL

5.0 for smaller EDWs...both good and bad...

Best Regards

Peter

Original Message:

-----------------

From: d90.nas via dw-select dw-select@Groups.ITtoolbox.com

Date: Wed, 2 Aug 2006 17:54:10 -0400

To: peter@peternolan.com

Subject: Re: Fwd: Re: [dw-select] BI Solutions on different databases

I would be personally concerned about the move that Oracle is making

on the application world.... We have yet to see a company really

succeed on both sides "platforms" and "applications". All the one that

tried that move had to refocus.

I wish them the best, but I will not take that risk for my corporation

until I am really sure they are going in the right direction....

Here, we are using MicroStrategy, we switched most of our projects

from DB2/400 to Teradata, we are also looking into Netezza and to this

day, the move was painless on the MicroStrategy side (which is good,

because that's what the end-user see..... and I don't want the e

nd

user to complain, too hard to get them back on track otherwise), but

very painful on the ETL side (hand-coded functions on the AS/400

side.....).

On 8/2/06, mmadsen... via dw-select <dw-select@groups.ittoolbox.

com> wrote:

> If you want a good overview of Oracle's BI Enterprise

> Edition, Mark Rittman did a great job at

>

uite_ent.html

>

> This might also help if you are deciding whether to

> package up a BI offering built on Oracle's tools. WIth

> this package, I'd be less concerned about portability

> and more with whether you see a viable market for

> reuse of what you packaged.

>

> Mark