SQLServer Reader

SqlServerReader plugin is used to read data from SQLServer.

Configuration Example

Configure a job to synchronize and extract data from SQLServer database to local:

{
  "job": {
    "setting": {
      "speed": {
        "byte": -1,
        "channel": 1
      }
    },
    "content": {
      "reader": {
        "name": "sqlserverreader",
        "parameter": {
          "username": "root",
          "password": "root",
          "column": [
            "*"
          ],
          "splitPk": "db_id",
          "connection": {
            "table": [
              "table"
            ],
            "jdbcUrl": "jdbc:sqlserver://localhost:3433;DatabaseName=dbname"
          }
        }
      },
      "writer": {
        "name": "streamwriter",
        "parameter": {
          "print": true,
          "encoding": "UTF-8"
        }
      }
    }
  }
}

Parameters

This plugin is based on RDBMS Reader, so you can refer to all configuration items of RDBMS Reader.