AtanaSuite Gold is truly the ultimate development and management productivity suite subscription 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.
AtanaSuite Gold contains the following tools. Click on a tool to get additional information.
Innovations, technology, components and design elements that truly make AtanaSuite the leader in Teradata user, analyst, developer and DBA productivity.
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!
Fill in the blanks to create FastLoad, FastExport, MultiLoad and TPump scripts for the selected table.
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!
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.
Unparalleled Flexibility and Productivity
Achieved through simultaneous connections to multiple tools, servers and databases.
FastLoad and FastExport Script Wizards
Fill in the blanks to create a complete FastLoad or FastExport script for a selected table.
Instantly generate access views for an entire database by simply selecting the tables and view preferences and letting View Builder do the rest.
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.
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!
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.
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.
Consistent, customizable formatting that can instantly beautify the ugliest SQL mess.
Active Script Enabled
Save commonly executed operations as an AtanaSuite Active Script job that can be opened later within JobTool for execution, modification and scheduling.
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.
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.
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.
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.
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.
Edit multiple table settings using a simple point and click dialog or by using drag-n-drop from SQL Helper and have AtanaSuite generate all the DDL and SQL needed to complete the task.
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.
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.
“Easy as Pie (Chart)!” Visualization Development
3 step wizard walks you through transforming query results into powerful and insightful visualizations.
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.
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!
Wizard functionality provided for multiple tables to quickly create FastLoad, FastExport, MultiLoad and TPump scripts for an entire database.
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.
Text File FastLoad Wizard
Quickly load delimited text files with this easy to use Access like wizard.
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.
Common object and attribute information browsing with drag-n-drop instant SQL and DDL command generation that is the perfect complement to AtanaSuite IntelliSQL.
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.
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.
Quickly browse selected table and view information with this handy feature.
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.
Available throughout the product that provides exporting results to the most popular formats including Excel.
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.
Create joins on one server while executing SQL against another with this feature and take your productivity to another level.
Teradata CLI Database Connectivity
Tested to be the fastest mechanism for database information access and retrieval.