Configuring GoldenGate Data Apply

Ensure that your environment is set for your local TimesTen instance (server or client) and change your directory to the GoldenGate installation directory.

Start the GGSCI utility and use it to perform the following steps:
```
./ggsci
```
Start the manager process:
```
START MANAGER
```
Login to your TimesTen database using the DBLOGIN command. If you are using off-box deployment, use the client DSN; otherwise, use the server DSN. The following example uses the server DSN of cache1.
```
DBLOGIN SOURCEDB cache1, USERID cacheadmin, PASSWORD ttpwd
```
Create the GoldenGate checkpoint table. This is required for using a GoldenGate Replicat process with TimesTen. Choose a table name so that it does not conflict with your application tables:
```
ADD CHECKPOINTTABLE cacheadmin.gg_ckpt_table
```
Create a parallel Replicat group, which maximizes throughput. In this example, this group is called rep:
```
ADD REPLICAT rep, EXTTRAIL trail_name, PARALLEL, CHECKPOINTTABLE cacheadmin.gg_ckpt_table
```
The trail_name is the name of the remote trail that you specified for either the data pump or Extract process on the source server.
Create a parameter file for the Replicat group. In our example, this file should be gg_home/dirprm/REP.prm:
```
REPLICAT rep
TARGETDB cache1, USERID cacheadmin, PASSWORD ttpwd
MAP oratt.*, TARGET oratt.*;
```
Here oratt.* is the table owner and name on the source database, and oratt.* is the table owner and name in the TimesTen database. The table name should be same in both the source and the target databases. You can specify multiple MAP directives or use wildcards for multiple tables.

For off-box deployment, use the client DSN instead of the server DSN. You can also use a GoldenGate credential store and USERIDALIAS for password encryption. For more information, see Using Oracle GoldenGate with Oracle Database.

If you are using a parallel Replicat process include the following line before the MAP statements:
```
APPLY_PARALLELISM 4
```
You can experiment with the number of apply threads to see which value provides the most optimal throughput in your environment.

Add any other parameters in this file that apply to your database environment.

Note:

When using TimesTen native caching, one option you have is to cache a subset of a table (specific columns and/or rows). This is also possible with GoldenGate, but these details are not covered in this document.