SQL SERVER 数据同步到StarRocks sqlsv_strks2.json

# SQL SERVER 数据同步到StarRocks  sqlsv_strks2.json 

# datax 脚本中代传入参数

{
    "job": {
        "setting": {
            "speed": {
                 "channel": 1
            },
            "errorLimit": {
                "record": 0,
                "percentage": 0
            }
        },
        "content": [
            {
                "reader": {
                    "name": "sqlserverreader",
                    "parameter": {
                        "encoding": "UTF-8",
                        "username": "zhanghu",
                        "password": "mima",
            "where": "",
                        "fieldDelimiter":"\u0001",
                        "connection": [
                            {
                                "querySql": [ "select * from dbo.test03 where id >= '$starid' and id < '$mid'"],
                                "jdbcUrl": [
                                     "jdbc:sqlserver://116.X.110.46:21433;DatabaseName=MyDB"
                                ]
                            }
                        ]
                    }
                },
               "writer": {
                    "name": "starrockswriter",
                    "parameter": {
                        "encoding": "UTF-8",
                        "username": "devuser",
                        "password": "devuser",
                        "database": "tmp",
                        "table": "stest002",
                        "column": [ "*" ],
                        "preSql": ["truncate table tmp.stest002"],
                        "postSql": [],
                        "fieldDelimiter":"\u0001",
                        "jdbcUrl": "jdbc:mysql://172.x.135.207:9030/",
                        "loadUrl": ["172.x.135.207:8039","172.x.135.208:8039","172.x.135.209:8039","172.x.135.210:8039","172.x.135.211:8039"],
                        "loadProps": {}
                    }
                }
            }
        ]
    }
}