Advanced object development, utility scripting and role and profile management are found in AtanaSuite Expert. In addition to the power user tools bundled within AtanaSuite Professional, AtanaSuite Expert adds even more tools designed for true developer and scripting productivity.
AtanaSuite Expert 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.
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.
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. AtanaSuite Active Script and Active Server enabled as well!
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
AtanaSuite Expression Helper
A context aware menu that steps through creating difficult on clause join and related syntax.
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.
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!