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.