Connect to SAP HANA Data as a Linked Server

The SQL Gateway enables you to configure a TDS (SQL Server) remoting service and set up a linked server for SAP HANA data. 

After you have started the service, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server. You can then work with SAP HANA data just as you would a linked SQL Server instance. The CData SAP HANA drivers offer a data-centric model for SAP HANA that simplifies integration — allowing developers to build higher quality applications. 

Connect to SAP HANA as an ODBC Data Source 

If you have not already, first specify connection properties