Configuring Remote Source connection (SDA) from HANA to MSSQL
来源:互联网 发布:我要直播网络电视网 编辑:程序博客网 时间:2024/06/08 10:23
I went through couple of blogs on the same topic , but didnt found anything specific to MSSQL configuration. Hence, i would like to present it in more details for configuring remote source connection from HANA to MSSQL.
What is HANA Smart Data Access (SDA) ?
SAP HANA smart data access enables remote data to be accessed. It enables remote data to be accessed as if they are local tables in SAP HANA, without copying the data into SAP HANA. Specifically, in SAP HANA, you can create virtual tables which point to remote tables in different data sources. Customers can then write SQL queries in SAP HANA, which could operate on virtual tables.
More details on SDA can be found in the below blog
Smart Data Access- A new feature by HANA
In this blog, I have defined the configuration of connecting the HANA DB to external MSSQL DB (HANA Admin View).
Steps for Configuring:
- Download the drivers Unix ODBC & Microsoft SQL
- Installing the drivers
- creating the .odbc.ini file and setting up the configuration.
- Restart the HANA
- Configure the remote source connection in HANA Studio.
Download the Drivers :
1. Goto link Download Microsoft® ODBC Driver 11 for SQL Server® – SUSE Linux Community Technology Preview from Official Microsoft Dow…
2. Download the Microsoft SQL Server ODBC Driver 11 for SQL Server by clicking one of the download buttons.
Installing the Drivers:
Install the unixODBC 2.3.0 Driver Manager
1. After downloading the drivers, you will be able to see msodbcsql-11.0.2260.0.tar.gz
2. Copy the downloaded drivers it to Linux server where HANA is installed.
3. Login as root user and decompress msodbcsql-11.0.2260.0.tar.gz –
tar -zxvf msodbcsql-11.0.2260.0.tar.gz
4. Change to the msodbcsql-11.0.2260.0 directory
cd ./msodbcsql-11.0.2260.0
5. You can install the driver manager by executing the following command
./build_dm.sh
6. Type “YES” to proceed with unpacking the files. This part of the process can take up to five minutes to complete
7. After the script stops running, follow the instructions on the screen to install the unixODBC Driver Manager.
This will complete the installation of UnixODBC drivers.
P.S: check the version of Unix ODBC by executing command >isql –version -> The output should be unixODBC 2.3.0
Install the Microsoft SQL Server ODBC Driver 11 for SQL Server
1. Change to the msodbcsql-11.0.2260.0 directory, where you can run install.sh to install the driver:
cd ./msodbcsql-11.0.2260.0
2. run the install script
./install.sh install
3. After reviewing the license agreement, type “YES” to continue with the installation.
4.Verify that Microsoft SQL Server ODBC Driver 11 For SQL Server was registered successfully:
odbcinst -q -d -n “ODBC Driver 11 for SQL Server”
5. To check the successful installation of drivers…type the below command
creating the .odbc.ini file and setting up the configuration:
As HANA requires the .odbc.ini file for communicating with remote source MSSQL. Hence, we need to create .odbc.ini file in $HOME directory.
1. Login with sidadm user and create .odbc.ini file -> vi .odbc.ini file
2. Create DSN as MSSQL
3. Server=nave of the server you want to connect and port number
4. Driver = Location of the ODBCsql driver.
P.S: your .odbc.ini file should look like above
5. Goto Home directory and open .sapenv.sh file and add the below line (Update the LD_LIBRARY_PATH)
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/opt/microsoft/msodbcsql/lib64
6. Restart SAP HANA
Configure the remote source connection:
From HANA Studio -> Provisioning -> Remote Source -> right click new remote source
Provide username and password of the remote MSSQL server for logon.
P.S: The following privileges are required to manage remote sources:
This completes the Installation and configuration of Remote source connection to remote MSSQL server from HANA.
References & Known Issues:
2141242 – Error “Can’t open lib ‘/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0’ : file not found” when using Smart Data Access
1968653 – Smart Data Access – generic odbc – file not found
2151882 – ODBC Error Using HANA Smart Data Access to MSSQL
Download Microsoft® ODBC Driver 11 for SQL Server® – SUSE Linux Community Technology Preview from Official Microsoft Dow…
Regards,
Pavan Gunda
- Configuring Remote Source connection (SDA) from HANA to MSSQL
- How To Set HANA ODBC Connection Properties
- Connect to a Windows Desktop from Ubuntu via Remote Desktop Connection
- Connect to a Windows Desktop from Ubuntu via Remote Desktop Connection
- How to delete PACKAGE from HANA studio
- Error in remote connection to destination SAPOSS
- Configuring Visual Studio to Debug .NET Framework Source Code
- Configuring Visual Studio to Debug .NET Framework Source Code
- Configuring Visual Studio to Debug .NET Framework Source Code
- How to Cheat at Configuring Open Source Security Tools
- Configuring Visual Studio to Debug .NET Framework Source Code
- [转载]Configuring Visual Studio to Debug .NET Framework Source Code
- Configuring Visual Studio to Debug .NET Framework Source Code
- Connection closed by foreign host. Disconnected from remote host
- Remote Desktop from Windows to Linux
- put file from local to remote server
- [eclipse]Failed to connect to remote VM. Connection refused
- How to use remote connection in Suse Linux?
- css中的一些排版布局要注意的东西
- 指针函数与函数指针
- Android OpenGL离屏渲染
- 晚还款没事,各行信用卡容时容差服务大汇总!
- IntelliJ IDEA Mac下快捷键
- Configuring Remote Source connection (SDA) from HANA to MSSQL
- Android App优化之提升你的App启动速度之实例挑战
- MacOS运行多个实例
- CPU状态信息us,sy,ni,id,wa,hi,si,st含义
- 链接、装载与库——进程的堆
- 现场没去成、直播不方便看?没事_我们为你荟萃了成都云栖大会的干货
- 【Webservice】——WSDL和SOAP
- 【Kubernetes】最佳实践1:kube-proxy与服务发现
- mysql prepare 预处理语句