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

Terry,

Don't forget Excel, which is probably more widely used than Access. The visual query tool is good for novices and the SQL view provides more capabilities for power users.

• Bill

"Terry Dykstra" <tddykstra_at_forestoil.ca> wrote in message news:TyhMh.269$6z3.73_at_edtnps82...
> "The ants are driving me crazy" <cwhankey_at_hotmail.com> wrote in message
> news:1174499639.696249.58320_at_l75g2000hse.googlegroups.com...
>> 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.
>>
>
> InfoMaker is a pretty decent reporting tool.
>
> --
> Terry Dykstra
>
Received on Thu Mar 22 2007 - 16:57:05 CDT