This topic describes the systematic instructions to configure OCI GoldenGate.

1. Access the GoldenGate Console by follows:
   1. Use the Admin URL to access the GoldenGate console.
   2. Login using the GGADMIN credentials.

      Figure 2-42 Oracle GoldenGate Administration Service

      
      

      
      Description of "Figure 2-42 Oracle GoldenGate Administration Service"

      
      
   3. Click the Hamburger icon on the top left.

      Figure 2-43 Administration Service

      
      

      
      Description of "Figure 2-43 Administration Service"

      
      
   4. To setup the target DB connection in the OCI Golden Gate Admin console, then follow the process below:
      1. In the GoldenGate console, navigate to DB Connections.
      2. Click Create Connection.
      3. Select the database type as Oracle Database and provide connection details.
      4. Test the connection to ensure it is properly configured.

      From DB Connections, in the Actions column of your connection, click Connect to Database and scroll down to Checkpoint Option and Click “+” to add a new Checkpoint.

      Figure 2-44 Connection to DB

      
      

      
      Description of "Figure 2-44 Connection to DB"

      
      

      Figure 2-45 Checkpoint

      
      

      
      Description of "Figure 2-45 Checkpoint"

      
      

      Figure 2-46 Checkpoint Details

      
      

      
      Description of "Figure 2-46 Checkpoint Details"

      
      
2. Add User for Path Connection:
   • Add the user for the path connection. This user should be the same as the Operator User that was created earlier in the SaaS Self-Service UI.
   • In the Administration Service on the Left Menu’s scroll down to select Path Connection icon and Click on “+” to create a new Path Connection.
   • Enter the details as depicted in the image and click Submit.

   Figure 2-47 Path Connections

   
   

   
   Description of "Figure 2-47 Path Connections"

   
   

   Things to Consider for Path Connection Creation:

   • Credentials – <tenantenv>_ggnet> – The user ID and password are defined by the source OBCS SaaS replication configuration and are used to authenticate the credential alias.
   • This credential alias is exclusively used for the target-initiated distribution path between the source OBCS SaaS and the target OCI GoldenGate.
   • The user ID and password are securely shared by the OBCS SaaS team and must be stored as a credential alias on the target GoldenGate deployment.

   Note:

   Since the path connection uses basic authentication for establishing the distribution path between the extract and replicat, it is important to maintain the same credentials.

   If the username and/or password is modified without proper communication or update in both environments, the data replication process will break.

3. Create KMS profile( applicable only for BYOK opted customers). This is the OCI vault details which was shared to OBCS SaaS. For creating the profile, follow the process below:
   1. In the GoldenGate console, navigate to Encryption andselect Profile.
   2. In the Oracle Cloud Infrastructure section Click “+” to add a new profile.

   Figure 2-48 Create an Encryption Profile

   
   

   
   Description of "Figure 2-48 Create an Encryption Profile"

   
   
4. Create Replicat, by following the process below:
   1. In the OCI GoldenGate Admin console, navigate to Administration Service, and click Home.
   2. Click Add next to Replicats to create a Replicat task that will apply data to the target database.
   3. In the Replicat Options provide the details as instructed below,
      • TrailName : This can be the same trail name used in the SaaS Self-Service UI, or the user can specify a different trail name. The same trail name must be used later when creating the Target-Initiated Path to ensure proper linkage between the source and target environments.
      • Encryption Profile: Select the appropriate encryption profile based on your configuration:
        • LocalWallet – For non-BYOK (Bring Your Own Key) users.
        • Desired Profile – For BYOK users, select the encryption profile created under KMS Profile Management.
      • Target Credentials: Select the desired Target Credentials and its corresponding Credential Alias from the list.
      • Checkpoint Table: Select the desired Checkpoint from the list.
      • Parameter File: Create the parameter file as per the requirement and Click Create to create the Replicat.

   Figure 2-49 Administration Service Home

   
   

   
   Description of "Figure 2-49 Administration Service Home"

   
   

   Figure 2-50 Replicat Type

   
   

   
   Description of "Figure 2-50 Replicat Type"

   
   

   Figure 2-51 Replicat Options

   
   

   
   Description of "Figure 2-51 Replicat Options"

   
   
5. To Start the Replicat, click on the Play button in the Actions column.