Real-Time4 SQL Server, a real-time solution to integrate Microsoft SQL Server database on the data’distribution technology
Real-Time4 SQL Server is the solution for real-time integration of Microsoft SQL Server data based on the data’distribution technology.
Real-Time4 SQL Server reads the SQL Server transactions log to integrate - in real time, with high data availability and in complete security - Microsoft SQL Server database content or updates (CDC).
Transactional data exchange between Microsoft SQL Server and any other database
Real-Time4 SQL Server is a tool designed to easily and securely distribute either the updates (via the CDC technique - Change Data Capture) or the content (via extraction) of Microsoft SQL Server databases to other systems: Microsoft SQL Server, MySQL, Oracle Database, IBM AS/400-iSeries-Power i, PostgreSQL, Sybase ASE, Progress OpenEdge, ODBC, XML, text files, applications, ERP, etc., whatever the operating system (Windows, OS/400, i5/OS, UNIX, etc.).
The capture of the updates, in CDC mode, of the tables on the Microsoft SQL Server database is based on SQL Server's transactions log. Real-Time4 SQL Server applies all the updates performed on the appropriate tables - either in real time or in deferred mode - on one or more targets (Oracle Database, Microsoft SQL Server, IBM AS/400-iSeries-Power i, Sybase ASE, DB2, MySQL, PostgreSQL, ODBC, applications, ERP, etc.).
Real-Time4 SQL Server captures data changes in the transactions log
Real-Time4 SQL Server retrieves data from the transactions log and loads a specific data'distribution log structure (similar to a transactions log), allowing for highly precise recovery management and transaction traceability.
Given that the entire selection and transformation process is run on the source machine in PUSH mode, only the data you require is transferred - in the required format - to the target machine, which can also perform transformations on the fly.
The selection-transformation module can call all existing programs on the machine as well as the procedures stored on the database, thus enabling you to reuse existing management rules.
Real-Time4 SQL Server is based on the data’distribution technology
The Real-Time4 SQL Server architecture is based on the data’distribution technology:
Real-Time4 SQL Server performs the SQL Server backup functions
For the backup (high data availability) of a Microsoft SQL Server database, as Real-Time4 SQL Server is operating on an active target database, the backup database can be operational in just a few seconds. Real-Time4 SQL Server ensures perfect mirroring of operational data from the source SQL Server database on the target SQL Server database. The target machine must have as much disk space as that on the source database.
Real-time data mirroring effectively maintains data access during maintenance and upgrade cycles, thus ensuring service continuity by quickly switching to the backup machine.