mssql.conf

{
    "name":"mssql_reader",
    "batch_size": 100,
    "batch_interval": 3,
    "batch_try_times": 3, 
    "reader":{
        "mode":"mssql",
        "donefile_retention":"7",
        "read_from":"newest",
        "mssql_datasource":"server=127.0.0.1;user id=sa;password=123456;port=1433",
        "mssql_database":"database_name",
        "mssql_sql":"select * from tablename",
        "mssql_offset_key":"offset_key_name",
        "mssql_limit_batch":"100",
        "mssql_cron":"00 00 04 * * *",
        "mssql_exec_onstart":"true"
    },
    "parser":{
	    "name":"mssql_json",
        "type":"json"
    },
    "senders":[{
        "name":"pandora_sender",
        "sender_type":"pandora",
        "pandora_ak":"<your_qiniu_ak>",
        "pandora_sk":"<your_qiniu_sk>",
        "pandora_host":"https://pipeline.qiniu.com",
        "pandora_repo_name":"<your_pandora_repo>",
        "pandora_region":"nb",
	    "pandora_schema_free":"true"
}]
}