Near real-time, low-latency change data capture
Keep your data fresh and up-to-date without impacting the performance of your data sources with CONNX DataSync. DataSync lets you maintain data warehouses with minimal effort or system requirements, delivering near real-time data integration and continuous refreshes by incrementally updating only those records that have changed. Eliminate the need for large and resource-intensive bulk data refreshes with DataSync's highly efficient and market-proven design.
DataSync is a database synchronization software that lets you set the update schedule so you can optimize system performance based on your organization's needs. Depending on the demand, you can schedule updates for lower-use periods such as after normal business hours, or as frequently as every minute when you need the most up-to-date data available.
ACD (Add, Change, Delete) Replications are a special type of replication that track the operations done against a database rather than replicating the data itself. When an ACD Replication is defined, a source table is defined and a special ACD target table is created in the target database. The Event Producer will now monitor the source database for any transactions against the table specified in the ACD Replication and a record will be inserted into the ACD target table specifying each operation (Add, Change, Delete) that occurs for the transaction. The ACD target table is a transaction log for the specified source table.
Fast to Implement
CONNX DataSync is designed to get you up and running within an hour of importing source and target databases.
Easy to Use
The simple CONNX DataSync user interface makes it easy to specify which data to move where and when, and whether to perform a full reload or an incremental update. In conjunction with the Transformation Server, DataSync will allow seamless ETL.
CONNX DataSync works in conjunction with the CONNX distributed SQL Engine to move, replicate, or archive your enterprise data from virtually any source location to virtually any target. CONNX DataSync can capture changes from single or multiple data sources, greatly simplifying your data management requirements. It uses a CONNX proprietary technology that doesn't require log mining which allows a much larger array of database connections.