Image

QueryTool

Teradata and ODBC SQL Development Environment

Available in

AtanaSuite's QueryTool with IntelliSQL® is the ultimate Teradata SQL development environment! It is packed with more features than any other Teradata SQL 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! Export SQL to Visual Explain™ with the click of a button.

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.

Tool Screenshots

Screenshots of QueryTool in action.

Key Features

Some of the key features found in QueryTool.

QueryTool Screenshots

Click on an image below to expand.

Image

SQL Helper

Image

Join Helper

Image

Named Parameters

QueryTool Features

Some of the key features within QueryTool.

IntelliSQL®
Context aware Teradata statement, keyword, function and database aware dropdowns and tooltips that intelligently guide users in the creation and completion of even the most complex Teradata SQL statements. Built-in syntax error checking as you type to prevent the endless, wasted cycles of syntax checking via execution. It's like having a Teradata professional at your fingertips!
SQL Formatting
Consistent, customizable formatting that can instantly beautify the ugliest SQL mess.
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.
Color-coded SQL Syntax
Editable SQL syntax coloring preferences to enable user control over SQL display within the SQL editor.
Find/Replace
Quickly locate and edit SQL using a complete find/replace dialog.
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!
Advanced Results Display
User customizable multi-column pinning, hiding, grouping, filtering, sorting, re-sizing and re-ordering to enable easier results viewing and analysis.
Results Export
Export results to the most popular formats including Excel.
Explain Syntax Format and Highlight
Teradata Explain syntax formatting and highlighting to aid in quickly identifying potential query issues.
Macro Support

Record a keystroke macro for use in duplicating a repetitive keyboard task quickly and easily.

Join Helper
Intuitive GUI used to represent, organize and simplify the most common aspects associated with join development while providing instantaneous feedback and support throughout the entire process. Tight integration with other key AtanaSuite technologies like IntelliSQL and AtanaSuite Relationships enhances and automates the process which helps to eliminate errors and promote company standards.
SQL Map
Instantly updated, collapsible keyword, context aware outline of SQL editor information that provides easier navigation of even the most complex statements. Select a SQL Map node and have it instantly highlighted in the corresponding SQL editor.
Other Advanced Editor Features
From block selection to tab and space conversion is also provided to enhance SQL editing capabilities.
Automatic Outlining
As well as manual override settings to enable easier viewing and editing of long and detailed SQL statements.
Multiple Execution Modes
Toggle between parallel and serial execution modes.
Visual Explain Integration
Just a click sends your SQL to Visual Explain.
Tool-to-Tool Integration
The AtanaSuite environment is designed to help get you to the right tool for the job by providing toolbar buttons and context menus that enable context aware loading of information from one tool to another.
SQL Objects
Instantly updated, collapsible query object list that provides concise list of objects for even the most complex statements. Select a SQL Objects item and have it instantly highlighted in the corresponding SQL editor.
Snippets

Snippets are user created portions of SQL or text that may be inserted into the SQL editor window. Expansion and Surrounds With type snippets are supported. Include tokens for additional customization at insertion time.

AtanaSuite Relationships
Define, display and utilize user-defined relationship and join path information standards for your warehouse. Immediately recognize and automatically use this information within SQL Helper and Join Helper.
SQL Helper
Common object and attribute information browsing with drag-n-drop instant SQL and DDL command generation that is the perfect complement to AtanaSuite IntelliSQL.
SQL Editor Display Settings
Line numbering, word wrap, whitespace, and column guide settings.
Bookmarks
Tag commonly viewed or accessed portions of SQL within the editor for fast and easy identification and navigation.
Recommend Statistics
Click a toolbar button or menu item to have Teradata recommend the statistics settings for the selected SQL.
Split Window SQL Editor
Split the SQL editor and navigate to different portions of SQL with ease.
History Filter
Control executed SQL statement display, even add notes or execute again with ease.
Active Script Enabled
Save commonly executed SQL, DDL, DCL, DML and related statements as an AtanaSuite Active Script job that can be opened later within JobTool for scheduling, execution and modification.
Named Parameters
Use parameter token in SQL to have parameter value dialog displayed upon query execution.
Database and Object Favorites

Easily maintain databases and objects to a favorites list. Quickly switch from viewing all objects to favorites only.

© 2002-2024 Atanasoft LLC.