sql server 数据同步到文本中_datax模板

最新推荐文章于 2024-11-06 09:59:52 发布

shijiazhenghu

最新推荐文章于 2024-11-06 09:59:52 发布

阅读量189

点赞数 1

文章标签：服务器数据库运维大数据 etl工程师数据仓库

本文链接：https://blog.csdn.net/shijiazhenghu/article/details/142285672

版权

# sql server 数据同步到文本中_datax模板

{
"core": {
         "transport" : {
              "channel": {
                   "speed": {
                       "channel": 1,
                       "record": 5000,
                       "byte": 524288
                    }
               }
         }
  },
  "job": {
    "setting": {
      "speed": {
        "channel": 1,
        "record": 5000,
        "byte": 100       
      },
      "errorLimit": {
        "record": 0,
        "percentage": 0.00
      }
    },
    "content": [
      {
        "reader": {
          "name": "sqlserverreader",
          "parameter": {
            "connection": [
              {
                "jdbcUrl": [
                  "jdbc:sqlserver://prod.sqlservxxx;DatabaseName=BD_NAME"
                ],
                "querySql": [
                  "select * from dbo.TABLE_NAME;"                
                ]
              }
            ],
            "password": "MIMA",
            "username": "ROOT",
            "column": [
               
            ]
          }
        },
        "writer": {
          "name": "txtfilewriter",
          "parameter": {
              "encoding": "UTF-8",
              "path": "/bigdata/json_script/tmp",
              "fileName": "FILE_NAME",
              "writeMode": "truncate",
              "format": "yyyy-MM-dd",
              "fieldDelimiter":"|"
          }          
        }
      }
    ]
  }
}