Re: Ad Hoc Query Tools
Posted in 1997
Topics: SQL Development & Query Writing, Server Administration, Java & JDBC Development
The users are used to using Microsoft Access, and want the ability to
build queries through a drag and drop GUI. The database tables
(approximately 75 of them) are small, under a thousand rows in most
cases, and with a 2K row size. One table will be 500,000 rows, with a
2K row size.
Ideally the tool would be a Java applet. I've looked at a tool from
Xense called DBPublisher. Does anyone have experience with that? Tools
that produce HTML pages are also desirable. The tool should be able to
produce aggregate information, as well as do joins and produce reports
in certain user-specified date ranges.
Thanks for your help.
-Clay Amerault
Alton B. Coalter wrote:
>
> Clay Amerault wrote:
> >
> > Does anyone have any recommendations for an ad hoc query tool for
> > Informix 7.2. Is Crystal Reports any good?
> >
>
> Yeah. Try dbaccess or isql.
>
> Without more requirements (user base, needs, output
> formatting requirements, etc) we can't do much for you.
>
> -/Renegade