Phone - Australia: 1300 553 313
Hotline - New Zealand: 0800 450 168
Actian (Pervasive)

DataExchange for PSQL

Reliably Move Data Between Databases

DataExchange for PSQL offers two types of data replication solutions: real-time data backup of a single PSQL database and data synchronisation between multiple applications. DataExchange provides a simple to use solution for securing and protecting your mission-critical data from application downtime and data loss.

Keep Business Data Secure and Organised

DataExchange meets your most important data replication needs. DataExchange Real-Time Backup Edition can help reduce disaster-related downtime with a remote backup of key application data. DataExchange Data Synchronisation Edition can help keep a consistent set of data across multiple applications.

Real-Time Backup Increases Application Availability

Quick recovery is essential to minimise business losses during an application outage. DataExchange Real-Time Backup captures change events in the PSQL database and replicates them to a secure remote always-available duplicate backup.

DataExchange reduces the loss of data and downtime associated with:

  • Hardware Failure – computer or disk crashes
  • Site Disaster – floods, fires or power outages
  • User and Application Errors – accidental deletions, OS or application errors

DataExchange Real-Time Backup Edition helps reduce the recovery time in the event of a loss – no matter what the cause.

Real-Time Backup

Mission-critical data is a high-value, time-sensitive corporate asset. Protecting this data from disasters, ranging from major floods to minor water pipe breaks, requires copying fresh data to a secure location.

DataExchange Real-Time Backup Edition replicates data from a production server to a backup server. If a system fails, clients can be redirected to the up-to-date backup. With DataExchange, data loss and down time due to system crashes, hardware failures, or site disasters are eliminated.


Synchronising Multiple Databases

Growth in the number of users, offices and locations is increasing the distribution of data. Users expect immediate access to information regardless of location. DataExchange Data Synchronisation Edition replicates data between PSQL databases. It solves problems ranging from driving data to a second server for offline reporting, sharing data between multiple warehouses and connecting mobile users with a head office. With DataExchange, users always see fresh and consistent data.


Unique Replication Technology

DataExchange leverages sophisticated database replication technology to ensure your mission-critical data is always where you need it when you need it. Deployment options range from embedding in applications to end user installation. Learn more about database replication technology.


DataExchange leverages sophisticated database replication technology to ensure your mission-critical data is always where you need it when you need it.

DataExchange captures and shares changes from one PSQL database to another in a DataExchange replication network. Each database is augmented with DataExchange, which adds two software components to a PSQL database, the Replication Event Handler and the Replication Engine.


Replication Event Handler

The Replication Event Handler (REH) plugs directly into the PSQL database engine. Specifically, the REH is a set of DLLs that operate within the database engine, so if the database is running, the replication event handler is also running. The database engine activates the REH when there is a change event (insert, update, delete). The REH then makes note of the event in one of its private control tables.


Replication Engine

The Replication Engine is a separate process that performs the actual replication task. It reads the control tables to determine what records have changed since the last replication session. It then groups these changes into packets and shares them with the other replication engines participating in a DataExchange network. These other engines then apply the updates to their own databases. The replication process occurs either continuously, at scheduled intervals, or on demand. The replication engine does not require constant network connectivity, so DataExchange is suitable for scenarios with intermittent connectivity like remote users with dialup connections.

DataExchange Real-Time Backup
DataExchange Data Synchronisation


The DataExchange engine has the following advanced capabilities:

  • Replication normally occurs at the transactional level, so data definition files (DDFs) are not required.
  • Update packets are encrypted using a 128-bit key. This reduces the likelihood of unathorized viewing of the database changes.
  • Conflicts are detected and resolved. Conflicts occur when the same record in two different databases is edited at the same time. In most applications, data conflicts are rare or nonexistent. In cases where data conflicts do occur, there are default and user definable resolution rules.
  • Network topology is flexible. While most DataExchange networks include only two databases replicating back and forth, multiple database scenarios and organizations are possible. Supported topologies include ring, hub and spoke, peer-to-peer, and hierarchical.

In addition, DataExchange includes a full suite of design, maintenance and monitoring tools.



For more information please contact the MicroWay sales team: buynow
Head Office
MicroWay Pty Ltd
PO Box 84,
Braeside, Victoria, 3195, Australia
Ph: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
Sydney Sales Office
MicroWay Pty Ltd
PO Box 1733,
Crows Nest, NSW 1585, Australia
Tel: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
New Zealand Sales Office
MicroWay Pty Ltd (NZ)
PO Box 912026
Victoria Street West
Auckland 1142, New Zealand
Tel: 0800 450 168
email: sales@microway.co.nz

International: call +61 3 9580 1333, fax +61 3 9580 8995

© 1995-2019 MicroWay Pty Ltd. All Rights Reserved. Terms and Privacy Policy.