This topic describes how to connect to a Microsoft SQL Server (MSSQL) from Domino. You must have network connectivity between Impala and your Domino deployment.
RUN pip install pymssql
. You must set up the following Domino environment variables to store secure information about your MSSQL connection.
+ See Secure Credential Storage to learn more about Domino environment variables.
+ See the pymssql documentation for detailed information about how to use the package. The following is an example of connecting to MSSQL with Python where the following is true:
You have set up environment variables noted previously.
The server hosts a database named
myDatawith a table named
from os import getenv import pymssql server = getenv("DB_SERVER") user = getenv("DB_USERNAME") password = getenv("DB_PASSWORD") conn = pymssql.connect(server, user, password, "myData") cursor = conn.cursor() cursor.execute('SELECT * FROM addresses') row = cursor.fetchone() while row: print("ID=%d, Name=%s" % (row, row)) row = cursor.fetchone() conn.close()
To interact with MSSQL databases from R, Domino recommends the RODBC library. You can use an alternative package if you’d like.
Use the following Dockerfile instructions to add the MSSQL drivers to your Ubuntu 16.04 environment.
RUN curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - RUN curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list RUN apt-get update RUN ACCEPT_EULA=Y apt-get install msodbcsql17
See Microsoft’s documentation for the Dockerfile instructions to add the MSSQL drivers to your Domino-supported Ubuntu environment.
See the RStudio RODBC documentation for information about how to use the package.