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 26.1.1.1.0 or later.
- The GoldenGate release is 23.1 or later. The GoldenGate parallel Replicat process, which can improve replication throughput in some use cases. You can 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 |
|---|---|---|
| Install 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 AI Database |
| Install and configure 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. | Overview of the Installation Process in TimesTen Classic in the Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide |
| Choose 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 |
| Install and configure 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) |
| Install GoldenGate at the source and target databases | Install and prepare the source and target databases for use with GoldenGate. | Installing Oracle GoldenGate in the Microservices Architecture Documentation. |
| Tasks for Setting up a GoldenGate Caching Environment | ||
| Create Oracle database users and tables | Create Oracle users and tables and grant the necessary privileges. | Task 1: Create Oracle Users and Tables |
| Configure GoldenGate for data extraction | Configure GoldenGate data capture for the source database tables that you wish to cache in TimesTen. | Task 2: Prepare Oracle Database for GoldenGate Extraction |
| Create TimesTen database users and tables | Create the TimesTen users and tables that you wish to cache from the source database. Grant the necessary privileges. | Task 3: Create TimesTen Users and Tables |
| Configure GoldenGate for data replication | Configure the GoldenGate apply mechanism (Replicat process) for the TimesTen database tables that correspond to the source database tables | Task 4: Prepare TimesTen Database for GoldenGate Replication |
| Perform 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. | Task 5: Perform the Initial Data Load |
| Verify that replication is working | Activate GoldenGate continuous real-time replication to provide ongoing data change synchronization from the source database to TimesTen. | Task 6: Verify GoldenGate Replication |