Supported ODBC Driver

Starting from Oracle GoldenGate release 21.12, Oracle GoldenGate for Db2 for i supports the IBM i Access ODBC Driver 64-bit version 1.1.0.27 or higher.

See Linux, macOS, and PASE Application Packages for more information on IBM i Access ODBC Driver and follow the steps provided to install IBM i Access application package for the Linux operating system.

In addition, install unixODBC driver manager to be used with the Db2 ODBC driver on all supported Linux operating systems. For example, to install the unixODBC driver manager on the Red-Hat Linux operating system, use the yum command. See Installing the unixODBC driver manager for more information.

After the IBM i Access ODBC Driver and the unixODBC driver manager are installed successfully, add appropriate values in the odbcinst.ini and odbc.ini files to register the driver and the system.

You can test if the DSN and drivers are configured properly by testing the connection using the isql command. For example:

isql -v DSN user password