Configuring the TimesTen ODBC Connectivity

Oracle GoldenGate for TimesTen connects to TimesTen using the ODBC API (TimesTen's native API). ODBC connectivity defines the concept of a Data Source Name (DSN). A DSN is a logical name which applications use to specify the parameters to be used for connecting to a target database.

When using Oracle GoldenGate for TimesTen, you will specify the DSN of the target TimesTen database in various Oracle GoldenGate configuration settings, such as the SOURCEDB clause of the DBLOGIN command. For example:

DBLOGIN SOURCEDB database, USERIDALIAS useralias

Here, the value given for database will be the DSN of the target TimesTen database.

When using the Direct mode connectivity, connections must reference a server DSN defined in the sys.odbc.ini file of the Oracle TimesTen instance that hosts the database (the server instance).

When using the Client-Server mode, connections must reference a client DSN defined in the sys.odbc.ini file of either the Oracle TimesTen instance that manages the database (the server instance) or, more commonly, in the sys.odbc.ini of an Oracle TimesTen client instance, such as an Oracle GoldenGate hub server.

For information on defining Oracle TimesTen server and client DSNs, refer to TimesTen In-Memory Database Operations Guide.

Here is an example of the sys.odbc.ini entries to define a client DSN (myttdbcs) that connects to a database identified by the server DSN myttdb located on the host tthost1.mydomain.com. The TimesTen server's default listener port on that host is 6625.

[ODBC Data Sources]
myttdbcs=TimesTen 18.1 Client Driver
[myttdbcs]
TTC_SERVER=tthost1.mydomain.com/6625
TTC_SERVER_DSN=myttdb
ConnectionCharacterSet=AL32UTF8