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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Data Reporting tools
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Data Reporting tools
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Data Reporting tools
I haven't used them, but I know that WebFocus is supposed to do that sort of thing, and Cognos has a couple of tools for it. Dan -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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Data Reporting tools
Title: RE: Data Reporting tools Dick, I'd support Jacques and vote for BusinessObjects. Release 5ilooks really cool. BusinessObjects is less scalable compared to Cognus, but, I believe, less expensive also. I personally used BO 5, nice and robust product, but, it was not possible to include dynamic graphics (from db, for example). No problem to put a picture. Vadim Gorbounov, Oracle DBA -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 10, 2001 2:51 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Data Reporting tools -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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??? Would Web Intelligence from Business Objects suit your needs? http://www.businessobjects.com/products/webintelligence.htm I personally haven't used it but I talked to a DBA at a user group meeting who said it was great.
Re:RE: Data Reporting tools
What do you want, that I should call a spade a spade? ;-) Reply Separator Author: Paul Baumgartel [EMAIL PROTECTED] Date: 5/10/2001 11:26 AM Thanks, Dick, for writing I've been given a project... rather than I've been tasked -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Data Reporting tools
But with Crystal you have to know the links to the tables and sometimes the column names are not user friendly. -Original Message- Sent: Thursday, May 10, 2001 4:25 PM To: Multiple recipients of list ORACLE-L We are currently looks at a product named Crystal Reports from the company below, they seem to have a number of products along the lines of your query. http://www.crystaldecisions.com/ [EMAIL PROTECTED] - [EMAIL PROTECTED] on 5/10/2001 2:11 PM writes us: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Dawn White INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).