Installing and Configuring a TimesTen Client Instance (for Off-Box Deployments Only)

When using an off-box deployment, you need to prepare the host where GoldenGate for TimesTen will be installed.

1. Install TimesTen and then create a client instance. See Installation of TimesTen Classic on Linux or UNIX in the Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide.
2. Add a suitable client DSN to the client instance sys.odbc.ini file to enable connections to the target TimesTen database. See Define a DSN for the TimesTen Database.

   In this example, the client DSN is named cache1 and the host name where the TimesTen database is running is myttserver.example.com. The TimesTen server is listening on port 6625 (the default). This hostname must be resolvable on the client system through DNS or /etc/hosts and regular TCP connectivity must be functional between the client and server systems. Port 6625 on the server must not be blocked by a firewall. Note the setting for ConnectionCharacterSet.

   [ODBC Data Sources]
   cache1=TimesTen 26.1 Client Driver
    
   [cache1]
   TTC_SERVER=myttserver.example.com/6625
   TTC_SERVER_DSN=cache1
   ConnectionCharacterSet=AL32UTF8