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.

Create a TimesTen installation and from that a TimesTen client instance. See Installation of TimesTen Classic on Linux or UNIX in the Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide.

Add a suitable client DSN to the client instance sys.odbc.ini file to enable connections to the target TimesTen database that was configured in the Installing and Configuring Target TimesTen Database section.

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 22.1 Client Driver
 
[cache1]
TTC_SERVER=myttserver.example.com/6625
TTC_SERVER_DSN=cache1
ConnectionCharacterSet=AL32UTF8