Re: Data Reporting tools

Dick,

Go with Discoverer. As the admin, you can build a subset of the data and push it out to the power users with the data labeled any way you like. You can also give you power users the ability to create their own views if you are so inclined. They accomplish this through the GUI, with no 'direct' access to the database (of course they do, you need to set up their permissions etc., but you can lock it down pretty tight and what they're really creating is data about data which you can excise without harm to your DB at any time). Training is a snap, the interface is familiar and fairly intuitive, particularly for those with Access/Excel skills and experience. I used Discoverer for our Engineering teams to access Remedy (ugh!) data. Crystal Reports was the 'preferred' solution by the vendor, who wanted to send 20+ people to user training for a week to get them up to speed. The Discoverer solution was much simpler and more cost-effective for all involved. They were quite proud of their ability to create ad-hoc reports, and very lavish with their praise of the 'support' they were getting from the DBA!

Regards,

David A. Barbour

"Ruiz, Mary A (CAP, CDI)" wrote:
>
> Hi Dick:
> I have a similar project on my plate. I like Business Objects. Actually, we do
>not want users to have to know table/column names and need a product where we can
>build a data
> repository. I am not sure if we need a complete end-to-end solution as many BI
>companies seem ready to provide. Other vendors on our short list are - Oracle
>(Discoverer), Cognos,
> Brio, Informatica (not sure if we need it) and Sagent (has a nice ETL product).
>
> Mary Ruiz /Atlanta
>
> -----Original Message-----
> Sent: Thursday, May 10, 2001 2:11 PM
> To: Multiple recipients of list ORACLE-L
>
> To ALL,
>
> I've been given a project to find a way to make data easily available to end
> users, preferably via a thin client (read that as browser based). We're looking
> at Discoverer 3000 and 9iAS, but the boss wants to know what other options are
> out there. The general idea would be to have a client/server based tool that we
> could deploy to the power users (of which we have only a few). These
> individuals are NOT programmers nor in the IS group, but they know the data. We
> want them to create the queries/reports (with graphics included which the
> Discoverer viewer does not do) and then publish them via the database. This is
> a lot of what Discoverer does, but are there other tools out there that do the
> same? Any recommendations???
>
> Dick Goulet
> Senior Oracle DBA
> Vicor Corporation
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruiz, Mary A (CAP, CDI)
> INET: Mary.Ruiz_at_gecapital.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: dbarbour_at_nucentrix.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).