Oracle GoldenGate

Oracle GoldenGate Compare Pairs API

Manage compare pairs within groups

GitHub OpenAPI

Operations 6

POST /services/configuration/cps/group/{groupId} Oracle Goldengate Create Compare Pairs in a Group #
GET /services/configuration/cps/{Id} Oracle Goldengate Retrieve a Compare Pair #
PUT /services/configuration/cps/{Id} Oracle Goldengate Replace a Compare Pair #
DELETE /services/configuration/cps/{Id} Oracle Goldengate Delete a Compare Pair #
POST /services/configuration/cps/{Id}/colmap Oracle Goldengate Generate Column Mapping Pairs #
POST /services/configuration/cps/mappings Oracle Goldengate Generate Mapping Objects From Rules #

Documentation

📖
Documentation
https://docs.oracle.com/en/middleware/goldengate/core/21.3/oggra/index.html
📖
Authentication
https://docs.oracle.com/en/middleware/goldengate/core/21.3/oggra/authentication.html
📖
Documentation
https://docs.oracle.com/en/database/goldengate/core/26/oggra/index.html
📖
Authentication
https://docs.oracle.com/en/database/goldengate/core/26/oggra/authenticate.html
📖
GettingStarted
https://docs.oracle.com/en/database/goldengate/core/26/
📖
Documentation
https://docs.oracle.com/en/middleware/goldengate/big-data/21.3/gadbd/index.html
📖
GettingStarted
https://docs.oracle.com/en/middleware/goldengate/big-data/21.3/gadbd/getting-started.html
📖
Documentation
https://docs.oracle.com/en/middleware/goldengate/veridata/12.2.1.4/gvdug/index.html
📖
APIReference
https://docs.oracle.com/en/middleware/goldengate/veridata/12.2.1.4/gvdra/index.html
📖
Documentation
https://docs.oracle.com/en/database/goldengate/veridata/26/
📖
Documentation
https://docs.oracle.com/en-us/iaas/api/#/en/goldengate/latest/
📖
GettingStarted
https://docs.oracle.com/en/cloud/paas/goldengate-service/index.html
📖
Authentication
https://docs.oracle.com/en-us/iaas/Content/API/Concepts/apisigningkey.htm
📖
APIReference
https://docs.oracle.com/en-us/iaas/goldengate/doc/using-rest-api.html
📖
Documentation
https://docs.oracle.com/en/database/goldengate/stream-analytics/26/
📖
APIReference
https://docs.oracle.com/en/middleware/fusion-middleware/osa/19.1/ggsa-rest-api/quick-start.html
📖
GettingStarted
https://docs.oracle.com/en/database/goldengate/stream-analytics/26/
📖
Documentation
https://docs.oracle.com/en/database/goldengate/core/26/coredoc/distribute-datastream-rest-api.html

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/oracle-goldengate/refs/heads/main/openapi/oracle-goldengate-compare-pairs-api-openapi.yml

Other Resources

🔗
Tutorials
https://docs.oracle.com/en/database/goldengate/core/26/tutorials.html
🔗
ChangeLog
https://docs.oracle.com/en/database/goldengate/core/26/release-notes/
🔗
ChangeLog
https://docs.oracle.com/en/database/goldengate/veridata/26/gvdrn/index.html
🔗
SDKs
https://docs.oracle.com/en-us/iaas/Content/API/Concepts/sdks.htm
🔗
CLI
https://docs.oracle.com/en-us/iaas/Content/API/Concepts/cliconcepts.htm
🔗
Tutorials
https://docs.oracle.com/en/cloud/paas/goldengate-service/tutorials.html
🔗
ChangeLog
https://docs.oracle.com/en-us/iaas/releasenotes/services/goldengate/
🔗
SDKs
https://docs.oracle.com/en-us/iaas/tools/python/latest/api/golden_gate.html
🔗
ChangeLog
https://docs.oracle.com/en/database/goldengate/stream-analytics/26/release-notes/release-notes-goldengate-stream-analytics.pdf

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/oracle-goldengate-compare-pairs-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

oracle-goldengate-compare-pairs-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Oracle GoldenGate Veridata REST Compare Pairs API
  description: REST API for Oracle GoldenGate Veridata, a data comparison and repair solution that verifies data consistency between source and target databases. Provides operations for managing connections, compare groups, compare pairs, jobs, profiles, monitoring comparison results, and repairing out-of-sync data. Based on Oracle GoldenGate Veridata 23c REST API documentation.
  version: '1.0'
  contact:
    name: Oracle Support
    url: https://support.oracle.com
  license:
    name: Oracle Technology Network License
    url: https://www.oracle.com/legal/terms.html
  x-documentation:
  - url: https://docs.oracle.com/en/middleware/goldengate/veridata/23/ggvra/rest-endpoints.html
    description: Oracle GoldenGate Veridata REST API Reference
servers:
- url: https://{veridata-host}:{port}/veridata/v1
  description: Oracle GoldenGate Veridata server
  variables:
    veridata-host:
      default: localhost
      description: Veridata server host
    port:
      default: '8830'
      description: Veridata HTTPS port
security:
- basicAuth: []
tags:
- name: Compare Pairs
  description: Manage compare pairs within groups
paths:
  /services/configuration/cps/group/{groupId}:
    post:
      operationId: createComparePairs
      summary: Oracle Goldengate Create Compare Pairs in a Group
      description: Creates one or more compare pairs within a specific compare group.
      tags:
      - Compare Pairs
      parameters:
      - $ref: '#/components/parameters/groupIdPathParam'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/CreateComparePairsRequest'
            examples:
              CreatecomparepairsRequestExample:
                summary: Default createComparePairs request
                x-microcks-default: true
                value:
                  comparePairs:
                  - sourceSchema: example_value
                    sourceTable: example_value
                    targetSchema: example_value
                    targetTable: example_value
      responses:
        '201':
          description: Compare pairs created
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ComparePairList'
              examples:
                Createcomparepairs201Example:
                  summary: Default createComparePairs 201 response
                  x-microcks-default: true
                  value:
                    comparePairs:
                    - id: abc123
                      groupId: '500123'
                      sourceSchema: example_value
                      sourceTable: example_value
                      targetSchema: example_value
                      targetTable: example_value
                      profileId: '500123'
                      columnMappings: {}
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /services/configuration/cps/{Id}:
    get:
      operationId: getComparePair
      summary: Oracle Goldengate Retrieve a Compare Pair
      description: Returns the details of a specific compare pair including source and target table mappings.
      tags:
      - Compare Pairs
      parameters:
      - $ref: '#/components/parameters/comparePairIdParam'
      responses:
        '200':
          description: Compare pair retrieved
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ComparePair'
              examples:
                Getcomparepair200Example:
                  summary: Default getComparePair 200 response
                  x-microcks-default: true
                  value:
                    id: abc123
                    groupId: '500123'
                    sourceSchema: example_value
                    sourceTable: example_value
                    targetSchema: example_value
                    targetTable: example_value
                    profileId: '500123'
                    columnMappings:
                    - sourceColumn: example_value
                      targetColumn: example_value
                      dataType: example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
    put:
      operationId: replaceComparePair
      summary: Oracle Goldengate Replace a Compare Pair
      description: Replaces the configuration of an existing compare pair.
      tags:
      - Compare Pairs
      parameters:
      - $ref: '#/components/parameters/comparePairIdParam'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ReplaceComparePairRequest'
            examples:
              ReplacecomparepairRequestExample:
                summary: Default replaceComparePair request
                x-microcks-default: true
                value:
                  sourceSchema: example_value
                  sourceTable: example_value
                  targetSchema: example_value
                  targetTable: example_value
                  profileId: '500123'
      responses:
        '200':
          description: Compare pair replaced
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ComparePair'
              examples:
                Replacecomparepair200Example:
                  summary: Default replaceComparePair 200 response
                  x-microcks-default: true
                  value:
                    id: abc123
                    groupId: '500123'
                    sourceSchema: example_value
                    sourceTable: example_value
                    targetSchema: example_value
                    targetTable: example_value
                    profileId: '500123'
                    columnMappings:
                    - sourceColumn: example_value
                      targetColumn: example_value
                      dataType: example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
    delete:
      operationId: deleteComparePair
      summary: Oracle Goldengate Delete a Compare Pair
      description: Deletes a compare pair from its group.
      tags:
      - Compare Pairs
      parameters:
      - $ref: '#/components/parameters/comparePairIdParam'
      responses:
        '204':
          description: Compare pair deleted
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /services/configuration/cps/{Id}/colmap:
    post:
      operationId: generateColumnMappings
      summary: Oracle Goldengate Generate Column Mapping Pairs
      description: Automatically generates column mappings between source and target tables for a compare pair.
      tags:
      - Compare Pairs
      parameters:
      - $ref: '#/components/parameters/comparePairIdParam'
      responses:
        '200':
          description: Column mappings generated
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ColumnMappingList'
              examples:
                Generatecolumnmappings200Example:
                  summary: Default generateColumnMappings 200 response
                  x-microcks-default: true
                  value:
                    mappings:
                    - sourceColumn: example_value
                      targetColumn: example_value
                      dataType: example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /services/configuration/cps/mappings:
    post:
      operationId: generateMappingObjects
      summary: Oracle Goldengate Generate Mapping Objects From Rules
      description: Generates compare pair mappings based on mapping rules for automatic pair creation.
      tags:
      - Compare Pairs
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/MappingRulesRequest'
            examples:
              GeneratemappingobjectsRequestExample:
                summary: Default generateMappingObjects request
                x-microcks-default: true
                value:
                  sourceSchemaPattern: example_value
                  targetSchemaPattern: example_value
                  tablePattern: example_value
      responses:
        '200':
          description: Mapping objects generated
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MappingObjectList'
              examples:
                Generatemappingobjects200Example:
                  summary: Default generateMappingObjects 200 response
                  x-microcks-default: true
                  value:
                    mappings:
                    - sourceSchema: example_value
                      sourceTable: example_value
                      targetSchema: example_value
                      targetTable: example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
components:
  schemas:
    ColumnMapping:
      type: object
      properties:
        sourceColumn:
          type: string
          example: example_value
        targetColumn:
          type: string
          example: example_value
        dataType:
          type: string
          example: example_value
    ColumnMappingList:
      type: object
      properties:
        mappings:
          type: array
          items:
            $ref: '#/components/schemas/ColumnMapping'
          example: []
    ReplaceComparePairRequest:
      type: object
      properties:
        sourceSchema:
          type: string
          example: example_value
        sourceTable:
          type: string
          example: example_value
        targetSchema:
          type: string
          example: example_value
        targetTable:
          type: string
          example: example_value
        profileId:
          type: integer
          format: int64
          example: '500123'
    ComparePairList:
      type: object
      properties:
        comparePairs:
          type: array
          items:
            $ref: '#/components/schemas/ComparePair'
          example: []
    MappingObjectList:
      type: object
      properties:
        mappings:
          type: array
          items:
            type: object
            properties:
              sourceSchema:
                type: string
              sourceTable:
                type: string
              targetSchema:
                type: string
              targetTable:
                type: string
          example: []
    ErrorResponse:
      type: object
      properties:
        code:
          type: integer
          example: 10
        message:
          type: string
          example: example_value
    MappingRulesRequest:
      type: object
      properties:
        sourceSchemaPattern:
          type: string
          example: example_value
        targetSchemaPattern:
          type: string
          example: example_value
        tablePattern:
          type: string
          example: example_value
    CreateComparePairsRequest:
      type: object
      properties:
        comparePairs:
          type: array
          items:
            type: object
            required:
            - sourceSchema
            - sourceTable
            - targetSchema
            - targetTable
            properties:
              sourceSchema:
                type: string
              sourceTable:
                type: string
              targetSchema:
                type: string
              targetTable:
                type: string
          example: []
    ComparePair:
      type: object
      properties:
        id:
          type: integer
          format: int64
          example: abc123
        groupId:
          type: integer
          format: int64
          example: '500123'
        sourceSchema:
          type: string
          example: example_value
        sourceTable:
          type: string
          example: example_value
        targetSchema:
          type: string
          example: example_value
        targetTable:
          type: string
          example: example_value
        profileId:
          type: integer
          format: int64
          example: '500123'
        columnMappings:
          type: array
          items:
            $ref: '#/components/schemas/ColumnMapping'
          example: []
  parameters:
    comparePairIdParam:
      name: Id
      in: path
      required: true
      description: Compare pair identifier
      schema:
        type: integer
        format: int64
    groupIdPathParam:
      name: groupId
      in: path
      required: true
      description: Compare group identifier
      schema:
        type: integer
        format: int64
  responses:
    NotFound:
      description: Resource not found
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    Unauthorized:
      description: Authentication required
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    BadRequest:
      description: Bad request
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
  securitySchemes:
    basicAuth:
      type: http
      scheme: basic
      description: HTTP Basic authentication with Veridata credentials