ScriptTool

ScriptTool

Utility Script Development Environment

ScriptTool is included in the following products


AtanaSuite's ScriptTool allows you to quickly create Teradata client scripts using an intuitive smart editor with wizard dialogues. ScriptTool supports Teradata BTEQ, FastLoad, FastExport, MultiLoad, Tpump and ARC scripting languages.


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

ScriptTool's intuitive user interface provides for easy selection of a variety of Teradata client scripts to create.

ScriptTool's syntax-directed editor features color-coded highlighting of grammar. The Script Helper makes it easy to find language elements and database objects for use in your scripts. The script builder dialogs make creating and modifying scripts a snap! The script builder wizards make creating new scripts fast and easy. The File Explorer makes saving, locating and retrieving your scripts easy and fun!

ScriptTool provides syntax dialogs for each language element of a client script. It also provides wizards for easy script creation. As the script is developed, it is displayed in the edit panel. To the right of this panel is a script helper that provides access to database objects and script language elements. Below the edit panel is a script console used to display the results of running your scripts. To the left of the edit panel is a file explorer used to find and open existing scripts.

ScriptTool Screenshots

Click on an image below to expand.

ScriptTool

ScriptTool

ScriptTool Features

Some of the key features within AtanaSuite ScriptTool

Feature
Utility Script Development Environment
Develop, execute, test and save Teradata ARC, BTEQ, FastExport, FastLoad, Multi-Load and Tpump scripts within this feature rich scripting environment. Includes drag-n-drop instant SQL and script command generation, script wizards, script builders and more to make developing and testing utility scripts a snap! AtanaSuite Active Script and Active Server enabled!
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
The Ultimate Teradata Script Editor
A complete, very sophisticated Teradata script editor with AtanaSuite IntelliSQL and other advanced editing features like colored syntax highlighting, formatting, line numbers, bookmarks, automatic outlining and more.
Feature
SQL Formatting
Consistent, customizable formatting that can instantly beautify the ugliest SQL mess.
Feature
Split Window Script Editor
Split the script editor and navigate to different portions of script with ease.
Feature
Script Wizards
Fill in the blanks to create FastLoad, FastExport, MultiLoad and TPump scripts for the selected table.
Feature
File Explorer
Provides access to local store of scripts with directory browsing features.
Feature
Script Console
Test scripts and view script execution output.
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
Teradata Script Development Environment
Integrated work environment for creating, editing and testing ARC, BTEQ, FastLoad, FastExport, MultiLoad and TPump scripts.
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
Script Map
Instantly updated, collapsible keyword, context aware outline of BTEQ script editor information that provides easier navigation of even the most complex BTEQ code. Select an script map node and have it instantly highlighted in the corresponding BTEQ script editor.
Feature
Other Advanced Editor Features
From block selection to tab and space conversion is also provided to enhance SQL editing capabilities.
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
Color-coded Script and SQL Syntax
Editable script and SQL syntax coloring preferences to enable user control over script display within the script editor.
Feature
Automatic Outlining
As well as manual override settings to enable easier viewing and editing of long and detailed BTEQ code.
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
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
Script Helper
Common object and attribute information browsing with drag-n-drop instant SQL, DDL and script command.generation that is the perfect complement to AtanaSuite IntelliSQL.
Feature
Script Builders
Wizard functionality provided for multiple tables to quickly create FastLoad, FastExport, MultiLoad and TPump scripts for an entire database.
Feature
Preview Script
Use simple point and click dialogs to create script commands and view the script syntax necessary to perform the task as you work. Learn Teradata script languages as you work!
Feature
Script Editor Display Settings
Line numbering, word wrap, whitespace, and column guide settings.
Feature
Tabbed Script Editor Windows
Work with multiple scripts in separate tab windows and customize the script editor and related controls for each. Quickly switch between these windows by clicking on the tab.
Feature
Find/Replace
Quickly locate and edit script code using a complete find/replace dialog.
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
Bookmarks
Tag commonly viewed or accessed portions of script within the script editor for fast and easy identification and navigation.