capabilities.work

Validate Credential Then Create Extract

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

Recipe · 3 steps

Validate Credential Then Create Extract

with Oracle GoldenGate

Create and validate a credential alias before creating an Extract that references it.

  1. Create the credential alias in the supplied domain.
  2. Validate the credential alias can connect, branching to create the Extract only when the result is valid.
  3. Create a CDC Extract bound to the validated credential alias.
What you'll need to have ready
  • authorization: HTTP Basic Authorization header value.
  • domain: Credential store domain name.
  • alias: Credential alias to create and validate.
  • 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.
  • config: Extract parameter file content lines.
For your developer

Arazzo workflow oracle-goldengate:validate-credential-then-extract, 3 operations: createCredentialAlias → validateCredentialAlias → createExtract. Specs on APIs.io.

More recipes with Oracle GoldenGate

Create and Start Replicat With CheckpointHealth Check and Process InventoryProvision DeploymentProvision Distribution PathProvision Extract PipelineProvision Replicat PipelineRestart Abended ExtractSet Up Source ConnectionStart Extract and VerifyStart Replicat and Verify