Query SAP HANA from BizTalk
ODBC The easiest way to connect to a HANA table or view, is to use ODBC. BizTalk has an ODBC adapter, but to be honest, try to avoid using that to connect to HANA. It's not easy to use and you can't find alot of documentation about it. The best option is to setup a linked server in SQL Server. In the back, it also uses ODBC, but you will be able to query the data with the WCF-SQL adapter which is alot easier. Setup a linked server To be able to connect to HANA, you will need to install the SAP HANA Client. Watch out, there is a 32bit and a 64bit version. Make sure that you get the correct one. You can download this from the SAP support site, but you need an account. So find somebody who has an account and ask them to download the latest version and install it on your SQL server. Second step is to setup a new System DSN in the ODBC Data Source Administrator. In the next screen, enter a relevant name and description, and provide the server and port of your HANA ser...