AtanaSuite SyncTool

AtanaSuite SyncTool Overview

Quickly and easily synchronize entire databases across Teradata warehouses, operational environments, departmental servers and even the latest Teradata appliances! Let AtanaSuite SyncTool help you keep these multiple platforms in sync.

Using AtanaSuite SyncTool is as easy as drag-n-drop - select the databases and objects to go after, specify a few options and AtanaSuite SyncTool does the rest. It can copy objects and data, it can compare objects and data and apply the differences to bring them in sync and it can do both in any combination; as well as for multiple databases at the same time.

AtanaSuite SyncTool Key Features

Some of the key features in AtanaSuite SyncTool 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.
• Drag-n-drop Database and Object Selection - Simply drag databases and objects into the selected area to include in the SyncTool process. Select an entire database in one step. Select multiple objects in one step.
• Multiple Database Support - Copy or sync from or into several databases as part of one AtanaSuite SyncTool operation.
• Static or Dynamic Database and Object Selection - Static selection will select objects that are currently within the database when creating the AtanaSuite SyncTool job, while dynamic selection will automatically determine at AtanaSuite SyncTool runtime the selected objects.
• Static or Dynamic Object Definition Options - Much like object selection, static works with object definitions when creating an AtanaSuite SyncTool job, while dynamic will retrieve the object definition at AtanaSuite SyncTool runtime.
• Multiple If Object Exists Options - Overwrite, synchronize, skip or copy data only options if target object already exists.
• Multiple If Data Exists Options - Overwrite, synchronize or even append data options if target data already exists.
• Multiple Statistics Options - Several options provided for handling statistics copy and recollection.
• Object Backup - Create a backup of target objects before overwriting for auditing or protective purposes.
• Object Type Option Specification - Select an object type, like tables, and apply the selected options for all tables. Select an individual object to override the object type option setting for the selected object.
• Data Relationships Filter - Use this filter to establish table relationships and only pull related table data into the target database. Easily create smaller subsets of production databases for use in dev, test, QA or sandbox environments.
• 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 Data Relationships.
• Data Relationships Auto Column Matching - Can be used to automatically determine join columns based on column names for selected tables.
• Table Filter and Sampling - Provided for easily retrieving subsets of information for inclusion within the table or data copy.
• Filter Parameters - Create special filter parameters once that can be re-used in multiple places. Modify the parameter in one place and it is automatically applied to all the other places it is being used.
• Privileges Support - Include object privileges as part of an AtanaSuite SyncTool operation.
• Static or Dynamic Object Privileges Options - Much like object selection, static works with object definitions when creating an AtanaSuite SyncTool job, while dynamic will retrieve the object definition at AtanaSuite SyncTool runtime.
• Intelligent Sync Engine - AtanaSuite SyncTool will analyze your databases and objects and automatically determine related objects and proper sync operation sequencing. No need to worry about secondary or join indexes or even related tables - it is built right into AtanaSuite SyncTool.
• Fast Data Transfer - Utilizes fastest protocols available for data copy operations including TPT, FastExport and FastLoad.
• Combined Progress Log - Window displays realtime AtanaSuite SyncTool operation progress and detailed operation results log.
• Multiple Results Display Options - Multi-column grouping, filtering, ordering and sorting provide all the necessary features for individually customizing the AtanaSuite SyncTool operation results display.
• 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 SyncTool Uses

• Replicate entire databases from one server to another.
• Keep databases synchronized.
• Create test, development, QA or sandbox databases as subsets of production and maintain related data in the process.
• Teradata appliance synchronization.

AtanaSuite Active Server Integration

AtanaSuite SyncTool 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.