| Pervasive DataExchange Product Information
Pervasive DataExchange is the replication solution from Pervasive
Software, designed to provide data portal solutions, data
continuity solutions, and data synchronization solutions to
users of the Pervasive database products.
DataExchange installs a component to your database engine
called the Replication Event Handler that captures all changes
to all data files in your configured replication environment.
These changes are stored in a set of data files that helps
define your replication network. You can configure a single
replication network for multiple databases and directories,
or you can configure multiple replication networks so that
each database or directory stands alone.
At specific intervals, which can be configured from continuous
to monthly or anything in between, the Replication Engine
reads the database for a list of all changes since the last
synchronization. The compiled change list is then compressed
and encrypted and finally sent to the target engine where
they are applied to the target database.
Bundled with this product are tools to configure and maintain
the replication network. A full suite of log files provides
feedback on the state of the replication processes, and the
system can be configured for proactive alerts via Email if
the replication process is not able to complete within a given
period of time.
The product line is divided into two "editions",
named the Real-Time Backup Edition and the Data Synchronization Edition.
Real-Time Backup Edition
The Real-Time Backup Edition of DataExchange (RTBE) is specifically
designed to provide companies with a low-cost, easy-to-install
solution for fault tolerance on a primary database server.
It is an ideal solution for building a hot-site that receives
periodic updates to the database on a daily, hourly, or even
continuous basis. This edition runs exclusively at the Btrieve
layer and does not require DDF's. This edition is ideal for
the following scenarios:
- On-Site, Hot-Spare Server:
Get the maximum uptime from your local LAN by replicating data to a local server. This scenario offers an extremely
rapid recovery from a hardware failure of your primary database server. After such a failure, simply change a few
application settings (or just the server name), and you're ready to rock!
- Off-Site Data Center:
Threats ranging from natural disasters, disease, terrorism, theft, and internal sabotage can all cause problems
for your business. Protect yourself by shipping the data off to your off-site location continuously through the
day. If a problem occurs within the primary data center, you'll immediately have a known-good copy of the data
ready to roll!
The RTBE package includes a single DataExchange license for use on only two servers (the primary and the backup). In addition, it provides a one-user license count for Pervasive.SQL WorkGroup or Client/Server Engine (for the backup server) for management use. You are also granted a license to use your existing Pervasive.SQL database license on the secondary server for fail-over purposes only
Two core restrictions exist in the RTBE release: 1) Data synchronization is restricted to one-way replication only, and 2) The replication network is limited to only two database servers. You can upgrade your RTBE software to a SYNC version at a later time at no charge, but you'll need to purchase the other licenses at that time to remain compatible.
The RTBE package is available in several different SKUs, one for a Workgroup Engine and several for the Server Engine, stratified by user count (which must meet or exceed your database user count). User counts available are 6U, 10U, 20U, 50U, and Unlimited. You can also stack licenses to exactly match your Pervasive.SQL database license.
Data Synchronization Edition
The Data Synchronization Edition of DataExchange (SYNC) is designed to provide companies a more flexible mechanism for distributing database updates between multiple servers or sites. It provides all the functionality and removes some of the restrictions of the Real-Time Backup Edition in that it allows for full, two-way replication between multiple sites, and it allows the piping of data to a secondary server for use as a web or reporting portal server. This edition is ideal for the following scenarios:
- Tiered Hot Backup Configurations:
The Data Synchronization edition can be configured to run a single-database backup, as described above with the
Real-Time Backup Edition. However, it also offers the flexibility to replicate to multiple servers concurrently,
locally and at remote sites, at different intervals. Thus, you can maintain BOTH an on-site hot-spare server AND
an off-site copy of the data for optimal protection.
- Reporting Servers:
Reporting servers are wonderful for large environments, since they can remove the CPU-intensive reporting processes
from the primary database server during the day, when performance is a premium. Many companies copy the entire
database from their primary to reporting server, but this can take hours for a large database. The DXSE can pump
database changes to a reporting server on a set interval, as frequently (or infrequently) as you wish. Replicating
daily may work for most environments on a reporting server, and it minimizes the amount of replication traffic
and overhead. Some sites replicate twice daily to their reporting server, so that reports run after lunch will
reflect that morning's changes. Finally, some sites replicate continuously to their reporting server, providing
access to all of the most current and accurate data, but eliminating the overhead of reporting from the production
server.
- Web Portal Servers:
Web servers also need updated data, but having this information accessible from outside of the enterprise firewall
can be just asking for trouble, especially if the web server is ever compromised. Replicating the production data
to a web server database engine provides access to your current data from the Internet while protecting your data
assets.
The SYNC package includes a single DataExchange license for use on one server. Each server is licensed based on the user count in use on that server. Each additional server that will participate in the replication network (for any purpose) requires its own license that matches its database license as well. In addition, each server must also have a valid PSQL database engine license on it.
The SYNC package is sold in varying SKUs. There is one SKU specifically for use with WorkGroup Engines (although this can only replicate with a server SYNC edition). The server engine SKUs are stratified by user count similarly to the RTBE above, in 6U, 10U, 20U, 50U, and Unlimited.
Please note that the SQL-based replication has been diswcontinued from thus product, and ONLY the Btrieve-level replication is supported at this time. Contact Pervasive for details about additional deployment options.
The current versions of DataExchange are v2.7, v2.8, and v2.9:
- DataExchange v2.7 is supported on Pervasive.SQL V8 Windows Server database engines only. If you have Pervasive.SQL V8, you can NOT upgrade to 2.8 at this time -- you must upgrade to PSQLv9 first. This release became unsupported as of December 31, 2006.
- DataExchange v2.8 is supported on Pervasive PSQL v9.1 and newer server database engines on Windows servers only. (There is no DataExchange for Linux or NetWare yet.)
- DataExchange v2.9 is supported on Pervasive PSQL v10.0, but ONLY as an upgrade from a PSQLv9 installation. (DataExchange v3.0 for new PSQLv10 installations is expected to be released with Service Pack 1.) This product currently works with 32-bit versions of PSQLv10 only.
Additional Product Links: The following links provide more information about the DataExchange solution:
If you are considering the use of DataExchange in your environment, check out these time-savers!
Contact Goldstar Software if you have additional questions! |
