Re: dw tool question

>We have a new datawarehouse project. I didn't involve in this project at
>beginning. Right now, I was assigned to the group for picking a front
>end reporting tool. So far I know the manager prefer brio, cognos and
>business intelligent product.
>
>Does anyone familiar with those tools? Can you give me some feedback as
>dba standpoint of view, like how report distributed, power user vs end
>user, performance and security advange or disadvantage, concerns?

Me! Me! Pick me! (Oooh, a topic I can answer! :-)

If your manager likes Brio, then that is a plus. Brio is a good product for any reporting from simple to moderately complex. I've used it extensively and have always been impressed with how it is able to tackle tasks that seem to be out of their area of comfort. The tool has a nice Portal-like ability that uses JavaScript internally to allow fairly complex customization. They also have options for distributed reporting, push-vs-pull reporting, etc. About the only negative I've seen with Brio is that they locally cache the hypercube. Thus if you want your hypercube to be refreshed automatically, you either need their push technology or a different product. If that doesn't matter to you (and in fact, many see that as a plus, since it makes for easy static snapshots), then it works great. Obviously, their thin-client version does not store the hypercube locally. It may store it on the server, I'm not sure. Their pricing is "okay", and they do barter for lower prices.

As somone already pointed out, Business Objects is also a good choice for moderate to complex projects. In my mind, the biggest problem with BO is that it takes sooo long to get going with their stuff. You can get a simple portal up and going with a couple reports in Brio in a few days, without ever having touched their product before. Try that in BO and you'll be there for at least double the time. On the positive side, once you get proficient, BO scales a lot better, and can handle just about any reporting/DW needs you'll ever have. Price is about the same, and they too barter.

Crystal Analysis is definitely the price-point winner, and a lot of people know how to use Crystal Reports, so it makes getting skilled labor easier. Their product is definitely not as capable at the moderate-to-complex end, but for simple reporting it's about as easy as it comes. I've just never been able to trust Seagate all that much. They change their product names and offerings almost yearly, they don't give any warm fuzzies for continued existence of their products, and their pricing is haphazard and at the whim of whatever sales person you talk to. I hate that. Don't even ask me about the whole Crystal Info debacle or I'm going to get mad. ;-)

As a side note, I like (and have chosen) Sagent for data warehousing. It's more than just a reporting tool, since it does the ETL side of things, schema operations, automation, Portal-like functions, etc. But it's very powerful and blows the socks off of any piecemeal collection of software that does the same thing. And lest we forget, Sagent used to be the engine for Oracle's data warehousing solution as recently as two years ago, so even Oracle thinks highly of them.

One last thought: if TWDI has a conference coming up in your area, it's worth going to if you can get there. One of the presenters goes through a terrific in-depth evaluation of all the data warehousing tools on the market, including reporting tools. Some say it's worth the cost of the conference in what you save buying products.

Anyhow, hope that helps.

thanks,
bruce

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bruce A. Bergman
  INET: bruceb_at_fatcity.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).