When using the Docker container for SQDR, many of the drivers in this chapter are already installed and configured in /etc/odbcinst.ini. Information for downloading and installing drivers is provided for informational purposes and for users installing SQDR on their own Linux system (not tyipcally recommended).
Note that updating the drivers in a container is not recommended, since the update will not survive a restart of the container.
Except as noted, the driver names (defined in /etc/odbcinst.ini) match the names used on Windows.
The connection string examples documented in the Data Replicator Manager help file also work on Linux, though some parameters many need to be adjusted e.g. any parameter that lists the location of a file (e.g. for an SSL certificate) will be specified as a UNIX path rather than a Windows path.
All ODBC drivers are 64-bit.
A few drivers provide GUI setup libraries for use with ODBCConfig (the unixODBC equivalent of Window's ODBC Administrator), but since that application is difficult to obtain and install and supported by only a few drivers, all configuration is done by editing text files (e.g. /etc/odbcinst.ini and /etc/odbc.ini).
StarSQL and the SQDR bundled ODBC drivers are included in the sqdr installer and the Docker container and require StarQuest licenses SQ and DD. Use the starlic-config menu-driven application (in /opt/stelo/starsql64/bin) to add licenses for SQ and DD, as well as for product codes DR and $*. The license information is stored in /etc/starlicense.rc, and licensing can be tested with the application /opt/stelo/starsql64/bin/starlic-tester.
All drivers were tested on Red Hat/Oracle 8.x systems.
SSL connectivity may require additional configuration e.g. installing the CA (Certificate Authority) certificate of the Certificate Authority, which will vary by driver (e.g. StarSQL uses OpenSSL, IBM DB2 ODBC driver uses IBM GSKit, IBM Informix ODBC driver can use either OpenSSL or GSKit, chosen at installation time).
To verify connectivity you can use simpleconn (from StarSQL) or isql/iusql (part of unixODBC).