iSeries Data Replication with SQDR

Heterogeneous real-time data replication for iSeries and AS/400

 

Data problems manifest in a lot of different ways:

  • Too many ad hoc queries bogging down your your IBM iSeries server?
  • Have a new web service to bring up in weeks, not months?
  • Need to re-engineer your DB2 i database without breaking existing applications?

Data replication is an effective solution to all of these problems. In this post we’ll discuss using iSeries data replication with SQDR.

What is SQDR?

 

StarQuest Data Replicator (SQDR) is a low cost, Wintel-based iSeries data replication solution. It helps you free up precious iSeries resources and improve overall user experience. We drew on 25 years of IBM database experience to build SQDR as the solution that addresses the most common challenges of the platform.

Here’s how iSeries replication with SQDR works:

 

  1. SQDR is easy to install and configure within hours.
    All installation, management, and configuration is done through a user-friendly graphic interface. No developer is needed and zero iSeries experience is needed to get the best real-time replication results available in the marketplace.
  2. The software runs off-server. Because the software runs on an intermediate VM that sits between the source and destination, SQDR has a near-zero footprint on the iSeries CPU and disk utilization. SQDR is built this way to provide top performance on real-time, heterogeneous replication for DB2 for i, DB2 for LUW, SQL Server, and Oracle users.
  3. SQDR acquires change data from the iSeries and stages the data on low cost Wintel hardware. This happens fast — within sub-second latency. (No data is staged on the host so your whole system runs faster as well.)
  4. Staged data is published using Unicode encoding, ensuring the greatest fidelity to subscribers. The iSeries replication process is now complete. Your data is now available whenever, wherever you need it.

This process outlines a basic iSeries replication scenario. For a deeper look, please request a free trial.

Two more features of SQDR worth mentioning are:

Data Silos

It’s possible to create data silos based on different vendor products, such as SQL Server, Oracle, or MySQL. SQDR works in conjunction with SQL Server Replication, Oracle Data Warehouse, and other native DBMS replication and extraction tools.

Automated Schema Change Recovery

SQDR helps you avoid downtime due to an altered schema. When it detects a change in the source table schema three things happen: 1) an automatic alert is sent, 2) a checkpoint is created, and 3) replication is paused. The checkpoint ensures reliable data without the need to create a new baseline. Replication automatically starts back up once the schema is updated.

Best price-performance iSeries replication solution

 

Despite being robust and reliable, SQDR has the lowest total cost of ownership for any iSeries data replication solution. There are two main reasons for this: 1) We use load-based pricing, whereas most competitors charge per core, and 2) We do not require a dedicated support engineer. This equates to a significantly lower price point, making SQDR the best price-performance solution for customers looking for heterogeneous, real-time iSeries replication.

Resources

Learn more about what to look for in our Data Replication Buying Guide »

Read customer Case Studies specific to iSeries Data replication: