AtanaSuite QueryTool

QueryTool

SQL Development Environment

QueryTool is included in the following products


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.

QueryTool Screenshots

Click on an image below to expand.

QueryTool Layout

SQL Helper

QueryTool Join Helper

Join Helper

QueryTool Named Params

Named Parameters

QueryTool Features

Some of the key features within AtanaSuite QueryTool

Feature
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!
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
Results Export
Export results to the most popular formats including Excel.
Feature
Explain Syntax Format and Highlight
Teradata Explain syntax formatting and highlighting to aid in quickly identifying potential query issues.
Feature
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.
Feature
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.
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
Multiple Execution Modes
Toggle between parallel and serial execution modes.
Feature
Visual Explain Integration
Just a click sends your SQL to Visual Explain.
Feature
Tool-to-Tool Integration
The AtanaSuite 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
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.
Feature
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.
Feature
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.
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
Recommend Statistics
Click a toolbar button or menu item to have Teradata recommend the statistics settings for the selected SQL.
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
Active Script and Server 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 execution and modification. Purchase AtanaSuite Active Server and take advantage of its centralized job repository, scheduling, execution, monitoring and reporting features.
Feature
Named Parameters
Use parameter token in SQL to have parameter value dialog displayed upon query execution.