Re: suggestions for good graphical DB query builder
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 20 Sep 2007 15:19:28 -0700
Message-ID: <1190326757.633122_at_bubbleator.drizzle.com>
>> We're doing a product comparison for graphical query builders. Would
>> appreciate
>> your input on what you like (or don't).
>>
>> We're an Oracle shop, but we need connectivity w/ any ODBC compliant
>> DB.
>> Also need query result export options (esp Excel), pivot capability,
>> printable results,
>> Windows compliant.
>>
>> We don't need write capability, and if the tool has it, we need
>> to be able to turn it off. DB Admin tools not needed.
>>
>> I've heard great things about AQT (Advanced Query Tool)... comments?
>>
>> Thanks,
>> Carol
Date: Thu, 20 Sep 2007 15:19:28 -0700
Message-ID: <1190326757.633122_at_bubbleator.drizzle.com>
carol_marra_at_msn.com wrote:
> On Sep 18, 1:37 pm, carol_ma..._at_msn.com wrote:
>> We're doing a product comparison for graphical query builders. Would
>> appreciate
>> your input on what you like (or don't).
>>
>> We're an Oracle shop, but we need connectivity w/ any ODBC compliant
>> DB.
>> Also need query result export options (esp Excel), pivot capability,
>> printable results,
>> Windows compliant.
>>
>> We don't need write capability, and if the tool has it, we need
>> to be able to turn it off. DB Admin tools not needed.
>>
>> I've heard great things about AQT (Advanced Query Tool)... comments?
>>
>> Thanks,
>> Carol
> > Any other comments here? Yes, I know there are limitations, but I > do agree it's unlikely that any of our users will hit them.
Then train your users.
If your users are so inexperienced with SQL that they can only write basic statements, and likely poorly tuned ones, you are doing them and your organization no favor.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Sep 21 2007 - 00:19:28 CEST