A short guide on data replication types and use cases. CopyOver Replication

In the current business environment data needs to be integrated between multiple cloud-based and on premise sources. You can do this either through data replication which makes a copy of the data or through data virtualization which combines this data on request.

With the Data Virtuality Platform you no longer need to choose between the two. Our platform uniquely combines data virtualization and data replication. This gives data teams the flexibility to always choose the right method for their specific requirement. It provides high-performance real-time data integration through smarter query optimization and data historization as well as master data management through advanced ETL in a single tool. 

In this blogpost series, you will 

1. get an overview of the different data replication types that are provided in the Data Virtuality Platform
2. learn which replication type is best suited for which use case and why
3. see how each replication type looks like in the Data Virtuality Platform

What is data replication?

Data replication is a synonym for physical data integration. In this process, copies of new tables are created in a central storage which represent the data from the source systems in a transformed, historized or cleansed form.

There are various ways to do this. For example, data can be copied between a local source and the cloud or between two on-premises hosts or between a local host and another host in a different location.

Data replication types 

There are  five data replication types available in the Data Virtuality Platform which we will cover in our blog post series. These are 

• CopyOver Replication
• Incremental Replication
• Upsert Replication
• Batch Replication
• History Replication

What is CopyOver Replication?

CopyOver Replication also known as Full or Complete Replication clones a table or view to the destination. The destination table can either be deleted or dropped and recreated in the process. All the data is copied over.

CopyOver Replication on the Data Virtuality Platform

On the Data Virtuality Platform, the CopyOver replication method retrieves the current data from a given source and puts it into the destination table. If a table with the same name already exists, it will be handled according to the cleanup method that you selected: 

1. DROP: table will be dropped and recreated; if not specified, this is the default cleanup method
2. DELETE/TRUNCATE: table will be emptied by deleting all rows

Interested in seeing how you can get started?

The Data Virtuality Platform is trusted by businesses around the world to help them harness the power of their data. Book a demo and test all the features of the Data Virtuality Platform in a session tailored to your use case.