Linked server creation from SAPB1 HANA Server to SQL Server
Environment :
iVend 6.6 With SAPB1 HANA Server
Problem Statement :
There is need to access SAPB1 HANA tables on iVend Enterprise database
Resolution :
You can check out the below video link to create Linked server from HANA to SQL Server
The below given are the scripts to create Linked servers
HANA Server : 20.0.23.18:30015
exec sp_addlinkedserver
@server ='20.0.23.18',--Description
@srvproduct ='HANA',--Description
@Provider='MSDASQL',--MS OLEDB Provider
@datasrc='HANAServerN'--ODBC system DSN
exec sp_addlinkedsrvlogin
@Useself='FALSE',
@rmtsrvname='20.0.23.18',--same as the above
@locallogin=Null,
@rmtuser='SYSTEM',--HANA user
@rmtpassword='manager'--hana password
After that you can check the same on iVend HO Database by accessing SAPB1 HANA Tables as below
select Cardcode from [20.0.23.18].."SBODEMOUS"."OCRD"
Note : It is only suggestion for support team however it is expected that Customer/partner should create linked server from SAPB1 HANA Server.
Related Articles
Steps to pulls SAP data /Table from SAP HANA Database to iVend SQL SERVER
*************************************************************************************************************************** This article is only for internal use. ...2 SAP HANA databases on the same SAP HANA server and connected to 2 separate iVend HO SQL
Environment : iVend 6.6 with SAPB1 HANA Problem Statement : Can 2 SAPB1 HANA databases (which are on different HANA servers) be on the same SAP HANA server and connected to 2 separate iVend HO SQL servers? Symptoms : Integration of multi company ...iVend ADDON for SAP BUSSINES ONE - HANA and SQL
Version: 6.6, not version-specific Request: Customer requires Addon for iVend 6.6 with SAP HANA Resolution: Please download the latest patch 7915 from the CitiXsys Support portal (https://citixsys.service-now.com/) which contains the updated Addon ...Limit SQL SERVER memory consumption
Version: Not the version-specific Query: Below query has been raised by one of the iVend user. I am experiencing in my HO server a lot of memory consumption when I checked it was the SQL SERVER, so I want to ask you if I can limit it, defining in SQL ...iVend - SAP Business One - SQL Server Compatibility matrix; till iVend 6.6 (upto Patch version 7574)
Version iVend 5.4 to iVend 6.6 (Patch version 7574) Query Share the iVend / SQL / SAP B1 compatibility table matrix Response Excel file named "iVend - SAP B1 - SQL Server Compatibility Matrix" is attached with this KB article. Below is the screenshot ...