Linked Server to SAP HANA database.

  • Greetings all.  It's been a very long time, but I'm back.  Does anyone have experience with setting up a linked server to a SAP HANA database?  I have hanaclient-2.8.20-windows-x64 installed and a DSN created using the HDBODBC driver that comes with the client install.  I am able to use the DSN to connect with generic ODBC connections using RazorSQL, SAS, and Alteryx, where all they need is the DSN name, username, and password (no provider strings needed).  I don't see HDBODBC listed as a provider in the list of linked server providers, and I don't know if there is a Microsoft generic ODBC provider like the other applications I mentioned.  I'm almost strictly an SQL guy, so this stuff is a bit outside of my expertise.  I would greatly appreciate any help/advice I can get.  Thank you.

     

    Greg

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

  • I have never used SAP HANA but suspect you would be better with Polybase rather than a linked server.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply