Access Reader

AccessReader implements the ability to read data from Access databases, based on Addax RDBMS Reader.

Example

We download the test file AccessThemeDemo.zip, extract it to get the AccessThemeDemo.mdb file, which contains a tbl_Users table. We will synchronize the data from this table to the terminal.

The following configuration reads the table to the terminal:

{
  "job": {
    "setting": {
      "speed": {
        "byte": -1,
        "channel": 1
      }
    },
    "content": {
      "reader": {
        "name": "accessreader",
        "parameter": {
          "username": "root",
          "password": "",
          "column": [
            "*"
          ],
          "connection": {
            "table": [
              "tbl_Users"
            ],
            "jdbcUrl": "jdbc:ucanaccess:///Users/wgzhao/Downloads/AccessThemeDemo.mdb"
          },
          "where": ""
        }
      },
      "writer": {
        "name": "streamwriter",
        "parameter": {
          "encoding": "utf-8",
          "print": true
        }
      }
    }
  }
}

Save the above configuration file as job/access2stream.json

Execute Collection Command

Execute the following command for data collection

bin/addax.sh job/access2stream.json

Parameters

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