SAP HANA directly connected to SQL Server database (Linux system)

 

1, install ODBC

https://docs.microsoft.com/zh-tw/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15#suse17

Pay attention to it, it is best to install firstmsodbcsqlInstall againmsodbcsql17

My is SUSE 12

sudo su
curl -O https://packages.microsoft.com/keys/microsoft.asc
rpm --import microsoft.asc

zypper ar https://packages.microsoft.com/config/sles/12/prod.repo
exit
sudo ACCEPT_EULA=Y zypper install msodbcsql
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y zypper install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo zypper install unixODBC-devel

 

If executed
zypper ref https://packages.microsoft.com/config/sles/12/Prod.repo
appear
Repository named ‘packages-microsoft-com-prod’ already exists. Please use another alias.
You can delete first.
zypper rr packages-microsoft-com-prop

 

 

 

 

Find a circle, mainly through the following webpage, create success

https://launchpad.support.sap.com/#/notes/1644499

https://www.cnblogs.com/StephenAmell/p/13473524.html