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 https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list > /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
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 is flexibile, you can:
Deploy our Application Platform on AWS, Microsoft Azure, Google Cloud Platform (GCP), Kubernetes, private cloud.
G8CC's flexibility allows you to manage your data building trust. That empowers you to add value to your data across traditional borders.
Remove duplicated effort and wastage. Harness and build on the value of digital and data, reducing delivery and ongoing costs.