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