Selecting an Appropriate Data Synchronization Tool

In every business that relies heavily on computer systems there is a need to ensure that your data is stored in more than one location. Many times the information is stored in data centres. The reason for making sure that you have your data in more than one place is generally driven by one or more of the following reasons:

 * To refresh a QA or test environment
* High failover/availability
 * Disaster recovery
* The population of independent data marts mainly for the optimization of workload

Based on the needs of the business you will need to find the best tool for data synchronization. This is a critical decision to make and luckily there are several options in the market to choose from. In many ways this decision can seem very daunting, but you will need to figure out what the requirements of the business are first in order to know what will work best for you. When you have carefully examined what is the need in the business two important variables will become evident:

* Batch size
* Latency

You will need to determine if you how much data lag or latency your business can tolerate. How quickly do you want the data to synchronize – in sub-seconds, seconds, minutes or hours? The other consideration, batch size, refers to the size of the loads. They can be large or bulk loads, trickle feeds or small loads. Once you have this information you are then able to figure out which data synchronization method you want to use and with that information you can select the right tool for the job.

Two methods that you should consider are SQL multicast and Table Copy. SQL multicast is a great method to use if you are working with multiple teradata systems and would like to send your data to the several different data centres or locations real time. Table Copy on the other hand works if you are transporting the data from one system to another not multiple systems at once. The latency here is longer and it is not a great option if you are looking for fast real time synchronization. If your functions are not very critical then this method will work for you.

These methods are made to co-exist and work within a particular environment. If you invest in either data synchronization method your money will be safe. Just be sure to select one that meets your needs.

Data synchronization is become critical for many businesses today. Selecting the right method and tool to use is a critical decision that must be made thoughtfully.

click to find out more

Be the first to like.

Share This