1. Microservices Architecture Documentation
  2. Prepare
  3. Prepare Databases
  4. TimesTen
  5. Prepare Database Connection

Prepare Database Connection

Learn about configuring database connections for Oracle GoldenGate for TimesTen.

Choosing the Oracle TimesTen Connectivity Type

Oracle TimesTen supports two distinct connectivity types for tools, utilities and applications; Direct mode and Client-Server mode.

Oracle GoldenGate supports both types of connectivity for Oracle TimesTen, so you can use whichever is most appropriate, based on your requirements.

Direct mode

Direct mode is a highly optimized local connectivity mechanism that eliminates interprocess communication (IPC) between the application and the database. It provides low latency and high throughput with low overhead. With Direct mode, the client application and the database must reside on the same host.

Client-Server mode

Client-Server mode is a traditional TCP/IP based connection mechanism. In this mode, the client application may reside on the same host as the database but more commonly it is installed on a different host and connects over the network. Client-Server mode has lower performance than Direct mode due to additional overhead and network latency.

Configure a DSN Connection in Linux

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 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). The sys.odbc.ini file is located in the tt_instance_home_/conf directory.

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 more information on defining Oracle TimesTen server and client DSNs, refer to Oracle® TimesTen In-Memory Database - Operations Guide .

The following is an example of a sys.odbc.ini entry to define a client DSN called ttrmtc, that connects to database server tthost.mydomain.com with port 6625, and server DSN myttdb. 


[ODBC Data Sources]
ttrmtc=TimesTen 22.1 Client Driver 
[ttrmtc]
TTC_SERVER=tthost.mydomain.com/6625
TTC_SERVER_DSN=myttdb

Note:

You can also set the ODBCINI environment variable with the location of the odbc.ini file during the Oracle GoldenGate Microservices Architecture installation. However, the sys.odbc.ini environment variable takes precedence over odbc.ini. If the DSN is not found in the sys.odbc.ini file then the odbc.ini file is searched for the DSN value.

To set up the database connection from Oracle GoldenGate for a TimesTen deployment after the DSN entry has been created, see Add Database Connections.