support-mssql.md

How to support MS SQL

Contents

1. Command line interface
2. Docker

Command line interface

1. Install the Microsoft ODBC driver for SQL Server (Linux)

2. Set environment variables. Example:

   export ODBCSYSINI=/opt/microsoft/msodbcsql17/etc

Docker

Configuration

• SENZING_OPT_MICROSOFT_DIR
• SENZING_VOLUME

Specify MS SQL driver location

1. ✏️ Determine where to store MS SQL drivers. Examples:

   1. Example #1: A SENZING_VOLUME based approach.

      export SENZING_VOLUME=/opt/my-senzing
      export SENZING_OPT_MICROSOFT_DIR=${SENZING_VOLUME}/opt-microsoft

   2. Example #2: Direct specification.

      export SENZING_OPT_MICROSOFT_DIR=~/opt-microsoft

Install MS SQL drivers

1. Run container. Example:

   docker run \
     --env ACCEPT_EULA=Y \
     --rm \
     --volume ${SENZING_OPT_MICROSOFT_DIR}:/opt/microsoft \
     senzing/apt:1.0.0 -y install msodbcsql17

Set parameter for docker run

1. Construct parameter for docker run. Example:

   export SENZING_OPT_MICROSOFT_DIR_PARAMETER="--volume ${SENZING_OPT_MICROSOFT_DIR}:/opt/microsoft --env ODBCSYSINI=/opt/microsoft/msodbcsql17/etc"

References

1. GitHub project for senzing/apt