ObjectTool

ObjectTool

Advanced Database Object Development Environment

ObjectTool is included in the following products


AtanaSuite's ObjectTool allows you to quickly create Teradata executable objects using an intuitive smart editor with wizard dialogues. ObjectTool supports the development and testing of views, macros, triggers, procedures, user-defined functions and external procedures.

ObjectTool offers numerous advanced browsing features such as split-screen viewing, multiple column drag and drop, dynamic grouping and more!

ObjectTool's intuitive user interface provides for easy selection of a variety of executable database objects to create.

ObjectTool's syntax-directed editor features color-coded highlighting of grammar. The Object Helper makes it easy to find existing database objects and use them as templates for creating new objects. The log show the results of compiling and running your objects. The properties panel allows you to name your objects and maintain other object-specific attributes!

ObjectTool provides a tabbed edit panel allowing multiple objects to be open at once. To the right of this panel is an object helper panel providing access to existing database objects and supported language elements. Below these panels is a log panel (used to display the results of building and executing your objects) and a properties panel (used to show name, owner, comment and other object-specific attributes).

ObjectTool Screenshots

Click on an image below to expand.

ObjectTool

ObjectTool

ObjectTool Features

Some of the key features within AtanaSuite ObjectTool

Feature
Advanced Object Development Environment
Develop, execute, test and save Teradata views, macros, stored procedures, triggers and user-defined functions within this feature rich development environment. Includes drag-n-drop instant SQL, DDL and SPL command generation, IntelliSQL and color syntax highlighting to make object development a snap! Use Access View Builder to instantly generate access views for an entire database.
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
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
Tabbed Object Editor Windows
Work with multiple objects in separate tab windows and customize the object editor and related controls for each. Quickly switch between these windows by clicking on the tab.
Feature
Object Helper
Common object and attribute information browsing with drag-n-drop instant SQL, DDL and SPL command generation that is the perfect complement to AtanaSuite IntelliSQL.
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
Object Map
Instantly updated, collapsible keyword, context aware outline of object editor information that provides easier navigation of even the most complex statements. Select an Object Map node and have it instantly highlighted in the corresponding object 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
Build Log and Messages
Displays object build and execution messages.
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
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
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
Teradata Object Development Environment
Integrated work environment for creating, editing and testing views, macros, triggers, stored procedures, functions and external procedures.
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
Object Properties
Name, owner, comment and related information displayed within easily editable object properties window.
Feature
Object Explorer
Provides instant access to objects within the selected database. Double-click an object to have it retrieved and opened in the object editor.
Feature
File Explorer
Provides access to local store of objects with directory browsing features.
Feature
View Builder
Instantly generate access views for an entire database by simply selecting the tables and view preferences and letting View Builder do the rest.
Feature
The Ultimate Teradata Object Editor
A complete, very sophisticated Teradata SQL editor with AtanaSuite IntelliSQL and other advanced editing features like colored syntax highlighting, formatting, line numbers, bookmarks, automatic outlining and more.