oracle odbc driver configuration location for tnsnames

#ORACLE ODBC DRIVER CONFIGURATION LOCATION FOR TNSNAMES HOW TO#

Enter the folder specified in step 2, then execute the commands below in order:Ĥ.Login in the SAP HANA server as the root user, decompress the unixODBC package to specified folder.Download corresponding version of unixODBC package, the name of package is unixODBC-x.x.x.tar.gz, x here stands for version number.The process of installing unixODBC is below: Please note that the version of unixODBC needs to be 2.3.0 for SQL Server data source, and 2.3.1 or newer version is required for other data sources. Software package of unixODBC can be downloaded from website. Usually, the unixODBC is chosen as the driver manager for SAP HANA SDA. Since SAP HANA SDA communicates with remote data source using ODBC protocol, the ODBC driver manager must be installed in SAP HANA server side.

#ORACLE ODBC DRIVER CONFIGURATION LOCATION FOR TNSNAMES HOW TO#

In this article, we take the Oracle data source as an example to talk about how to install and configuration ODBC driver. For different SDA data sources, the process of installing and configuring ODBC driver is similar. Before adding remote data source for SDA, it is necessary to finish the installation and configuration the ODBC manager and ODBC driver for SDA date source in SAP HANA server side. In the blog “SAP HANA Smart Data Access (1):A brief introduction to SDA”, we introduced the architecture of SDA and talked about how to add remote data source for SDA in SAP HANA Studio. We have a Chinese version( SAP HANA Smart Data Access （二）-SDA 数据源驱动的安装与配置) of this blog.

Oracle odbc driver configuration location for tnsnames