SAP HANA is a game-changing, real-time platform for analytics and applications that can provide significant processing speed while handling real big data… this demo video shows what SAP HANA can do… they used a Kinect device to do hands free data manipulation in a “Minority Report” style and they can actually query and sort 13million out of 3.2billion records in less then one second!! Wow!
With more and more ultra-books around, In-Memory Computing is definitely the future of huge and “not so huge” databases! What comes next?! SAP and Oracle are already fighting for this new world of Database possibilities and we can see sparks going on…
What about a trial?! When ordinary people, non-SAP clients (like me and probably you too) will be able to use SAP Hana?!
I had to wait until last week when I finally received my approval and access information from SAP In-Memory Developer Center. Now I got a 30 days of trial access to a hosted HANA test and evaluation environment hosted by CloudShare. And what happens if I really like this?! I can get my own SAP HANA DB server on Amazon Web Services.
I followed the first steps of the SAP HANA Database – Development Guide to configure my server, download and import some sample data.
As a Delphi lover and a Embarcadero Evangelist I wanted to demonstrate a DelphiXE2 application fetching data from the SAP HANA server. So I configured an ODBC using the HDBODBC driver, got the connection string into an TADOConnection component and what a great surprise I was able to connect to the server!
Now lets try to run a Query with a simple select statement… Added a TADOQuery component to the form and correctly linked a TDatasource and TDBGrid components… compiled my DelphiXE2 application and downloaded it to my virtual-machine hosted on CloudShare…
At this point i get an error message that says “Error occurred while executing a MDX statement. The message is: Syntax Erro: Select * from “SFLIGHT”<<<<”
What I don’t understand is why!?! the SQL statement was copied from SAP Hana Studio and runs OK there!
Well its more about midnight now and I need some sleep… so by now I’ll leave you guys with this problem in mind and some pictures showing some basic steps and results… I think we are really close to figure it out and be able to publish some first performance results regarding DelphiXE2 and SAP Hana integration… so send me an email or tweet if you want me to send you the complete DelphiXE2 source code for the demo project, help is always welcome!