Re: Query tools for end users? Opinions?

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1996/01/07
Message-ID: <4cpg4u$193_at_ixnews8.ix.netcom.com>#1/1


Richard Ramirez <ou79138_at_deere.com> wrote:

>We are using Esperant with mixed success. The tool seems very
>promising. With a few points and clicks, users can build a query
>and print the results or export the output to a Windows file.
>Queries can be batched to release the terminal. Esperant provides
>ODBC and native Oracle drivers.
 

>Esperant also provides "views" that let you simplify the Oracle
>schema. I expect to try them soon. The idea is to reduce the
>number of tables and let Esperant create the SQL for the joins.
 

>Response is mixed. Some people like it, others see it just as
>difficult as other tools. We don't have enough experience in
>the user community to make a final judgment.
 

>We also try MS Query both directly and from MS Excel. A nice
>thing is that you build the query visually by dragging column names
>to tables.

Does it let an administrator predefine how tables are joined? What about multiple join conditions between the same two tables? (I.E. two foreign keys going to the same parent table)

--
Chuck Hamilton
chuckh_at_ix.netcom.com

If at first you don't succeed, sky-diving isn't for you.
Received on Sun Jan 07 1996 - 00:00:00 CET

Original text of this message