Configuring ODBC on Linux

The following steps provide minimum settings required to connect Oracle GoldenGate processes. For more detailed information on the Oracle TimesTen Client and Server configuration and information, review the following Oracle TimesTen documentation:

https://docs.oracle.com/database/timesten-18.1/TTOPR/client_server.htm#TTOPR177

  1. Edit the $TIMESTEN_HOME/conf/sys.odbc.ini file.

    vi $TIMESTEN_HOME/conf/sys.odbc.ini

  2. Describe the data source in the template file. In the following example, TTCS_181 is used as the client name for which DBLOGIN and SOURCEDB and TARGETDB are used to connect to the database.
    [ODBC Data Sources]
    TTCS_181=TimesTen 18.1 Client Driver
  3. Set a logical server name for TTC_SERVER and use the server DSN value for the TTC_SERVER_DSN entry. The value of the TTC_SERVER_DSN must match the database specific server DSN that exists in the database server’s sys.odbc.ini file.
    [TTCS_181]
TTC_SERVER=ttRemoteDBServer_TT_181
TTC_SERVER_DSN=ttDatabaseDSN

  4. Edit the $TIMESTEN_HOME/conf/sys.ttconnect.ini file with the settings described in these steps.

    vi $TIMESTEN_HOME/conf/sys.ttconnect.ini

  5. Create an entry of the same logical server name that was used as the value of TTC_SERVER within the sys.odbc.ini file. In this example, ttRemoteDBServer_TT_181 is the entry name. Include an optional description value, and the required Network_Address and TCP_PORT values that point to the Oracle TimesTen database server and port.
    [ttRemoteDBServer_TT_181]
Description=TimesTen 
ServerNetwork_Address=server.company.com
TCP_PORT=6625
  6. From the Oracle GoldenGate directory on the target, verify the connection settings by running GGSCI and issuing the DBLOGIN command to log into the target database.
    DBLOGIN SOURCEDB database, USERID db_user [, PASSWORD pw [encryption options]]
    In this example:

    • 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