docker-embulk-sqlserver

This repository is a sample using sqlserver plugin with embulk, it works on Docker.

Usage

Sample Configuration (config.yml)

in:
  type: sqlserver
  host: localhost
  user: myuser
  password: ""
  database: my_database
  table: my_table
  select: "col1, col2, col3"
  where: "col4 != 'a'"
  order_by: "col1 DESC"

filters:
  - type: column
    columns:
      - {name: col1}
      - {name: col2}

out:
  type: sqlserver
  host: localhost
  user: myuser
  password: ""
  database: my_database
  table: my_table
  mode: insert

You can run embulk from docker-compose

$ docker-compose run --rm embulk run config.yml

Plugin to use

Please refer to here for detailed settings

• embulk-input-jdbc/embulk-input-sqlserver at master · embulk/embulk-input-jdbc
• embulk-output-jdbc/embulk-output-sqlserver at master · embulk/embulk-output-jdbc
• sonots/embulk-filter-column: A filter plugin for Embulk to filter out columns