Skip to Content

MS-SQL non-sap source system replication to HANA using SLT

Extract unixodbc2.3.0(pick the one compatible with the version of the OS) to a folder and

./unixODBC-2.3.0/configure –prefix=/home/sidadm/unixobdc_2.3.0

Run make command

Run make install

From sql server driver extract folder execute

./ verify

If all ok, install the driver

Cd /home/sidadm/msodbcsql-11.0.2260.0

./ install –force


Set the following env variables



Add to PATH the location of odbcinst


Test the connection


sqlcmd-11.0.2260.0 -Stcp:<sqlservername> -U<username> -P<password> -Q”select @@version”

Now setup db connection in SLT

Create a database connection and test


Create a new configuration from SLT using LTR transaction







Create the report as per the below note and run the report for the mass transfer id for the source

1751323 – Hana LTR : Non Sap Replication-Update DD02L and DD02T tables

Be the first to leave a comment
You must be Logged on to comment or reply to a post.