For the full list of supported remote data sources, see SAP Note 1868209 – SAP HANA Smart Data Access: Central Note. Information about supported configurations is normally provided in the SAP Product Availability Matrix on the SAP Support Portal, however, so far only ASE and IQ are listed. However, if you run into trouble, you will be informed to switch to a supported configuration. It does not mean that the other combinations do not work they probably work just fine. Supported means that this combination has been validated by SAP development. Microsoft ODBC driver for SQL Server on Linuxįor SAP HANA smart data access, the only supported configuration is Microsoft ODBC Driver 11 in combination with SQL Server 2012.
#LATEST ODBC DRIVER FOR SQL SERVER DRIVERS#
Supported ODBC Driver ConfigurationsĪt the time of writing, there are two ODBC drivers for SQL Server available for the Linux (and Windows) platform: version 11 and 13 (Preview). If you would like to have more detailed information, please read on. In the video tutorial below, I will show you in less than 10 minutes how this can be done. The topic of this blog is the installation and configuration of the Microsoft ODBC driver for SQL Server on Linux. and 2, that is, installing and configuring ODBC on the SAP HANA server.
In this series of blogs, I will provide more detailed information about how perform activity 1. In the SAP HANA Administration Guide, prerequisites and procedures are documented for each supported data source, but the information is intended as a simple guide and you will need ‘ to consult the original driver documentation provided by the driver manufacturer for more detailed information‘.
#LATEST ODBC DRIVER FOR SQL SERVER INSTALL#
At the SAP HANA Academy we are currently updating our tutorial videos about SAP HANA administration.