Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note

This topic is WIP-DRAFT.

Use the CDAP Replication Microservices to manage replication jobs.

...

Code Block
{
  "name": "<app_name>",
  "artifact": {
    "name": "delta-app",
    "version": "0.6.1",
    "scope": "SYSTEM"
  },
  "config": {
    "tables": [
      {
        "database": "testreplication",
        "table": "persons",
        "schema": "dbo"
      }
    ],
    "stages": [
      {
        "name": "Microsoft SQLServer",
        "plugin": {
          "name": "sqlserver",
          "type": "cdcSource",
          "properties": {
            "port": "1433",
            "serverTimezone": "UTC",
            "replicateExistingData": "true",
            "user": "<>",
            "password": "<>",
            "host": "1.2.3.4",
            "jdbcPluginName": "sqlserver42",
            "database": "testreplication"
          },
          "artifact": {
            "name": "sqlserver-delta-plugins",
            "version": "0.6.1",
            "scope": "SYSTEM"
          }
        }
      },
      {
        "name": "BigQuery",
        "plugin": {
          "name": "bigquery",
          "type": "cdcTarget",
          "properties": {
            "project": "auto-detect",
            "serviceAccountKey": "auto-detect",
            "stagingBucketLocation": "us",
            "loadInterval": "90",
            "stagingTablePrefix": "staging",
            "requireManualDrops": "false",
            "datasetName": "testreplication1"
          },
          "artifact": {
            "name": "bigquery-delta-plugins",
            "version": "0.6.1",
            "scope": "SYSTEM"
          }
        }
      }
    ],
    "tableTransformations": [],
    "parallelism": {
      "numInstances": 1
    },
    "description": "<>"
  }
}

Delete a Draft Replication Job

...