capabilities.work

Provision Extract Pipeline

A 4-step recipe with Oracle GoldenGate. We can help you get access.

Recipe · 4 steps

Provision Extract Pipeline

with Oracle GoldenGate

Register a credential alias then create, start, and verify an Extract process.

  1. Create the credential alias the Extract will use to connect to the source database.
  2. Create a change-data-capture Extract that references the credential alias and writes to the supplied trail.
  3. Issue a START command to the newly created Extract process.
  4. Poll the Extract runtime status until it reports running, branching back to retry while it is still starting.
What you'll need to have ready
  • authorization: HTTP Basic Authorization header value (e.g. "Basic dXNlcjpwYXNz").
  • domain: Credential store domain name.
  • alias: Credential alias to create.
  • userid: Database user ID including connect string.
  • password: Password for the database user.
  • extract: Name of the Extract process to create.
  • trail: Trail file prefix the Extract writes to (e.g. aa).
  • config: Extract parameter file content lines.
For your developer

Arazzo workflow oracle-goldengate:provision-extract-pipeline, 4 operations: createCredentialAlias → createExtract → issueExtractCommand → getExtractStatus. Specs on APIs.io.

More recipes with Oracle GoldenGate

Create and Start Replicat With CheckpointValidate Credential Then Create ExtractHealth Check and Process InventoryProvision DeploymentProvision Distribution PathProvision Replicat PipelineRestart Abended ExtractSet Up Source ConnectionStart Extract and VerifyStart Replicat and Verify