SyncTool

SyncTool

The Ultimate in Teradata Database Synchronization

SyncTool may be added to the following products


AtanaSuite SyncTool eliminates tedious and time-consuming manual copying, comparing, testing and scripting activities. Use AtanaSuite SyncTool to quickly get the job done. Finally, an extremely powerful yet easy to use product for keeping your warehouses, appliances, databases and environments in sync is here – AtanaSuite SyncTool!

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.

SyncTool Screenshots

Click on an image below to expand.

SyncTool

Databases

SyncTool

Table Relationships

SyncTool

Progress

SyncTool Features

Some of the key features within AtanaSuite SyncTool

Feature
Multiple Database Support
Copy or sync from or into several databases as part of one AtanaSuite SyncTool operation.
Feature
Multiple If Object Exists Options
Overwrite, synchronize, skip or copy data only options if target object already exists.
Feature
Object Backup
Create a backup of target objects before overwriting for auditing or protective purposes.
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 Data Relationships.
Feature
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.
Feature
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.
Feature
Multiple Results Display Options
Multi-column grouping, filtering, ordering and sorting provide all the necessary features for individually customizing the operation results display.
Feature
Results Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Feature
Drag-n-drop Database and Object Selection
Simply drag databases and objects into the selected area to include in the operation. Select an entire database in one step. Select multiple objects in one step.
Feature
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.
Feature
Multiple Statistics Options
Several options provided for handling statistics copy and recollection.
Feature
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.
Feature
Table Filter and Sampling
Provided for easily retrieving subsets of information for inclusion within the table or data copy.
Feature
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.
Feature
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.
Feature
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.
Feature
Multiple If Data Exists Options
Overwrite, synchronize or even append data options if target data already exists.
Feature
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.
Feature
Data Relationships Auto Column Matching
Can be used to automatically determine join columns based on column names for selected tables.
Feature
Privileges Support
Include object privileges as part of an AtanaSuite SyncTool operation.
Feature
Fast Data Transfer
Utilizes fastest protocols available for data copy operations including TPT, FastExport and FastLoad.
Feature
Active Script and Server Enabled
Save commonly executed operations as an AtanaSuite Active Script job that can be opened later within JobTool for execution and modification. Purchase AtanaSuite Active Server and take advantage of its centralized job repository, scheduling, execution, monitoring and reporting features.
Feature
Combined Progress Log
Window displays realtime operation progress and detailed operation results log.