AtanaSuite
AtanaSuite
AtanaSuite
AtanaSuite Silver is the department development and management productivity suite subscription for Teradata. Over 12 different tools, wizards, builders and helpers are integrated into a common and consistent desktop application that is designed to ease and speed Teradata database development.
Tools
Tools within AtanaSuite Silver
Features
Key features within AtanaSuite Silver
Free Trial
Try AtanaSuite Silver Today!
AtanaSuite Silver Tools
AtanaSuite Silver contains the following tools. Click on a tool to get additional information.
Data Dashboard and Visualization Development
Teradata and ODBC Table and View Data Browser and Editor
Teradata Database Object Search
Teradata and ODBC SQL Development Environment
Teradata Table and View Data Search
Teradata and ODBC Data Comparison
Teradata Database Object Comparison
ODBC Table and View Data Import
Teradata Role and Profile Information and Management
Advanced Teradata Database Object and Data Copy
AtanaSuite ActiveScript Job and Dashboard Scheduling on your Desktop!
AtanaSuite ActiveScript Job and Run Management
Teradata Database Object Information and Management
AtanaSuite Silver Features
Innovations, technology, components and design elements that truly make AtanaSuite the leader in Teradata user, analyst, developer and DBA productivity.
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!
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!
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.
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.
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!
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.
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.
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!
Teradata CLI Database Connectivity
Tested to be the fastest mechanism for database information access and retrieval.
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.
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.
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.
Replace Table
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.
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.
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.
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.
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.
SQL Formatting
Consistent, customizable formatting that can instantly beautify the ugliest SQL mess.
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.
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.
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.
Data Browser
Quickly browse selected table and view information with this handy 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.
Results Export
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.
Multi-Threaded Architecture
Create joins on one server while executing SQL against another with this feature and take your productivity to another level.