AtanaSuite Professional
AtanaSuite Professional contains the core set of indispensable tools all users need for maximizing productivity with your Teradata warehouse plus additional tools needed for power users and developers.

Tools

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

Simple Database Object and Data Copy

Database Object Search

Warehouse Data Visualization Development

SQL Development Environment

Table and View Data Browser and Editor

AtanaSuite Active Script Job and Run Management

AtanaSuite Active Server Job and Run Management

Database Object Comparison

Table and View Join Development Environment

Database Object Information and Management

Add-ons

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

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
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
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
Robust 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. 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
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
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
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.
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!