If you don't have the SQL Server ODBC driver, please proceed with the installation and follow the instructions below.

Download the appropriate ODBC driver for SQL Server from the Microsoft Corp. website.

For RHEL 7 and Oracle Linux 7

  curl https://packages.microsoft.com/config/rhel/7/prod.repo | tee /etc/yum.repos.d/mssql-release.repo

For RHEL 8 and Oracle Linux 8

  curl https://packages.microsoft.com/config/rhel/8/prod.repo | sudo tee /etc/yum.repos.d/mssql-release.repo

For RHEL 9

  curl https://packages.microsoft.com/config/rhel/9/prod.repo | sudo tee /etc/yum.repos.d/mssql-release.repo

To avoid conflicts, run the following commands:

  sudo yum remove unixODBC-utf16 unixODBC-utf16-devel 
  sudo ACCEPT_EULA=Y yum install -y msodbcsql17

The following commands can be run optionally:

- for bcp and sqlcmd:

  sudo ACCEPT_EULA=Y yum install -y mssql-tools 
  
  echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
  source ~/.bashrc

- for unixODBC development headers:

  sudo yum install -y unixODBC-devel

Make sure that the connection is successful:

  # SQL Server on host_name
  # Microsoft SQL Server 2014 - 12.0.2000.8 (X64)   Feb 20 2014 20:04:26   Copyright (c) Microsoft Corporation  Express Edition (64-bit) on 
  Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
   
  sqlcmd -S host_name-U user_name -P pwd -d database_name

Then configure the ODBC connection as described in the ODBC Driver Configuration article.

If you have any questions or encounter any difficulties, please contact us at support@ispirer.com