1. Oracle GoldenGate Classic Architecture Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. Db2 for i
  5. Configuring Database Connections
  6. Configuring ODBC on Windows

Configuring ODBC on Windows

On Windows, the ODBC Administration tool is in the Administrative Tools folder as Data Sources (ODBC).

  1. Download and install the 32-bit or 64-bit iSeries Access ODBC driver from the DB2 for iSeries Access package on the remote Windows system according to the vendor documentation. The iSeries ODBC driver is supplied as a free component of iSeries Access.
  2. You can create a user DSN (a connection that is available only to the user that created it) or a system DSN (a connection that is available to all users on the system). To create a user DSN, log on to the system as the user that you will be using for the Replicat process.
  3. From the Windows Control Panel, select Administrative Tools, then Data Sources (ODBC).
  4. On the first page of the ODBC configuration tool, select the User DSN tab to create a user DSN or the System DSN tab to create a system DSN. (These steps create a user DSN; creating a system DSN is similar.)
  5. On the tab that you selected, click Add.
  6. Select the appropriate iSeries Access ODBC Driver from the list of drivers, and then click Finish.
  7. On the General tab of the DB2 for i Access for Windows ODBC Setup dialog, provide a name (without any spaces) in the Data Source Name field, add an optional description in the Description field, and then select the system name from the System selection list.
  8. On the Server tab, set Naming Convention to SQL Naming Convention (*SQL). Leave the other fields set to their defaults.
  9. On the Data Types tab, select the Report as Supported check box under Double Byte Character Set (DBCS) graphic data types.
  10. On the Conversions tab, clear the Convert binary data (CCSID 65535) to text check box.
  11. Click Apply, then OK. You are returned to the ODBC Data Source Administrator dialog.
  12. Confirm that the new Data Source Name appears under User Data Sources.
  13. Click OK to exit the ODBC configuration utility.
  14. From the Oracle GoldenGate directory on the target, run GGSCI and issue the DBLOGIN command to log into the target database. See Parameters and Functions Reference for Oracle GoldenGate for detailed syntax.
    DBLOGIN SOURCEDB database, USERID db_user [, PASSWORD pw [encryption_options]]

    Where:

    • SOURCEDB database specifies the new data source name.

    • USERID db_user, PASSWORD pw are the Replicat database user profile and password.

    • encryption_options is optional password encryption.

      Note:

      Only BLOWFISH encryption is supported for DB2 for i systems.