Re: Best Oracle front end / Query tool for power users

On Mar 21, 1:53 pm, "The ants are driving me crazy" <cwhan..._at_hotmail.com> wrote:
> What query tool / front end does everyone give to their users? My
> company is pushing the latest version of Discoverer, which is fine for
> novice end users. However, you can only join tables using the admin
> version, which is a problem for power users. I don't think I'm
> asking for much, but there does not seem to be any one tool that has
> everything I'm looking for, which is:
>
> - Easy for novice user, but has advanced user features ( ie - you can
> write your own SQL if you want to)
> - User can select and join any table they have permission for, without
> having to go thru IT.
> - Easy to deploy. Web-based would be nice.
> - Reasonably priced.
>
> Here is my analysis of the query tools that I've used. What is your
> opinion? Can you recommend some more?
>
> Oracle Discoverer - Good for novice users only, not for power users.
> Having to go thru an admin to add tables & joins is a huge negative.
> However, it is free. I think it's free.
>
> Oracle SQL Developer - Shows great promise and it is free! Too much
> for end users though.
>
> Oracle Browser - I don't think this is supported any more.
>
> SQL Plus - Power users & developers only.
>
> MS Access linked tables - Please don't flame me for this one! But it
> does work, is easy to use & everyone has it. The downside is the
> potential for horribly slow queries.
>
> Brio/ Hyperion - This is probably my favorite query tool. It has
> almost verything I want in a query tool. When we bought this tool a
> few years ago, however, the high end version was very pricey.

Discover regular users can use joins in their SQL as long as the Discover Administrator defined the join to Discoverer and makes it available to the user business areas.

HTH -- Mark D Powell -- Received on Thu Mar 22 2007 - 12:16:59 CDT