|
CONNX Data Sync is
change data capture software that works in conjunction with the
multi-platform CONNX SQL Engine and its wide array of
database adapters to capture changes in enterprise data from
single or multiple data sources. Incremental changes to the
data are captured and then delivered at user-defined
intervals to a data warehouse or data mart in a fraction of
the time full updates typically require. With the CONNX
change data capture tool, relationships can be maintained for
bi-directional data management. Complex legacy data
structure is removed from Business Intelligence
applications, enabling developers and application architects
to concentrate on data capture processes and presentation
rather than database formatting.
|
|
The CONNX Data Synchronization change data capture software is ideal for migration projects, supporting 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.
CONNX
Data Synchronization change data capture is low impact and non-invasive. It
creates its own index of changed data and scales perfectly
with the CONNX SQL Engine.
|
Change Data Capture Features |
Change Data Capture Benefits |
|
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 data synchronization process. |
|
Complete, built-in scheduler built in. 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 are up to 4
times faster than full reloads. See below. |
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. |
Sales Info
To receive further information,
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.
A new CONNX white paper on creating joins is
now available.
|
PRODUCTS
CONNX Data Synchronization
