OraFAQ Forum: Client Tools » End user query tools

Home » Other » Client Tools » End user query tools (DB 12.x)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

End user query tools [message #653362]

Mon, 04 July 2016 02:38

John Watson
Messages: 8978
Registered: January 2010
Location: Global Village

Senior Member

A client has asked if I can recommend any query tools for running reports against a small data warehouse type database: tools that don't need much knowledge of SQL. Furthermore, not tools provided by Oracle BI: they are looking for something cheap. I think the idea is that the tool should present users with lists of tables and columns and let them construct the queries interactively, perhaps using a wizard.
I am aware that this sort of thing is fraught with problems. We'll have to create views that present the information in a meaningful way. Performance may be an issue. Security and data masking. And so on.

Any suggestions?

Thank you for any insight.

Report message to a moderator

Re: End user query tools [message #653364 is a reply to message #653362]

Mon, 04 July 2016 02:58

Michel Cadot
Messages: 68760
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe you can find what you want in our Freeware, Shareware or Third-party products wiki pages.
Don't take care about "latest version", I have not updated them for years.

Report message to a moderator

Re: End user query tools [message #653367 is a reply to message #653364]

Mon, 04 July 2016 04:08

Michel Cadot
Messages: 68760
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I updated "latest version" for Freeware and Shareware. Many of the later ones no more exist or became commercial products and many were not updated since a decade. Freeware are more followed.

Report message to a moderator

Re: End user query tools [message #653368 is a reply to message #653367]

Mon, 04 July 2016 04:10

John Watson
Messages: 8978
Registered: January 2010
Location: Global Village

Senior Member

Thank you, I'm looking at some of them now.

My suggestion that they could use SQL*Plus as the query tool did not go down very well.

Report message to a moderator

Re: End user query tools [message #653369 is a reply to message #653368]

Mon, 04 July 2016 04:22

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How about Apex?

(I'm not surprised they didn't like the SQL*Plus idea. It is everything but user-friendly to such end users).

Report message to a moderator

Previous Topic:	Toad 11 comment code option
Next Topic:	Input truncated to 1 characters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 19 12:36:51 CDT 2025