Ad Hoc Query Tools

[Clay Amerault]

Does anyone have any recommendations for an ad hoc query tool for
Informix 7.2. Is Crystal Reports any good?

I've looked at DB Publisher from Xense. Are there any other Java ad hoc
reporting tools out there?

Thanks for your help.

-Clay Amerault

[Alton B. Coalter]

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

[Clay Amerault]

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]

Clay Amerault wrote:
>
> 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. [...]

Ahh, thanks for the clarification. With this, there are many
out there on the market today. All of them, no matter what they
say require the user to have some knowledge of databases and how
the data goes together (so that someone doesn't make a request
that generates a humongously slow query that blocks out other
processing, for instance).

Crystal Reports is a very popular product at this time for
what you want, but I don't know if it has anything to do with
java in its current incarnation. I have found that in most of
these products, you get what you pay for.

-/Renegade

[Jason Bodnar]

In article <33E60356...@frankfurtbalkind.com>,

Clay Amerault <came...@frankfurtbalkind.com> wrote:
>
> 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.

So let them use Access. Openlink Software has an ODBC suite that will let
you connect to databases in Access. You can make the connections
read-only and you won't have to worry about people destroying your data.
They've got different packages for either unlimited clients or unlimited
connections (or something like that). Goes for about $500.

-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet