Oracle GoldenGate · Arazzo Workflow

Oracle GoldenGate Create and Start Replicat With Checkpoint

Version 1.0.0

Create a credential alias, create a Replicat with a checkpoint table, and start it.

1 workflow 2 source APIs 1 provider
View Spec View on GitHub CDCData IntegrationData SynchronizationDatabaseEnterpriseReal-Time ReplicationArazzoWorkflows

Provider

oracle-goldengate

Workflows

create-and-start-replicat-with-checkpoint
Register a credential, create a checkpointed Replicat, and start it.
Creates a credential alias, creates a parallel Replicat bound to that alias and a checkpoint table, and starts the process.
3 steps inputs: alias, authorization, checkpointTable, config, domain, password, replicat, trail, userid outputs: replicatName, startMessage
1
createCredential
Create the credential alias the Replicat will use to connect to the target.
2
createReplicat
Create a parallel Replicat bound to the credential alias, the source trail, and the checkpoint table.
3
startReplicat
Issue a START command to the newly created Replicat process.

Source API Descriptions

Arazzo Workflow Specification

Raw ↑
arazzo: 1.0.1
info:
  title: Oracle GoldenGate Create and Start Replicat With Checkpoint
  summary: Create a credential alias, create a Replicat with a checkpoint table, and start it.
  description: >-
    Stands up a fully credentialed apply process. It registers a credential
    alias, creates a parallel Replicat that references the alias and a checkpoint
    table, and issues a START command so the process begins applying changes.
    Every step spells out its request inline so the flow can be read and executed
    without opening the underlying OpenAPI description.
  version: 1.0.0
sourceDescriptions:
- name: credentialsApi
  url: ../openapi/oracle-goldengate-credentials-api-openapi.yml
  type: openapi
- name: replicatsApi
  url: ../openapi/oracle-goldengate-replicats-api-openapi.yml
  type: openapi
workflows:
- workflowId: create-and-start-replicat-with-checkpoint
  summary: Register a credential, create a checkpointed Replicat, and start it.
  description: >-
    Creates a credential alias, creates a parallel Replicat bound to that alias
    and a checkpoint table, and starts the process.
  inputs:
    type: object
    required:
    - authorization
    - domain
    - alias
    - userid
    - password
    - replicat
    - trail
    - checkpointTable
    - config
    properties:
      authorization:
        type: string
        description: HTTP Basic Authorization header value.
      domain:
        type: string
        description: Credential store domain name.
      alias:
        type: string
        description: Credential alias to create.
      userid:
        type: string
        description: Database user ID including connect string.
      password:
        type: string
        description: Password for the database user.
      replicat:
        type: string
        description: Name of the Replicat process to create.
      trail:
        type: string
        description: Source trail file prefix the Replicat reads from.
      checkpointTable:
        type: string
        description: Checkpoint table in schema.table form.
      config:
        type: array
        items:
          type: string
        description: Replicat parameter file content lines.
  steps:
  - stepId: createCredential
    description: Create the credential alias the Replicat will use to connect to the target.
    operationId: createCredentialAlias
    parameters:
    - name: Authorization
      in: header
      value: $inputs.authorization
    - name: domain
      in: path
      value: $inputs.domain
    - name: alias
      in: path
      value: $inputs.alias
    requestBody:
      contentType: application/json
      payload:
        userid: $inputs.userid
        password: $inputs.password
    successCriteria:
    - condition: $statusCode == 201
    outputs:
      credentialAlias: $response.body#/alias
  - stepId: createReplicat
    description: >-
      Create a parallel Replicat bound to the credential alias, the source
      trail, and the checkpoint table.
    operationId: createReplicat
    parameters:
    - name: Authorization
      in: header
      value: $inputs.authorization
    - name: replicat
      in: path
      value: $inputs.replicat
    requestBody:
      contentType: application/json
      payload:
        type: parallel
        trail: $inputs.trail
        checkpointTable: $inputs.checkpointTable
        config: $inputs.config
        credentials:
          domain: $inputs.domain
          alias: $inputs.alias
    successCriteria:
    - condition: $statusCode == 201
    outputs:
      replicatName: $response.body#/name
      replicatStatus: $response.body#/status
  - stepId: startReplicat
    description: Issue a START command to the newly created Replicat process.
    operationId: issueReplicatCommand
    parameters:
    - name: Authorization
      in: header
      value: $inputs.authorization
    - name: replicat
      in: path
      value: $inputs.replicat
    requestBody:
      contentType: application/json
      payload:
        action: start
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      commandMessage: $response.body#/response/message
  outputs:
    replicatName: $steps.createReplicat.outputs.replicatName
    startMessage: $steps.startReplicat.outputs.commandMessage

Work with this as data

Every workflow 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 arazzo workflows

4 MCP tools reach this
  • find_arazzoBrowse and filter every workflow in the catalog.
  • 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 workflow
curl "https://apis.io/api/v1/arazzo/oracle-goldengate-create-and-start-replicat-with-checkpoint-workflow"
All arazzo workflows
curl "https://apis.io/api/v1/arazzo?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.