AtanaSuite CompressTool

AtanaSuite CompressTool Overview

Before AtanaSuite CompressTool, applying Teradata multi-value compression to your Teradata warehouse or appliance was a manual, time-consuming, error prone process typically performed by expensive Teradata experts with Excel spreadsheets and calculators. Once more, this process is repetitive in that it should be performed whenever your data changes significantly. These significant costs certainly prevented most organizations from implementing it properly and taking advantage of one of it's biggest benefits - boosting performance! With AtanaSuite CompressTool, this manual and expensive process is eliminated! Replaced with an extremely powerful and accurate to the last bit compression algorithm wrapped in a simple, easy to use product that all Teradata users can understand and utilize. Request a trial of AtanaSuite CompressTool today and you will quickly see why it is the world's best compression product for Teradata.

AtanaSuite CompressTool eliminates tedious and time-consuming manual table, column and value compression calculations. Use AtanaSuite CompressTool to quickly scan and make the best possible compression, data type change and size recommendations. Save valuable data warehouse space and increase query performance with this one, easy-to-use tool.

Using AtanaSuite CompressTool is as easy as drag-n-drop - select the tables and columns to go after, specify a few options and AtanaSuite CompressTool does the rest. It identifies your current settings, it analyzes the existing data, it makes recommendations on compression and data type changes, it provides complete application scripts and it will even apply your selected recommendation automatically!

AtanaSuite CompressTool Key Features

Some of the key features in AtanaSuite CompressTool and the AtanaSuite environment:

• IntelliSQL® - Context aware Teradata statement, keyword, function and database aware drop-downs 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!
• Fast, Intuitive and Customizable Graphical User Interface - The latest in user interface technologies implemented in an integrated, consistent, and easy to use environment. Customize and organize layout, dockable windows, tabs, database lists, SQL, results and more to individual preferences and corporate standards.
• Unparalleled Flexibility and Productivity - Achieved through simultaneous connections to multiple servers and databases.
• Advanced Compression Analysis Algorithm - Takes into account all the special considerations like table header size and row presence bits to deliver the most optimum compression and data type change recommendations.
• Simple Table and Column Selection - Simply drag tables and columns into the selected area to include in compression analysis.
• Customizable Database and Table Display - Modify preferences to include size information for even quicker selection of databases and tables.
• Multiple Compression Analysis Options - Display selected table current settings, perform data analysis and make compression recommendations options are provided.
• Special Cost Savings Calculation - Immediately determine your cost savings by applying AtanaSuite CompressTool recommendations.
• Data Type Filtering - Easily include or exclude certain data types for compression analysis consideration.
• Data Type Change Analysis - Several data type change options provided to consider as part of compression analysis to save the most amount of space possible. Select the options and let AtanaSuite CompressTool do the work!
• Automatic Table Header Size Calculation - AtanaSuite CompressTool can automatically calculate the table header size for you!
• Complete Data Sampling Support - Quickly get an idea of what compression can do for a table by utilizing this feature.
• Multiple Recommendation Application Scripts - Choose from a variety of application scripts provided to apply the compression recommendation. Several scripts generated to create a new table or replace the existing table with or without data and even includes an Alter statement script for versions of Teradata that support it.
• Auto Apply - Have AtanaSuite CompressTool automatically apply the selected recommendation script.
• Compression Analysis Progress Log - Window displays analysis, recommendation calculation and script generation progress.
• Multiple Summary and Detailed Results - Current settings, data analysis and recommendations displayed in easy to navigate results display. Use the summary to get a high-level view of information and then select specific items for more in-depth review and analysis.
• Results Export - Available throughout the product that provides exporting results to the most popular formats including Excel.
• AtanaSuite Active Script Enabled - Save AtanaSuite CompressTool settings as an AtanaSuite Active Script job that can be opened later for execution, modification and reuse.
• AtanaSuite Active Server Enabled - Purchase AtanaSuite Active Server and take advantage of its centralized job repository, scheduling, execution, monitoring and reporting features.
• 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 - All AtanaSuite products and tools provide this so that you can be more productive with AtanaSuite.
• 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.
• Teradata CLI Database Connectivity - Tested to be the fastest mechanism for database information access and retrieval.

AtanaSuite Active Server Integration

AtanaSuite CompressTool promotes increased productivity through integration with our AtanaSuite Active Server product, the world's finest server-based productivity tool suite for Teradata! This integration allows for centralized job scheduling, monitoring, auditing, reporting, as well as collaborative development and code reuse.