Teradata Utility Script Development Environment

Available in

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.

Tool Screenshots

Screenshots of ScriptTool in action.

Key Features

Some of the key features found in ScriptTool.

ScriptTool Screenshots

Click on an image below to expand.



ScriptTool Features

Some of the key features within ScriptTool.

Badge ImageUtility 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!
Badge ImageIntelliSQL®
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!
Badge ImageThe 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.
Badge ImageSQL Formatting
Consistent, customizable formatting that can instantly beautify the ugliest SQL mess.
Badge ImageSplit Window Script Editor
Split the script editor and navigate to different portions of script with ease.
Badge ImageScript Wizards
Fill in the blanks to create FastLoad, FastExport, MultiLoad and TPump scripts for the selected table.
Badge ImageFile Explorer
Provides access to local store of scripts with directory browsing features.
Badge ImageScript Console
Test scripts and view script execution output.
Badge ImageDockable 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!
Badge ImageTeradata Script Development Environment
Integrated work environment for creating, editing and testing ARC, BTEQ, FastLoad, FastExport, MultiLoad and TPump scripts.
Badge ImageJoin 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.
Badge ImageScript 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.
Badge ImageOther Advanced Editor Features
From block selection to tab and space conversion is also provided to enhance SQL editing capabilities.
Badge ImageSQL 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.
Badge ImageColor-coded Script and SQL Syntax
Editable script and SQL syntax coloring preferences to enable user control over script display within the script editor.
Badge ImageAutomatic Outlining
As well as manual override settings to enable easier viewing and editing of long and detailed BTEQ code.
Badge ImageActive 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.
Badge ImageAtanaSuite 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.
Badge ImageScript 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.
Badge ImageScript Builders
Wizard functionality provided for multiple tables to quickly create FastLoad, FastExport, MultiLoad and TPump scripts for an entire database.
Badge ImagePreview 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!
Badge ImageScript Editor Display Settings
Line numbering, word wrap, whitespace, and column guide settings.
Badge ImageTabbed 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.
Badge ImageFind/Replace
Quickly locate and edit script code using a complete find/replace dialog.
Badge ImageTool-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.
Badge ImageBookmarks
Tag commonly viewed or accessed portions of script within the script editor for fast and easy identification and navigation.


AtanaSuite is a proven leader in development, management, query, visualization, compression and synchronization productivity products for popular databases including Teradata and Vantage!