AtanaSuite Enterprise
AtanaSuite Enterprise is truly the ultimate development and management productivity suite for Teradata. Over 20 different tools, wizards, builders and helpers are integrated into a common and consistent desktop application that is designed to ease and speed Teradata database management and development. It is used by more DBA's and development professionals than any other commercially available productivity product for Teradata.

Tools

AtanaSuite Enterprise contains the following tools. Click on a tool to get additional information.

Table Data Comparison

Database Object Relationship Information

Utility Script Development Environment

Database Object Comparison

AtanaSuite Active Script Job and Run Management

SQL Development Environment

Advanced Database Object and Data Copy

Advanced Database Object Development Environment

Simple Database Object and Data Copy

Database Object Search

Table and View Join Development Environment

Database Object Information and Management

Table and View Data Search

Role and Profile Information and Management

Table and View Data Browser and Editor

Warehouse Data Visualization Development

AtanaSuite Active Server Job and Run Management

Add-ons

The following AtanaSuite Add-on products may be purchased and licensed to work with AtanaSuite Enterprise.

The Ultimate in Teradata Multi-Value Compression Analysis

The Ultimate in Teradata Database Synchronization

Features

Innovations, technology, components and design elements that truly make AtanaSuite the leader in Teradata user, analyst, developer and DBA productivity.

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
Script Wizards
Fill in the blanks to create FastLoad, FastExport, MultiLoad and TPump scripts for the selected table.
Feature
Drag-n-Drop Object and Data Migration
Drag-n-drop Teradata database objects from one database control to another. Change DDL and save without modifying originating source objects in the process. Edit columns and data by using sample and where clause filters and easily include statistics definitions and data as part of stats related object migrations. Integrated progress bar and detailed log provided for monitoring and review. Even copies across servers and supports copying data using views. AtanaSuite Active Script and Active Server enabled as well!
Feature
Table Data Comparison
Compare data in Teradata tables with ease and display easy to read results that can be saved to Excel for testing and auditing purposes. Automatically generate a sync script to bring the comparison table in sync with the reference. Utilizes fastest protocols available for performing these comparisons even across servers quickly and easily. AtanaSuite Active Script and Active Server enabled!
Feature
Unparalleled Flexibility and Productivity
Achieved through simultaneous connections to multiple tools, servers and databases.
Feature
FastLoad and FastExport Script Wizards
Fill in the blanks to create a complete FastLoad or FastExport script for a selected table.
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
Simple Drag-n-Drop Object and Data Copy
Drag-n-drop Teradata database objects from one database control to another, specify data option and click execute! Integrated progress bar and detailed log provided for monitoring and review. Even copies across servers and supports copying data using views. AtanaSuite Active Script and Active Server enabled as well!
Feature
Advanced Database Object Comparison
A powerful and sophisticated Teradata database object comparison engine beneath a simple point-n-click GUI quickly identifies even the smallest of differences. Multiple object type selections and options provided. Delivers detailed results and sync script for review and application. Individual object selection, recursive database logic, role and profile support and name matching make it the ultimate in database object comparison. AtanaSuite Active Script and Active Server enabled as well!
Feature
Preview DDL
Use simple point and click dialogs to create and modify objects and view the DDL necessary to perform the task as you work. Learn Teradata as you work!
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
Integrated Join Development Environment
Easily develop complex Teradata table and view joins using a simple point and click GUI tailored specifically for this task. Execute explains and test runs as you work to verify complicated logic.
Feature
SQL Formatting
Consistent, customizable formatting that can instantly beautify the ugliest SQL mess.
Feature
AtanaSuite Active Script and Active Server Enabled
Save commonly executed SQL, DDL, DCL, DML and related statements as an AtanaSuite Active Script or Active Server job that can be opened later for execution and modification. Purchase AtanaSuite Active Server and take advantage of its centralized job repository, scheduling, execution, monitoring and reporting features.
Feature
Tool-based Design
The AtanaSuite tool-based graphical user interface is designed to help guide users to the specific tool for a specific task or set of tasks common to Teradata warehouse development and management. In doing so, it helps to support and promote a multi-tasking, more productive and collaborative work environment. Many Teradata newbies are surprised at how fast they can become productive by using AtanaSuite, while experienced professionals have adopted it as their must have in working with Teradata on a day to day basis.
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
Handy Keyword Data Search
Type in the keyword and select the tables and views to search and AtanaSuite does the work. Quickly find specific data occurrences quickly and efficiently. Review and analyze search results in easy to read and customize results display. Send to DataTool for detailed analysis and edit.
Feature
Unique Database Object Dependency Display
Fast database object explorer used to select and display object dependencies down to the column level. Identifies both direct and indirect Uses and Used By relationships in hierarchical and list form. No metadata repository needed! Multiple object selection and dependency document display, merge results, and referencing databases selection are just a few of the powerful features included.
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
Fast and Simple Data Display and Editing
Teradata table and view data display using a familiar, spreadsheet-like document interface that supports multiple document browsing and editing. Quickly retrieve and edit table data with ease. Advanced filter, edit, locking and export features also provided.
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
Replace Table
Edit multiple table settings using a simple point and click dialog and have AtanaSuite generate all the DDL and SQL needed to complete the task.
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
AtanaSuite Active Script Job and Run Management
AtanaSuite Active Script jobs and runs are easily managed within this point and click GUI. Just a few clicks is all it takes to browse, open, review, edit and execute previously created Active Script jobs and runs.
Feature
“Easy as Pie (Chart)!” Visualization Development
3 step wizard walks you through transforming query results into powerful and insightful visualizations.
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 Add-on Product Enabled
Need the world's best compression and synchronization products? Purchase AtanaSuite CompressTool and AtanaSuite SyncTool and easily add them into your AtanaSuite environment.
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
Script Builders
Wizard functionality provided for multiple tables to quickly create FastLoad, FastExport, MultiLoad and TPump scripts for an entire database.
Feature
Unmatched Role and Profile Management
Fast, multi-tabbed schema browser used for managing roles and profiles with single click access to attributes, members, permissions, and DDL. Point and click GUI for role and profile creation and editing with Preview DDL to facilitate learning through use and promote greater productivity with Teradata newbies.
Feature
Text File FastLoad Wizard
Quickly load delimited text files with this easy to use Access like wizard.
Feature
The Ultimate Teradata SQL 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.
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
Superior Database Object Management
Fast, multi-tabbed schema browser used for managing database objects with single click access to attributes, data, permissions, resources, stats and DDL. Point and click GUI for object creation and editing with Preview DDL to facilitate learning through use and promote greater productivity with Teradata newbies.
Feature
Powerful Object Keyword Search
Type in the keyword and select the database, object types and attributes to search and AtanaSuite does the work. Find specific table, view, column and other object references quickly and efficiently. Review and analyze search results in easy to read and customize results display.
Feature
Data Browser
Quickly browse selected table and view information with this handy feature.
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
Results Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Feature
AtanaSuite Expression Helper
A context aware menu that steps through creating difficult on clause join and related syntax.
Feature
User Customizable Connection Navigator
Take advantage of this unique feature to create and save connection information utilizing inheritable folder properties that make it a snap to copy and modify almost any aspect of a database connection.
Feature
AtanaSuite Active Server Job, Scheduler, Run, User and Group Management
AtanaSuite Active Server jobs, runs, scheduler, users and groups are easily managed within this point and click GUI. Just a few clicks is all it takes to browse, search, open, review, schedule, edit and execute previously created Active Server jobs and runs. Adding users and creating groups is just as easy!
Feature
Multi-Threaded Architecture
Create joins on one server while executing SQL against another with this feature and take your productivity to another level.
Feature
Teradata CLI Database Connectivity
Tested to be the fastest mechanism for database information access and retrieval.