StarQuest Technical Documents

SQDR: Recommended ODBC DRIVERS

Last Update: 26 February 2021
Product: StarQuest Data Replicator
Version: 5.10 or later
Article ID: SQV00DR042

Abstract

This technical document list the recommended ODBC drivers for each of the DBMS types supported by SQDR, plus alternatives that may be recommended in certain situations.

In general, StarQuest recommends using the latest version of a driver, but there may be exceptions.

Also refer to the current version of the SQDR Release Notes for additional information.


Databases with full support
(incremental & snapshot source; destination)

IBM Db2 for i

  • StarQuest StarSQL (installed with SQDR)

Alternatives

  • IBM i Access Client Solutions
  • IBM Db2 ODBC Driver (with Db2 Connect license)

IBM Db2 for LUW

  • StarQuest StarSQL (installed with SQDR)

Alternatives

  • IBM Db2 ODBC Driver (with Db2 Connect license)

Oracle Destination

  • SQDR Oracle 8 (installed with SQDR)

Alternatives

  • Oracle Instant Client

Oracle Source

  • Oracle Instant Client

Alternatives

  • SQDR Oracle 8 (installed with SQDR)

Microsoft SQL Server

  • Microsoft ODBC Driver 17.5.x for SQL Server

Alternatives

  • SQDR SQL Server 8 (installed with SQDR)

MySQL/MariaDB/Aurora

  • MySQL 8.0.x ODBC driver
  • MariaDB ODBC driver

Alternatives

  • SQDR MySQL (installed with SQDR) - MySQL Enterprise host only
  • MySQL 5.3.x ODBC driver - for older MySQL systems

IBM Informix

  • SQDR Informix (installed with SQDR)

Alternatives

  • IBM Informix ODBC driver
  • IBM Db2 ODBC driver (limited functionality)

Databases supported for snapshot source
or as destination

Apache Derby

  • StarQuest StarSQL (installed with SQDR)

Exasol

  • Exasol ODBC driver

IBM Db2 z/OS

  • StarQuest StarSQL (installed with SQDR)

Alternatives

  • IBM Db2 ODBC Driver (with Db2 Connect license)

Postgres

  • SQDR Postgres (installed with SQDR)

Alternatives

  • psqlODBC

MemSQL

  • MariaDB ODBC driver

Redshift

  • SQDR Redshift (installed with SQDR)

Note that the Amazon-supplied ODBC driver is not supported.

Salesforce

  • SQDR Salesforce ODBC driver (optional SQDR_ODBC_XE package)

Snowflake

  • Snowflake ODBC driver

Text (CSV, TAB, etc)

  • SQDR Text (installed with SQDR)



DISCLAIMER

The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.