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@xxxxxxxxxxxx> wrote in message
news:TyhMh.269$6z3.73@xxxxxxxxxxx
"The ants are driving me crazy" <cwhankey@xxxxxxxxxxx> wrote in message
news:1174499639.696249.58320@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: [Info-Ingres] FW: Ingres Development Sprint, June 2009.
    ... Merging RW and SQL ... ... there are loads of open source query tools out there. ... Every day I work with Ingres, Oracle, SQL Server, ... The query tool I use is DbVisualizer, made by Minq Software out of Stockholm. ...
    (comp.databases.ingres)
  • Re: Best Oracle front end / Query tool for power users
    ... Easy for novice user, but has advanced user features (ie - you can ... Oracle Discoverer - Good for novice users only, ... Oracle SQL Developer - Shows great promise and it is free! ... Brio/ Hyperion - This is probably my favorite query tool. ...
    (comp.databases.oracle.misc)
  • Re: General SQL/ODBC question
    ... Download WinSQL from http://www.synametrics.com/winsql. ... > I am trying to teach myself SQL programming on my home PC using Windows XP ... > a driver and a connection to a database here in order to use the Query Tool. ... I do not think I have the 'database' required. ...
    (microsoft.public.sqlserver.odbc)
  • Crystal 10, Manually Changing, SQL Changes, Blank Report - bug?
    ... In Crystal 10, I have a report that runs well, but needs one more ... So I reloaded the original report that runs, and copied the SQL ... Crystal, and pasted it to my query tool, and it was broken. ... original SQL, and still broken. ...
    (microsoft.public.vb.crystal)
  • Re: SQL vs. OS/400 queries
    ... I've found the prompted mode of QM to be close enough to Query/400 for ... for SQL, but this approach was not optimal at all times for SQL. ... statement capability. ... Now if some new UI query tool were to come out to ...
    (comp.sys.ibm.as400.misc)
Loading