StarQuest: keeping data in motion

SQDR System Requirements

You can install and run the StarQuest Data Replicator (SQDR) software on any of the following operating systems:

  • Windows Server 2016, 2019, 2022
  • Windows 10, 11 64-bit Edition

A minimum screen resolution of 1024 x 768 is recommended when using Data Replicator Manager.

The Data Replicator requires a control database in which to store definitions for sources, destinations, and subscriptions. If you are using SQDR Plus to support incremental replication, we recommend using the instance of Db2 LUW installed with SQDR Plus. Otherwise, you can use any of the following versions of IBM Db2 for Linux, Unix Windows (LUW) or Microsoft SQL Server for the SQDR control database. You can obtain Db2 Community Edition free of charge from IBM. Similarly, you can obtain the Microsoft SQL Server Express free of charge from http://www.microsoft.com/downloads to use as a control database for the Data Replicator.

  • IBM Db2 for LUW 11.5.5sp1 or later (11.5.7 recommended)
  • SQL Server 2012 through 2022, including Express Edition

The control database can be either local or remote. For a remote database, install the appropriate ODBC driver:

  • For Db2 for LUW control database: StarQuest StarSQL (included in the SQDR installer)
  • For SQL Server control database: ODBC Driver 17 or 18 for SQL Server

Using SQDR, you can replicate data to and from any of the following database systems:

  • IBM Db2 for i (formerly known as DB2/400, DB2 UDB for iSeries, and DB2 for i5/OS) running OS/400 V5R4 and later (including IBM i 7.5)
  • IBM Db2 9.7 & later for Linux, UNIX and Windows (including Db2 LUW 11.5)
  • IBM Db2 for z/OS 8.1 and later (including Db2 12 for z/OS)
  • SQL Server 2005 through 2022
  • Azure SQL Database
  • Azure SQL Managed Instance
  • Oracle 10g or later (including Oracle 19c)
  • MySQL 4.1 or later
  • MariaDB 10.x or later
  • Amazon Web Services Aurora (MySQL or Postgres-compatible)
  • Amazon Relational Database Service (RDS) for MySQL or MariaDB
  • Google Cloud SQL for MySQL
  • PostgreSQL
  • EDB Postgres Advanced Server
  • TmaxSoft Tibero 6 or later
  • Kognitio WX2 7.1 or later
  • Apache Derby (JavaDB) 10.3 or later
  • Informix: any version of Informix supported by v4.70 of the IBM Informix ODBC driver:
  • Actian Pervasive PSQL
  • Salesforce (snapshot source)
  • Amazon Redshift
  • Snowflake
  • Exasol
  • Apache Spark/Databricks

Incremental replication is supported from the following databases using SQDR Plus. SQDR Plus is licensed separately from the base SQDR product:

  • Db2 for i v5r4 and later
  • Db2 for Linux, UNIX, and Windows v9.7 and later
  • SQL Server 2012 and later
  • Azure SQL Database
  • Azure SQL Managed Instance
  • Oracle 11.2 and later
  • Informix 11.50 and later
  • MySQL 5.6 or later
  • MariaDB 10.x or later
  • Amazon Web Services Aurora (MySQL-compatible)
  • Amazon Relational Database Service (RDS) for MySQL 5.6 or later
  • Azure Database for MySQL or MariaDB
  • Google Cloud SQL for MySQL

Access to Db2 databases requires an ODBC driver, such as the StarQuest StarSQL driver, the IBM Db2 Connect driver, or the IBM i Access Client Solutions driver (for access to Db2 for i).

Access to Microsoft SQL Server databases requires the Microsoft ODBC Driver 17 or 18 for SQL Server.

Access to Oracle databases requires one of the following ODBC drivers:

  • SQDR bundled ODBC driver for Oracle (SQDR Oracle 8 recommended).
  • Oracle Instant Client ( 12.1.0.2 or later)
  • Full Oracle Client
  • Progress DataDirect Connect64 for ODBC (Oracle Database Wire Protocol Driver)

Access to MySQL and compatible databases requires MySQL Connector/ODBC 5.1.x or 8.0.x (do not use Connector/ODBC 5.1.6 or 8.0.28&later) or MariaDB ODBC driver.

Access to Informix databases requires that the database be configured to support Transactions.

To connect to Informix, you can use the the SQDR bundled ODBC driver, IBM Informix ODBC driver (CSDK) 4.10xC7 & later , the IBM Db2 ODBC driver, or the DataDirect Connect64 for ODBC driver . Some drivers may have limitations; for example, the IBM Db2 ODBC driver cannot handle variable UDT (CLOB) fields.

Access to Apache Derby (JavaDB) requires StarSQL 6.20 & later (installed with SQDR).

In addition, you can use Data Replicator with other databases if they can be accessed through an ODBC driver that complies with Level 2 of the ODBC 3.51 specification.

If you use an ODBC driver other than StarSQL there may be additional configuration requirements to use the driver for replications with SQDR. The SQDR Readme file and the Technical Documents area of the StarQuest Web site provide details about known issues for using SQDR with other products.

SQDR also works with Apache Kafka and cloud-based streaming services such as Azure Event Hubs for Kafka, the Oracle Cloud Infrastructure Streaming service, and Amazon Managed Streaming for Apache Kafka.