python-cli-sqlserver-ssl-to-elasticsearch-client-pop

Description

Reads a single node for data in pop-demo document.

Uses pop table then covverts it to json for elasticsearch to use.

Sql server uses self-signed ssl.

Tech stack

• python
  • pymssql
  • sqlalchemy
• elasticsearch
• kibana
• mssql

Docker stack

• alpine:edge
• python
• elasticsearch
• kibana
• mcr.microsoft.com/mssql/server:2017-CU17-ubuntu

To run

sudo ./install.sh -u

To stop (optional)

sudo ./install.sh -d

For help

sudo ./install.sh -h

Credit

• Docker setup
• Search setup