Step-by-Step Guide to Adding Extract in Oracle GoldenGate 21c Part -4

Microservices Architecture (MA)

Adding an Extract in Oracle GoldenGate 21c Microservices Architecture can be done via the Administration Service Console (Web UI) or the Admin Client (Command Line).

Method 1: Administration Service Console (Web UI)

1.     Log in to the Oracle GoldenGate Administration Service URL.

2.     Navigate to the Overview page.

3.     Click the + (plus) button next to Extracts to open the Add Extract wizard.

4.     Select Extract Type

   Choose Integrated Extract (most common for Oracle) or Initial Load Extract.

   Click Next.

5.     Basic Information

   Name: Up to 8 characters

   Description: Optional

   Intent: Select Unidirectional, High Availability, etc.

   Begin Note: Select NOW, Custom Time, or CSN

6.     Trail File

   Specify the Trail Name (two characters, e.g., et)

7.     Source Database Credential

   Select the Credential Domain and Alias created in prerequisites

8.     Registration Info (Oracle)

   Select Register Extract in the background for automated registration

   Or configure a specific CSN/SCN for initial load

9.     Parameter File

   Add the necessary table configurations, for example:

   TABLE schema_name.table_name;

10.Click Create and Run

   (or click Create to start it later)

 

Method 2: Admin Client (Command Line)

 

In Oracle GoldenGate Microservices Architecture, the Admin Client is a command-line utility used to manage and control GoldenGate processes. It works similarly to the classic GGSCI, but interacts with the Administration Service instead of local processes.

This method is commonly used to register and manage Extract processes in Oracle source databases.

Step 1: Start Admin Client

Navigate to the GoldenGate home directory and start the Admin Client.

  
  cd $OGG_HOME/bin
  ./adminclient
  
      

Step 2: Connect to Administration Service

Connect to the GoldenGate Administration Service using the deployment details. 

CONNECT https://<admin_host>:<port> DEPLOYMENT  AS  PASSWORD 

Ex:

CONNECT https://oggserver:8001 AS oggadmin PASSWORD Welcome123
    

 

Step 3: Log in to Database

Log in to the source database using a credential alias created earlier.

DBLOGIN USERIDALIAS 

Ex:

DBLOGIN USERIDALIAS DEV domain GG
    

 

Step 4: Register the Extract (Required for Oracle)

For Oracle databases, Extract registration is mandatory to enable integrated capture.

REGISTER EXTRACT 
    

 

Step 5:Register Extract (Trail)

Register the Extract explicitly for transaction log capture.

REGISTER EXTRACT  TRANLOG
    

 

Step 6: Add the Extract

Create the Extract process in Integrated mode, starting from the current time.

 

  
ADD EXTRACT  INTEGRATED TRANLOG, BEGIN NOW
  
  

 

Step 7: Add Local Trail

Define the local trail file where Extract writes captured data.

 

ADD EXTTRAIL , EXTRACT 
    

 

Step 8: Edit Parameter File

Open the Extract parameter file for editing.

EDIT PARAMS 
    

Step 9: Add content (inside parameter file)

Add the required table or schema mappings inside the parameter file.

  
TABLE <schema>.<table_name>
TABLE HR.EMPLOYEES;
   

 

Step 10: Start Extract

START EXTRACT <ext_name>