Hi Raph, thank you for the video ! But everything seems work for me but I can't show any table... do you know if we need particular permission on SAP HANA database ? Thank you !
Hi Ralph, I have searched extensively to get this to work and couldn't find anything. I was able to create the DSN and test it from excel. But, trying to do the same from SQL server was not straight forward. You video was of great help. You should post this to SCN which will benefit many people who are still struggling. I didn't want to use the data services. Thank you so much.
Hi Ralph, Thanks a lot for the video. I used your steps, and got this far and linked a remote HANA DB. I was also able to get the select statements to work from HANA. However when I put an INSERT or UPDATE statement to remote HANA then it says "Invalid command state (No prepared SQL command)". Have you come across this and would you have a solution to this? Thanks!
Hello sir, just a beginner question. In the real world, its safe install SAP in the same server of the Data Base? or its better in a dedicated server?.
Hello Ralph, I noticed you are using ODBC to connect to SAP HANA, would you know if this will also work on BW on HANA Platform? Are there any prerequisites that needs to be installed on the HANA server?
Hi +Michael Vincent, no prereqs on the HANA server side. Since we are dealing only with the DBs here this example does not depends of any application. I am not familiar with BW but you might check the other way around (From HANA Get info from MSSQL or other DB). There is a feature called Smart Data Access that might suit your needs: help.sap.com/saphelp_nw74/helpdata/en/bb/df686dc0d94f779b5c11d06753da95/frameset.htm
+Ralphive Hi Ralph, I have also checked that link. what I want to do is the same on what you shared here. How can I use the select statements from a specific Hana table? I've been getting a lot of errors.
Hi Ralph, thanks a lot! i successfully created the linked server to SAP HANA! is there a way to execute a SAP HANA procedure using the linked server? Thanks, Yuval
+Harald Battran Thank you! Tell me what kind of functionality do you wanna see and I might record something. The focus is 100% hana, but we could take a look at MSSQL sometimes.
Can we view the Hana tables in the linked SQL server?
Thank u so much Ralphive, we love u...God bless u...
can we use other comands like update with linked server between SAP and SQL
Hi Raph, thank you for the video !
But everything seems work for me but I can't show any table... do you know if we need particular permission on SAP HANA database ?
Thank you !
Also I have same issue
Hi Ralph, I have searched extensively to get this to work and couldn't find anything. I was able to create the DSN and test it from excel. But, trying to do the same from SQL server was not straight forward. You video was of great help. You should post this to SCN which will benefit many people who are still struggling. I didn't want to use the data services. Thank you so much.
Thanks for sharing this information. I implemented and works well but I have a question regarding S4/hana, does it works with S4/hana?
Hi Ralph,
Thanks a lot for the video. I used your steps, and got this far and linked a remote HANA DB. I was also able to get the select statements to work from HANA. However when I put an INSERT or UPDATE statement to remote HANA then it says "Invalid command state (No prepared SQL command)". Have you come across this and would you have a solution to this?
Thanks!
Hello sir, just a beginner question.
In the real world, its safe install SAP in the same server of the Data Base? or its better in a dedicated server?.
Hello... i successfully created the linked server to SAP HANA but the query is very slowly.
Any idea of happended?
Hi Guillermo,
I have the same problem, very slow query.
Do you have a solution ?
Hi!!!
No, lingering slowness
Hello Ralp, how can we download the binaries of SAP Client tool? Do we need a paid account or we have free download available?
where is the link to download?
Hello Ralph,
I noticed you are using ODBC to connect to SAP HANA, would you know if this will also work on BW on HANA Platform? Are there any prerequisites that needs to be installed on the HANA server?
Hi +Michael Vincent, no prereqs on the HANA server side. Since we are dealing only with the DBs here this example does not depends of any application.
I am not familiar with BW but you might check the other way around (From HANA Get info from MSSQL or other DB). There is a feature called Smart Data Access that might suit your needs: help.sap.com/saphelp_nw74/helpdata/en/bb/df686dc0d94f779b5c11d06753da95/frameset.htm
+Ralphive Hi Ralph, I have also checked that link. what I want to do is the same on what you shared here. How can I use the select statements from a specific Hana table? I've been getting a lot of errors.
Hi Ralph,
thanks a lot! i successfully created the linked server to SAP HANA!
is there a way to execute a SAP HANA procedure using the linked server?
Thanks, Yuval
Perfect Job...Thanks a lot.
Good Video , Many Thanks
hello, link lost
Great job man...
Hi Ralph,
great video and helpful for a current project! Any videos like this around MySQL and HANA?
Greetings from Singapore
Harald
+Harald Battran Thank you! Tell me what kind of functionality do you wanna see and I might record something. The focus is 100% hana, but we could take a look at MSSQL sometimes.
Hola Raph como llamas un Stored Procedure de Hana estando en SQLSERVER
Saludos!!
hola Jose, lograste resolver tu problema? tengo el mismo caso
it's the other way around, it's hana that has to get data from sql server!!!
Many thanks.
Hi Ralph,
Can we connect MYSQL to HANA using smart Data Access.. If yes can you please share info. :)