AtanaSuite QueryTool

QueryTool

SQL Query Development

QueryTool is included in the following subscription product


QueryTool is an advanced SQL query development environment! It is packed with more features than any other SQL query product. Check out the Features section below and we think that you will agree. Better yet, download a free trial and see for yourself!

SQL syntax coloring simplifies SQL writing and debugging, while QueryTool's SQL Helper lets you build SQL statement templates quickly and effortlessly! Just drag an object into the SQL Editor, select a SQL command and your query is written instantly!

QueryTool's graphical interface allows you to view your data in the most convenient and user friendly way possible! Dockable windows let you decide what you want to see, where you want to see it and when! Other features such as split-screen viewing, multiple column drag and drop and dynamic grouping provide even more flexibility for viewing your result sets.

QueryTool Screenshots

Click on an image below to expand.

QueryTool Layout

SQL Helper

QueryTool Results

Results

QueryTool Named Params

Named Parameters

QueryTool Features

Some of the key features within QueryTool

Feature
SQL Formatting
Consistent, customizable formatting that can instantly beautify the ugliest SQL mess.
Feature
Tabbed SQL Editor Windows
Work with multiple SQL statements in separate tab windows and customize the SQL editor and related controls for each. Quickly switch between these windows by clicking on the tab.
Feature
Color-coded SQL Syntax
Editable SQL syntax coloring preferences to enable user control over SQL display within the SQL editor.
Feature
Find/Replace
Quickly locate and edit SQL using a complete find/replace dialog.
Feature
Dockable Windows
Pin, unpin, hide and mouse over type features provided for complete customization of your SQL editing environment. Setup your work environment to work with you!
Feature
Advanced Results Display
User customizable multi-column pinning, hiding, grouping, filtering, sorting, re-sizing and re-ordering to enable easier results viewing and analysis.
Feature
Other Advanced Editor Features
From block selection to tab and space conversion is also provided to enhance SQL editing capabilities.
Feature
Automatic Outlining
As well as manual override settings to enable easier viewing and editing of long and detailed SQL statements.
Feature
Visual Explain Integration
Just a click sends your SQL to Visual Explain.
Feature
Tool-to-Tool Integration
The DataGEM environment is designed to help get you to the right tool for the job by providing toolbar buttons that enable context aware loading of information from one tool to another.
Feature
Active Script Enabled
Save commonly executed SQL, DDL, DCL, DML and related statements as an Active Script job that can be opened later within JobTool for execution and modification. Use Desktop Scheduler to schedule job execution so DataGEM can work even while you are away!
Feature
SQL Helper
Common object and attribute information browsing with drag-n-drop instant SQL command generation.
Feature
SQL Editor Display Settings
Line numbering, word wrap, whitespace, and column guide settings.
Feature
Bookmarks
Tag commonly viewed or accessed portions of SQL within the editor for fast and easy identification and navigation.
Feature
Split Window SQL Editor
Split the SQL editor and navigate to different portions of SQL with ease.
Feature
History Filter
Control executed SQL statement display, even add notes or execute again with ease.
Feature
Named Parameters
Use parameter token in SQL to have parameter value dialog displayed upon query execution.
Feature
Results Export
Export results to the most popular formats including Excel.