Linking HANA to SQL Server

[Former Member]

I am looking to create a view within HANA to pull information from SQL... Anyone have any ideas if these is even possible? So far I've come across a way t link SQL to HANA but not the other way round.

As I am dealing with SAP Business One, HANA is incredibly new to me so any help/pointers would be greatly appreciated

Thanks

Jason

[Former Member · Accepted solution]

Hi Jason,

am I right that you want to create a HANA view which then contains data directly out of MS SQL Server?

This is not possible, as far as I know.

But what you could do is: Replicate the data from MS SQL Server into HANA (using Sybase Replication Server, SAP LT or similar possibilities) and then create the HANA view on top of the replicated data within HANA.

If you only talk about merging data within Business Objects from two sources (SAP HANA & MS SQL Server) => then I can't give you any advice.

Best regards,

Tobias

[Former Member · Accepted solution]

Hi Tobias

That is the answer I feared

I have a call later today with a HANA product specialist over at SAP, so I'll update the message once I hear what they have to say.

Thanks for your input

Regards

Jason

[Former Member · Accepted solution]

Hi Tobias

Turns out the functionality is in SPS7, however will not be covered on HANA for SAP Business one.

http://www.youtube.com/watch?feature=player_embedded&v=OS_48KOHnKE

Regards

Jason

[Former Member · Accepted solution]

Hi Jason,

you are right:

and http://www.saphana.com/docs/DOC-4347http://www.saphana.com/docs/DOC-4319

Since SPS 7 it's possible to access MS SQL databases through Smart Data Access and it works fine so far (I do not know which source data types are supported yet and which are not)

The only drawback I see is that the data doesn't gets materialized within HANA as far as I see and therefore you can't benefit from the "in-memory speed advantage" in such a scenario.

Best regards,

Tobias

[henrique_pinto · Accepted solution]

On the contrary.

Indeed the data is not materialized on HANA, but in runtime, it's all there, in HANA's memory.

Meaning that you could do complex calculations and manipulations of the data from the remote source, and the speed to realize these calculations in-memory, depending on how complex they are, might be even more advantageous than simply having a faster I/O.

[Former Member · Accepted solution]

Hi Tobias: I could really use your help connecting HANA to SQL Server for a personal project for which I have very little money. Basically I want to run HANA on Amazon AWS for couple of hours only to save money. So here is what I hope to achieve. I have live data streaming into an SQL server at all times. I want to run HANA on Amazon AWS for couple of hours a day. During which I want to pull Deltas (after doing the initial first load) on demand (not scheduled) from SQL server and then run my analytic reports and then close the AWS session. How can I create a direct delta setup between my local MS SQL server to pass data into HANA on AWS?

I was able to achieve this but in a very difficult way. I downloaded the 60gb HANA on Suse Linux installation from SAP and installed it on an old Dell R910 server. Then I installed trial version of BOBJ which allowed me to run CMS server and BODS 4.0. Thru this I was able to create a connection between my sql server and HANA and setup initial load and deltas on demand. Since the trial versions were only good for month i had to shut it down but it worked and I was able to do my analysis on HANA and it was fantastic. But I cannot afford to buy BOBJ licenses etc so I'm really hoping there's an easier and affordable solution out there.

Can anyone help? I've posted this question on numerous places and I haven't been able to find any solution. I'm very new and self taught on HANA and haven't touched it now for 6 months.

Bobby