Install Microsoft SQL Server ODBC Driver on Ubuntu 18.04 (Part 2).

The ODBC Driver uses the Open Database Connectivity interface to connect to Microsoft SQL Server.

Open Database Connectivity (ODBC) is a standard application programming interface (API). It is used to connect to database management systems (DBMS). ODBC aim is to make it independent of database systems and operating systems.

We will be using ODBC to connect to a Microsoft SQL Server 2019 DBMS. Microsoft SQL Server 2019 provides a relational database management system. It connects to NoSQL, Relational Databases and Big Data solutions.

This is the first of a three part series. In this part we install Microsoft SQL Server 2019 on Ubuntu. In this next part we install an ODBC driver to connect to SQL Server. The last part connects G8CC a middleware and distributed data sharing platform. This allows you to merge, govern and reuse data across traditional borders. That unlock data mobility and visibility.

We will install our ODBC driver for Microsoft SQL Server on the Ubuntu operating system. The Ubuntu version is 18.04 (Bionic).

This uses a Ubuntu terminal.

Step 1 - Installing Microsoft SQL Server ODBC driver.

First type "sudo su" into your terminal. This will prompt you for a password. This changes you to a root user. Next enter the following commands.

If you are following the three part series created by GARNET8 and installing the ODBC driver on the same node as you Microsoft SQL Server install you can skip the following calls. This is because you would have already added the APT-KEY and prop.list in the previous part.

curl | apt-key add -
curl > /etc/apt/sources.list.d/mssql-release.list

Now we have to update our Ubuntu operating system. Type the following:

sudo apt-get update

We can now install the ODBC driver. To do this type:

sudo apt-get install -y msodbcsql17

We now have our ODBC driver installed for Microsoft SQL server. We can now optionally install two tools to support our installation.

Step 2 - Installing SQL Server tools. (Optional)

Once complete you can optionally install SQL Server tools. These include sqlcmd and bcp. sqlcmd includes a command prompt to enter Transact-SQL statements. You can find out what else sqlcmd includes here. BCP copies data between Microsoft SQL server and file formats of your choice.

To start type the following,

sudo apt-get install -y mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

The first command installs the Microsoft SQL Server tools. The next three commands update our bash scripts.

Lastly we install the ODBC development headers.

sudo apt-get install unixodbc unixodbc-dev

You can now use ODBC to connect to a Microsoft SQL Server DBMS from G8CC. In the next part we will demonstrate how to connect and build views of data from G8CC.

If you'd like to Modernise your IT and reduce costs,

Contact GARNET8 Limited here today.

Connect and unlock value in your Microsoft SQL Server database with G8CC.

Your Data Hubs, Warehouses, Integration and Platforms have created the new silos. They rely on copying data from one system to another.

Your IT is blocking agility. It's complexit, wasteful and has a high cost. This block business change and value.

With G8CC you can:

Reuse, Re-purpose and extend data. It removes the need to copy data to another place. This vastly reduces complexity, unlocking business agility.

G8CC provides a middleware platform and distributed data sharing layer. It provides faster time to value, lowering ongoing costs.

G8CC is flexibile, you can:

Deploy anywhere.

Deploy our Application Platform on AWS, Microsoft Azure, Google Cloud Platform (GCP), Kubernetes, private cloud.

Access Management.

G8CC's flexibility allows you to manage your data building trust. That empowers you to add value to your data across traditional borders.

Save Money.

Remove duplicated effort and wastage. Harness and build on the value of digital and data, reducing delivery and ongoing costs.

Get started by: