DB connectivity from Linux to SQL Server (DBCO)

DB connectivity from Linux to SQL Server (DBCO)

Hello all,

I want to provide you the required steps (with the help of my colleagues from team) in order to create a connection between a SAP system running on Linux (SuSe in my case) and external SQL server. For the SAP system level configuration (DBCO transaction entry needed), you can check the note 178949 – MSSQL: Database MultiConnect . Main note for this activity: 1644499 – Database connectivity from Linux to SQL Server

My Linux version:

root-> cat /etc/SuSE-release

SUSE Linux Enterprise Server 11 (x86_64)

VERSION = 11

PATCHLEVEL = 4

1- Check you SAP Kernel, if dbmssslib.so file is in place. Make sure that mentioned packages in the note already installed:

root-> cd /sapmnt/SID/exe/uc/linuxx86_64/

root-> ls -ltr dbmssslib.so

-rwxr-xr-x 1 sidadm sapsys 1820217 Oct 30  2015 dbmssslib.so

root-> rpm -q glibc

glibc-2.11.3-17.90.4

….

2- Download ODBC Driver from this address:

• http://www.microsoft.com/en-us/download/confirmation.aspx?id=34687

3- Download unixODBC component from this address:

• ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.0.tar.gz

4- Create a temporary directory and copy those 2 downloaded files there. Then extract and build in following order:

root-> mkdir /tmp/MSSQL_ODBC

root-> gunzip msodbcsql-11.0.2260.0.tar.gz

Copy unixODBC under the new folder:

root-> cp unixODBC-2.3.0.tar.gz ./msodbcsql-11.0.2260.0/

Build it:

root-> cd ./msodbcsql-11.0.2260.0

root-> ./build_dm.sh –download-url=file://unixODBC-2.3.0.tar.gz

5- Install unixODBC:

root-> cd /tmp/unixODBC.10010.13772.354/unixODBC-2.3.0

root-> make install

Making install in extras

make[1]: Entering directory `/tmp/unixODBC.10010.13772.354/unixODBC-2.3.0/extras’

make[2]: Entering directory `/tmp/unixODBC.10010.13772.354/unixODBC-2.3.0/extras’

make[2]: Nothing to be done for `install-exec-am’.

root-> ./install.sh verify

root-> ./install.sh install –force

Check if ODBC properly installed:

root-> odbcinst -q -d -n “ODBC Driver 11 for SQL Server”

[ODBC Driver 11 for SQL Server]

Description=Microsoft ODBC Driver 11 for SQL Server

Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0

Threading=1

UsageCount=1

You can execute ADBC_TEST_CONNECTION report for testing the connection:

Other useful links and even a video from SAP:

http://scn.sap.com/community/hana-in-memory/blog/2016/04/15/microsoft-odbc-driver-for-sql-server-on-linux–by-the-sap-hana-academy

https://www.youtube.com/watch?v=npgNjSNXG2Q

http://scn.sap.com/docs/DOC-68640

http://scn.sap.com/docs/DOC-56997

http://scn.sap.com/community/sqlserver/blog/2013/01/19/how-to-access-an-external-microsoft-sql-server-database

http://help.sap.com/saphelp_hana_options_sds_conf/helpdata/en/e7/83b19c6f0f10149a438f15eda0ba9f/content.htm