Re: GUI SQL Query tools (?) (Macintosh)

In article <2joe1k$8pn_at_larch.cc.swarthmore.edu>, R Glenn Stauffer <stauffer_at_cc.swarthmore.edu> wrote:
>We are running a system using an Oracle database. We would like to provide
>an "easy-to-use" query system for several administrators who are using
>Macintosh computers. I sat in on an Apple-Oracle demonstration about 1
>year ago (before we had a defined need) and saw some products that used
>the Oracle SQL*NET product to access the SQL database. One looked like a
>spreadsheet. Unfortunately, I have misplaced the literature that I
>received at the demo. Does anyone know where I can get electronic information
>on SQL front-end products? I'd also be interested in comments regarding
>these products and the ease of implementation, etc.
>

Two very good querying tools for Macintoshes (there are also Windows versions of these) are:

ClearAccess, from ClearAccess Corporation DataPrism, from Brio Technology

I've looked at both, and am more familiar with (and prefer) ClearAccess. A DB administrator can use it to create canned queries for inexperienced users, as well as do ad hoc queries. In a Mac environment, the results can be published to a network (through Apple's publish/subsribe technology), making all kinds of interesting reporting options available.

John Heckendorn

-- 
                                                             /\
BMUG                      ARPA: bmug_at_garnet.berkeley.EDU    A__A
1442A Walnut St., #62     BITNET: bmug_at_ucbgarne             |()|
Berkeley, CA  94709       Phone: (415) 549-2684             |  |