Configuring GoldenGate to Provide Cache Refresh Functionality for TimesTen Workflow
You can set up a caching environment between GoldenGate and TimesTen.
The following versions are used in this procedure and the examples:
- The source database is an Oracle database running a recent release (18c or later).
- The target database is TimesTen release 22.1.1.1.0 or later.
- The GoldenGate release is 21.3 or later. The GoldenGate parallel Replicat process, which can improve replication throughput in some use cases, is supported with GoldenGate 21.3 and higher. You install GoldenGate on the same machine as the source database.
The tasks for setting up a GoldenGate caching environment with TimesTen are as follows:
| Task | Description | More Information |
|---|---|---|
| Installing Oracle database | Install, configure, and prepare the source database. In most scenarios, the source database already exists and contains the tables that you desire to cache. | Installing Oracle Database |
| Installing GoldenGate at the source database | Install and prepare the source database for use with GoldenGate. | Installing Oracle GoldenGate Classic Architecture |
| Configuring GoldenGate data capture | Configure GoldenGate data capture for the source database tables that you wish to cache in TimesTen. | Configuring Oracle GoldenGate |
| Choosing on-box or off-box deployment | Decide if you will run the GoldenGate apply processes on the same host as the target TimesTen database (an on-box deployment) or on a different host to the target TimesTen database (an off-box deployment). | Choosing On-Box or Off-Box for Deployment of a GoldenGate Replicat Process |
| Installing and configuring target TimesTen database | In general, deploy the cache on a different host from the source database, which is the host where the application processes run. | Installing and Configuring Target TimesTen Database |
| Creating database users and tables in TimesTen | Create the TimesTen users and tables that you wish to cache from the source database. Grant the necessary privileges. | Creating TimesTen Database Users and Tables |
| Installing and configuring TimesTen client instance | If you have chosen an off-box deployment, install a TimesTen client instance on the GoldenGate apply host and configure it to connect to the TimesTen database. | Installing and Configuring a TimesTen Client Instance (for Off-Box Deployments Only) |
| Configuring GoldenGate data apply | Configure the GoldenGate apply mechanism (Replicat process) for the TimesTen database tables that correspond to the source database tables | Configuring GoldenGate Data Apply |
| Performing an initial data load | Perform an initial data load to populate the TimesTen cache tables from the corresponding source database tables. This process usually involves some GoldenGate specific actions as well as the actual data loading. | Performing an Initial Load |
| Starting GoldenGate real-time replication | Activate GoldenGate continuous real-time replication to provide ongoing data change synchronization from the source database to TimesTen. | Starting GoldenGate Continuous Real-Time Replication |