- #Downloading oracle odbc manager how to#
- #Downloading oracle odbc manager driver#
- #Downloading oracle odbc manager software#
if everything goes well, you can find the ODBC driver file for Oracle in the unzipped directory, the file name is libsqora.so.xx.x. The default unzipped directory is instantclient_xx_x. Then decompress the two packages to a same folder with unzip command. Take Oracle as an example here, two zip packages should be downloaded: instantclient-basic-linux.圆4-xx.x.x.x.x.zip 和instantclient-odbc-linux.圆4-xx.x.x.x.x.zip, x stands for version number. Īfter downloading the ODBC driver, the driver can be installed according to relevant installation guide. Simba HiveODBC can be achieved from the Simba website. And the SAP official recommendation for Hive driver is the HiveODBC driver provided by Simba Technology. More details about connection between SAP HANA SDA and Hadoop in subsequent blogs in this series. As for Hadoop data source, SAP HANA SDA can communicate with it through Hive. For example, you can download ODBC driver for Oracle form website. The ODBC driver for the database productions, such as Sybase ASE and Oracle, can be downloaded from the official website of the database. So far, the data sources supported by SAP HANA SDA includes: SAP HANA, SAP Sybase ASE, Teradata database, Oracle, MS SQL Server and Hadoop. Installation of ODBC driver for data source unixODBC should be installed by now, you can execute “isql –version” to check whether the unixODBC is installed successfully. 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.
#Downloading oracle odbc manager software#
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.
#Downloading oracle odbc manager 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.
0 kommentar(er)
