March 15, 2012 at 6:30 am
Currently we use Showcase query as a query management tool. We like it because of its ease of use for creating queries and the ability to open up directly in excel. But we have found showcase query to become very outdate, and increasinly supported with many applications.
Can you recommend me any query management tools that are like Showcase Query?
March 16, 2012 at 11:20 am
Have you taken a look at Quest Softwares Toad?
I first used this tool at least 5 years ago when SQL Plus for Oracle sucked.
The tool has evolved to support a bunch of back end databases (SQL Server, etc).
However, it is developer / dba tool. It can do both simple and complex tasks.
So, if you do not like TSQL, you might not like it.
John Miner
Crafty DBA
www.craftydba.com
March 22, 2012 at 9:09 am
I don't know showcase, but Crystal reports is quite good for drag and drop queries.
If you are a Microsoft house (Sequel Server and/or Sharepoint) then it is worth learning SSRS (reporting services)There is a BIG difference between 2005 and 2008 versions and it is great (from a developer / power user perspective) for both ad-hoc and fixed user reports.
March 22, 2012 at 9:16 am
We use SSRS frequently here. What we are really looking for is query management software for our users who have no knowledge of SQL.
In showcase query, you get menu screens to select the database, choose the table, then choose the fields. If you choose two tables, it will automatically join it based on the first matching column name.
Then they can add the conditionals etc, then Showcase get the data based on all the info they put in the menu. Is that a query management tool? I am not sure..I dont know what its called.
March 22, 2012 at 5:27 pm
If you choose two tables, it will automatically join it based on the first matching column name.
so will most report generators including Crystal reports and Access. This normally means that the ID fields get linked if you have auto-increment fields as unique keys. If you are fortunate to be working in a database where referenial integrity and check contstraints have been properly defined you are very lucky!
you might also want to try QlikView. I have not used it personally but I know some big financial organisations swear by it. Once you have learned to use it's 'quirky' interface you can quickly produce all sorts of elegant report formats.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply