CONNX Solutions . . . Simplified Data Access EXCEL LINK ENTERPRISE ADAPTER DESKTOP ADAPTER INFONAUT DATASYNC EII JDBC J2EE ODBC OLEDB .NET D-ISAM POWERFLEX DATAFLEX RDB POSTGRESQL SYBASE SQL SERVER INFORMIX ORACLE DB2 ADABAS C-ISAM IMS VSAM DBMS RMS
CONNX Features and Benefits Information Request CONNX for Linux/Unix CONNX for Mainframe CONNX for OpenVMS ExcelLink InfoNaut Professional (Desktop Query/Ad Hoc Reporting Tool) CONNXSOA DataSync (Change Data Capture) CONNX (Data Access & Integration) Contact Us News & Events Partners Resources Services & Support Products & Solutions About CONNX Solutions Request Evaluation Home Live chat by Boldchat
   

        HOME PRODUCTS CONNX DATASYNC

 
   

CONNX DataSync is . . .

Change Data Capture Software
DataSync captures incremental changes and delivers them at user-defined intervals to a data warehouse in a fraction of the time full extracts typically require.

Incremental Updates
DataSync quickly detects which records have been added, deleted or changed and propagates the changes to the data warehouse. Synchronizations can be scheduled or performed on demand.

CONNX DataSync captures incremental changes and delivers them at user-defined intervals to a data warehouse in a fraction of the time full extracts typically require.

Versatile
DataSync works in conjunction with the CONNX distributed SQL Engine to move a company's enterprise data from virtually any source location to virtually any target. DataSync can capture changes from single or multiple data sources.

Scalable
DataSync is specifically designed for multi-machine environments, which can drastically reduce the load against production systems. Multiple synchronization servers can be added to meet increasing demand.

Fast to Implement
After importing source and target databases into the CONNX repository, you can have DataSync up and running within an hour of installation.

Easy to Use
The DataSync Administrator allows you to easily specify which data to move, which targets to move it to, when to move the data (scheduled syncs) and if the transaction should be a full reload or an incremental update.

The Tool for Minimizing Project Risk
DataSync eliminates manual/one-time programming efforts and offers the option to automate synchronizations between the source and target data.

Ideal for Joining Legacy and Relational Data
DataSync can be used for migration projects and to support Business Intelligence, or event-driven Business Process Management applications where legacy data from non-relational databases in production environments must be joined with relational data.

Performance Matters
The table below shows the time savings achievable when change data capture operations within legacy databases are contrasted with full database restores to target relational databases.

Change Data Capture Update Transfer Speed Statistics for DB2 to Oracle, RMS to SQL Server and VSAM to SQL Server

The CONNX InfoNaut Tool can be used to access all CONNX modules.

CONNX Web enablement can provide Web access to any of the CONNX modules.

Sales Info

To receive further product information or to order CONNX software please contact a CONNX Solutions sales representative by phone, fax, or electronically at:

888-88-CONNX (U.S.A. only)
425-519-6600
425-519-6601 fax
Request more information or a free software evaluation .


 

CONNX DataSync:

Feature Benefit
Incremental updates – detects which records have been added, deleted, or changed, and inserts, updates, or deletes the corresponding data in the data warehouse snapshot tables. Eliminates "homegrown" solutions.
Each file in the synchronization process may be scheduled independently or as a group. Eliminates the need for extracts.
Full reloads – purges all prior snapshot data in the data warehouse and replaces it with a completely new snapshot of the data. Eliminates manual steps in the data synchronization process.
Complete, built-in scheduler. NT scheduler service runs data synchronization jobs at the appropriate time. Minimizes project risk.
Task execution – tasks can be triggered to run before and/or after a synchronization job runs. Minimized computer resources.
Benchmark results show incremental updates were between three to 20 times faster than full reloads for these customers. Refer to the grid, 'Performance Matters' to the left. Streamlines time to populate target data sources.
CONNX Clients have the flexibility of querying either against the data warehouse and data marts or against the live operational data sources. Decreases update times significantly.