{
"job" : {
"content" : [ {
"reader" : {
"parameter" : {
"databaseName":"Hexie_Crm",
"tableList": ["dbo.sys_user"],
"username" : "sa",
"password" : "SGll19871003",
"cat" : "insert,delete,update",
"url" : "jdbc:sqlserver://10.10.86.235:1514;databaseName=Hexie_Crm",
"splitUpdate" : true,
"pavingData" : true,
"pollInterval" : 100,
"column": [
{
"name": "id",
"type": "int"
},
{
"name": "name",
"type": "varchar"
}
]
},
"table": {
"tableName": "souse_sys_user"
},
"name" : "sqlservercdcreader"
},
"transformer": {
"transformSql": ""
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"username": "root",
"password": "dev-mysql&&HeXieYiLiao!@#$%25%5E",
"connection": [{
"jdbcUrl": "jdbc:mysql://10.10.86.238:3306/crm-his-test?useSSL=false",
"table": [
"sys_user"
]
}],
"writeMode": "insert",
"flushIntervalMills": "3000",
"column": [{
"name": "id",
"type": "int"
},
{
"name": "name",
"type": "string"
}
]
},
"table": {
"tableName": "slink_sys_user"
}
}
} ],
"setting" : {
"speed" : {
"bytes" : 0,
"channel" : 1
}
}
}
}