Create Python apps using SQL Server on SLES

In this section, you will get SQL Server 2017 running on SUSE Linux Enterprise Server (SLES). After that you will install the necessary dependencies to create Python apps with SQL Server

Step 1.1 Install SQL Server

Note: To ensure optimal performance of SQL Server, your machine should have at least 4 GB of memory.

1. Register the Microsoft Linux repository and add they keys

        sudo zypper addrepo -fc https://packages.microsoft.com/config/sles/12/mssql-server.repo
        sudo zypper --gpg-auto-import-keys refresh
   

2. Install SQL Server

        sudo zypper update
        sudo zypper install mssql-server
   

3. Setup your SQL Server

        sudo /opt/mssql/bin/mssql-conf setup
   

Microsoft(R) SQL Server(R) Setup

To abort setup at anytime, press Ctrl-C.

The license terms for this product can be downloaded from http://go.microsoft.com/fwlink/?LinkId=746388 and
found in /usr/share/doc/mssql-server/LICENSE.TXT.

Do you accept the license terms? If so, please type YES:
Please enter a password for the system administrator (SA) account:
Please confirm the password for the system administrator (SA) account:

You now have SQL Server running locally on your SLES machine! Check out the next section to continue installing prerequisites.

Step 1.2 Install Python and other required packages

Install Python

sudo zypper install python-pip python-devel gcc gcc-c++

You now have Python installed! The next section will walk you through getting the tools to interact with your database.

Step 1.3 Install the ODBC Driver and SQL Command Line Utility for SQL Server

SQLCMD is a command line tool that enables you to connect to SQL Server and run queries.

sudo zypper ar https://packages.microsoft.com/config/sles/12/prod.repo
sudo zypper update
exit
sudo ACCEPT_EULA=Y zypper install msodbcsql mssql-tools
sudo zypper install unixODBC-devel
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

After installing SQLCMD, you can connect to SQL Server using the following command:

sqlcmd -S localhost -U sa -P yourpassword
1> # You're connected! Type your T-SQL statements here. Use the keyword 'GO' to execute each batch of statements.

This how to run a basic inline query. The results will be printed to the STDOUT.

sqlcmd -S localhost -U sa -P yourpassword -Q "SELECT @@VERSION"

--------------------------------------------------------
Microsoft SQL Server vNext (CTP2.0) - 14.0.500.272 (X64) 
	Apr 13 2017 11:44:40 
	Copyright (c) Microsoft Corporation
    on Linux (SUSE Linux Enterprise Server 12 SP2)

1 rows(s) returned

Executed in 1 ns

You have successfully installed SQL Server Command Line Utilities on your SLES machine!

You have successfully installed the Python Driver on your SLES machine. You now have everything you need to start writing Python apps with SQL Server!