IGS Replicator 2.5
Moving Data Intelligently

Data Replication between any SQL Databases

Intention

Software systems typically use SQL databases for data storage. The comprehensive networking of systems and the progressive optimization of the workflow requires a fast and reliable data exchange between the participating databases.

Replication Principle Many database manufacturers already provide applications for the data exchange between their own databases. Unfortunately, the exchange with third-party products is often limited or impossible.

IGS Replicator closes this gap and provides an open platform for exchanging data between SQL databases.

Since almost every manufacturer of database management systems (DBMS) offers ODBC interfaces for its products, we use this technology to communicate with the databases involved.

Functionality

An objective of this product is to relieve the user of activities, which can also be done by the program.

The functionality of IGS Replicator is simply based on the need to transfer data from one SQL database to another. Therefore, the IGS Replicator always works with a source database and a target database.

These two databases are usually built the same, since in this case the least adjustments are necessary. But this is not absolutely necessary, since differently structured databases can also be assigned to one another in the IGS Replicator.

Replication Filter When you define a replication, the IGS Replicator scans both participating databases and automatically builds an allocation table using tables and fields of the same name.

If both databases are of the same structure and no filtering of the source data is required, a replication is already completely defined and only needs to be saved in order to be used.

Table Adjust If there are differences in the structure of both databases, the user makes manual assignments to coordinate the target tables and fields to those of the source database. Of course, individual tables or columns can be excluded from replication.

In addition to assigning database objects, the user can of course also select the data himself in each source table by setting filters. The setting of the filters is intuitive, is purely graphical and is supported extensively by IGS Replicator.

Before, during, and at the end of a replication, the user can have his own SQL commands executed, which he can specify in a separate area of the replication mask. He can select between commands executed once or for each insertion.

Usually, the referential integrity feature of a SQL database is activated. This results in the problem that replication of table data must be done in the correct order to avoid SQL errors when writing the data.

This is not a problem for small databases, since the user generally knows his database and can sort the tables themselves. For larger databases, manual sorting is much more difficult and also more error-prone.

For this reason, the IGS Replicator 2.5 offers the possibility to sort the tables of the target database according to their dependencies programmatically. This means that the tables in the target database are already in the order of their dependencies after the initial scan.

Unattended Execution

Like any other application, the IGS replicator can also be started from the task scheduling of the PC operating system.
However, in order to prevent unintentional execution, several safety levels were implemented in the IGS Replicator 2.5. Only when all these security requirements have been met, replication can be started automatically with the IGS Replicator 2.5.

The IGS Replicator has only one replication in editing or in execution at a time.

Summary

Finally, briefly summarized the most important features of the IGS Replicator 2.5:

You can find the product details as a data sheet in the product information on the IGS Replicator 2.5.      PDF

To get more information about prices, licenses etc., please contact our Sales Department.