| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Query Tool
Dennis,
You are absolutely correct. These users know nothing of SQL and will probably never be able (due to lack of interest) to do more than change search parameters in queries that I write and provide to them.
They need access to Oracle to validate the transfer of data from IMS on the mainframe (their home planet) to Oracle. We are very sensitive to keeping this thing simple and may wind up creating custom forms for them to use (with one big button).
You last comment was interesting though, but I am already on the hook to make the recommendation AND to train them.
Thanks,
Mike
-----Original Message-----
Mike - One critical question - Will you be creating reports for the users or
will they be creating the reports by themselves? We have had a lot of
trouble where IS would buy a query or reporting tool with the idea that the
users would be self-sufficient. Then it turns out that IS uses the tool.
Actually SQL was originally created as a user query interface. How many
users do you see today creating their own SQL statements? Sorry to be
cynical, but we've gotten bitten on that one before. This last time IS
stayed out of it, let the users pick their own tool, the users got the
training and no IS people were trained. It seems to be working pretty good.
Dennis Williams
-----Original Message-----
Sent: Tuesday, February 26, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
Sent: Tuesday, February 26, 2002 8:13 AM
To: Multiple recipients of list ORACLE-L
Mike,
There are a lot of tools like that on the market. My favorite for
several
years was Discoverer or Oracle Browser as it was then known. Recently
though
I've switched camps to Brio One from Brio Technology. Reason, Discoverer is
part & parcel with 9IAS Enterprise & that product is an unstable pig (CPU &
Disk). Had it here for a month late last year. Even the Oracle consultant
could not get it installed & working. Took a long night & ton of reading
plus
help from OTS & then we could only get it to work on Netscape.
Dick Goulet
____________________Reply Separator____________________ Author: Bond Mike A Contr OC-ALC/TILC <Mike.Bond_at_tinker.af.mil> Date: 2/25/2002 2:48 PM
Hi,
I was asked to recommend a Query Tool for some of our end users. I have
used Q+E aka DataDirect Explorer for years. Now I can't find it on the
internet. It has changed owners many times and may not even be available
now.
Does any one have a recommendation for a COTS product that allows the user with minimum knowledge of SQL to create SQL queries, views tables, store/recall queries, ...
Is there an Oracle product that does that? Discoverer seems to be a bit heavy handed.
Thanks,
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bond Mike A Contr OC-ALC/TILC
INET: Mike.Bond_at_tinker.af.mil
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).
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).
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).
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). Received on Tue Feb 26 2002 - 13:18:24 CST
 |
 |