Data Replication between any SQL Databases
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.
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.
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.
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.
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.
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.
Finally, briefly summarized the most important features of the IGS Replicator 2.5:
- Manufacturer-independent: IGS Replicator works with almost all SQL databases on the market
- Easy to operate: IGS-Replicator displays the required information straightforward and easy to understand.
The set up of the replication instructions takes place in most cases purely graphically
- Usage: The bandwidth of possible applications reaches from the manually-started
one-time operation to the time-controlled repeated execution
- Data Selection: The operation of the IGS Replicator is adjustable from full replication
to field-, column- and data-selected replication
- Referential Integrity: IGS Replicator detects the dependencies of the tables in the target database
and considers them during replication
- Script processing: Before, during, and after replication, the IGS Replicator can execute custom SQL commands.
You can find the product details as a data sheet in the
product information on the IGS Replicator 2.5.
To get more information about prices, licenses etc., please
contact our Sales Department.