Sybase Reader

SybaseReader plugin implements reading data from Sybase.

Example

We can use Docker container to start a Sybase database

docker run -tid --rm  -h dksybase --name sybase \
   -p 5000:5000  ifnazar/sybase_15_7 bash /sybase/start

The following configuration reads this table to terminal:

{
  "job": {
    "setting": {
      "speed": {
        "bytes": -1,
        "channel": 1
      }
    },
    "content": {
      "reader": {
        "name": "sybasereader",
        "parameter": {
          "username": "sa",
          "password": "password",
          "column": [
            "*"
          ],
          "connection": {
            "jdbcUrl": "jdbc:sybase:Tds:127.0.0.1:5000/master",
            "table": [
              "dbo.ijdbc_function_escapes"
            ]
          }
        }
      },
      "writer": {
        "name": "streamwriter",
        "parameter": {
          "print": "true"
        }
      }
    }
  }
}

Save the above configuration file as job/sybase2stream.json

Execute Collection Command

Execute the following command for data collection

bin/addax.sh job/sybase2stream.json

Parameters

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