Oracle GoldenGate Validation API

Validate connections and configurations

Operations 4

POST /services/configuration/groups/validate/{Id} Oracle Goldengate Validate a Compare Group #
POST /services/configuration/cps/validate/{Id} Oracle Goldengate Validate a Compare Pair #
POST /services/validate/connection Oracle Goldengate Validate Agent Connection #
POST /services/validate/connection/db Oracle Goldengate Validate Database Connection #

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

Other Resources

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-validation-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.

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

OpenAPI Specification

oracle-goldengate-validation-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  title: Oracle GoldenGate Veridata REST Validation 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: Validation
  description: Validate connections and configurations
paths:
  /services/configuration/groups/validate/{Id}:
    post:
      operationId: validateGroup
      summary: Oracle Goldengate Validate a Compare Group
      description: Validates the configuration of a compare group including connection and table accessibility.
      tags:
      - Validation
      parameters:
      - $ref: '#/components/parameters/groupIdParam'
      responses:
        '200':
          description: Validation result
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ValidationResult'
              examples:
                Validategroup200Example:
                  summary: Default validateGroup 200 response
                  x-microcks-default: true
                  value:
                    valid: '500123'
                    messages:
                    - severity: example_value
                      message: example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /services/configuration/cps/validate/{Id}:
    post:
      operationId: validateComparePair
      summary: Oracle Goldengate Validate a Compare Pair
      description: Validates the configuration of a compare pair including table and column accessibility.
      tags:
      - Validation
      parameters:
      - $ref: '#/components/parameters/comparePairIdParam'
      responses:
        '200':
          description: Validation result
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ValidationResult'
              examples:
                Validatecomparepair200Example:
                  summary: Default validateComparePair 200 response
                  x-microcks-default: true
                  value:
                    valid: '500123'
                    messages:
                    - severity: example_value
                      message: example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /services/validate/connection:
    post:
      operationId: validateAgentConnection
      summary: Oracle Goldengate Validate Agent Connection
      description: Tests connectivity to a Veridata agent.
      tags:
      - Validation
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ValidateConnectionRequest'
            examples:
              ValidateagentconnectionRequestExample:
                summary: Default validateAgentConnection request
                x-microcks-default: true
                value:
                  host: example_value
                  port: 10
      responses:
        '200':
          description: Validation result
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ValidationResult'
              examples:
                Validateagentconnection200Example:
                  summary: Default validateAgentConnection 200 response
                  x-microcks-default: true
                  value:
                    valid: '500123'
                    messages:
                    - severity: example_value
                      message: example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /services/validate/connection/db:
    post:
      operationId: validateDatabaseConnection
      summary: Oracle Goldengate Validate Database Connection
      description: Tests database connectivity through a Veridata agent.
      tags:
      - Validation
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ValidateDatabaseRequest'
            examples:
              ValidatedatabaseconnectionRequestExample:
                summary: Default validateDatabaseConnection request
                x-microcks-default: true
                value:
                  host: example_value
                  port: 10
                  databaseType: example_value
                  serviceName: example_value
                  username: example_value
                  password: example_value
      responses:
        '200':
          description: Validation result
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ValidationResult'
              examples:
                Validatedatabaseconnection200Example:
                  summary: Default validateDatabaseConnection 200 response
                  x-microcks-default: true
                  value:
                    valid: '500123'
                    messages:
                    - severity: example_value
                      message: example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
components:
  parameters:
    groupIdParam:
      name: Id
      in: path
      required: true
      description: Compare group identifier
      schema:
        type: integer
        format: int64
    comparePairIdParam:
      name: Id
      in: path
      required: true
      description: Compare pair 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'
  schemas:
    ValidateConnectionRequest:
      type: object
      required:
      - host
      - port
      properties:
        host:
          type: string
          example: example_value
        port:
          type: integer
          example: 10
    ErrorResponse:
      type: object
      properties:
        code:
          type: integer
          example: 10
        message:
          type: string
          example: example_value
    ValidateDatabaseRequest:
      type: object
      required:
      - host
      - port
      - databaseType
      properties:
        host:
          type: string
          example: example_value
        port:
          type: integer
          example: 10
        databaseType:
          type: string
          example: example_value
        serviceName:
          type: string
          example: example_value
        username:
          type: string
          example: example_value
        password:
          type: string
          format: password
          example: example_value
    ValidationResult:
      type: object
      properties:
        valid:
          type: boolean
          example: '500123'
        messages:
          type: array
          items:
            type: object
            properties:
              severity:
                type: string
              message:
                type: string
          example: []
  securitySchemes:
    basicAuth:
      type: http
      scheme: basic
      description: HTTP Basic authentication with Veridata credentials