Skip to Content
Author's profile photo Ronald Konijnenburg

Siri meets HANA

So a cold day in December you are surfing the net and you get triggered by the famous SAP HANA Kinect demo: “wouldn’t it be great to use voice instead of gestures and use Siri on the iPhone to ask Business Intelligence like questions?” Imagine a scenario where a user would ask a simple question like  “Give me total sales for Customer BMW” and Siri would give the answer.  Imagine that…

So what happened next? I decided not to snuggle up to the cat, poor myself a glass of egg nog or finish my Christmas shopping. I decided to make it happen and so a journey full of challenges started.

Siri Proxy
I came across this fantastic piece of software called Siri Proxy. According to the authors:

Siri Proxy is a proxy server for Apple’s Siri “assistant.” The idea is to allow for the creation of custom handlers for different actions. This can allow developers to easily add functionality to Siri.

I installed Siri Proxy on a virtual Ubuntu machine and within a couple of hours I had Siri Proxy running and it was taking commands other than the ones Apple put in. I installed some community written Plugins and got really enthusiastic about the technique. I picked up a Ruby book, deep dived into the basics and started writing my own Plugin.

 

SQL Plugin
I decided my Plugin should be able to execute SQL statements and query any database. This would make it possible to connect to virtually any database and one would be able to use it in a broad and agnostic way.

 

The first test
As a Proof of concept I installed a random database (MySQL) on an Ubuntu environment. I created a simple table containing the key figure “Sales” and objects “Sales rep, Customer and Date” and loaded some random data to my table. Within two week (and some sleepless nights) the Plugin worked beautifully. It took my commands and fired off the SQL with lighting speed.

 

What if we can do this on HANA?

“Can I do this on HANA?”. Like my father always told me: “impossible is not a fact, it’s an opinion”. So I took up the challenge again. I contacted my colleague Rob Beeren and we drew up the architecture. Execution and the headaches started.

 

So what challenges can one find connecting Siri to HANA?

If you look at a solution after you build it, it always looks easy. But honestly: connecting an iPhone on 3G to a Cloud server with closed ports is not easy. Thank goodness the guys over at SAP Labs persuaded Cloudshare to open some ports. After this, we managed to VPN into the Cloud and thus have an integrated scenario. Next HANA ODBC drivers on Linux were added, the required  ruby Gems for ODBC were implemented and finally we pressed the Home button on the iPhone. What happened next, you can find below:

 

Siri meets HANA

 

See you at the Innojam! And ofcourse I will release full code and instructions after the event!

 

Stay in touch,

 

Ronald. 

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Excellent guys...Keep up the good work ..Waiting for more details for the fun read..way to go ..cheers again..
      Author's profile photo Rama Shankar
      Rama Shankar
      Great Effort & Work - Creative Innovation: Thanks for the write-up!
      Author's profile photo Alvaro Tejada Galindo
      Alvaro Tejada Galindo
      Ronald! Awesome work man! Keep on! -:D

      Greetings,
      Blag.

      Author's profile photo Ronald Konijnenburg
      Ronald Konijnenburg
      Blog Post Author
      Tx Blag! Much appreciated.
      Author's profile photo Former Member
      Former Member
      Very Innovative...Good job.
      Author's profile photo Naimesh Patel
      Naimesh Patel
      Hello Ronald,

      This is amazing breakthrough on integration.

      I have some questions on running command over HANA - Can we create a WS to access the data and pass it back to the WS Consumer?

      Regards,
      Naimesh Patel

      Author's profile photo Ronald Konijnenburg
      Ronald Konijnenburg
      Blog Post Author
      Hi Naimesh,

      Tx! Not sure what you mean. Can you elaborate a bit more?

      Author's profile photo Balasubrahmanyam Juttiga
      Balasubrahmanyam Juttiga
      Thats a fantastic idea Ronald ....
      Author's profile photo jyotheswar p
      jyotheswar p
      Loved the idea.Keep going.
      Author's profile photo Former Member
      Former Member
      Do I throw in the towel now or later?  I haven't even been working out my solution.

      This is amazing.  Great work!

      Michelle

      Author's profile photo Former Member
      Former Member
      Fantastic work you guys.  Its wonderful and impressive to see people take an idea and bring it to life.

      Its a significantly distruptive UI concept.  With further enhancements and development, this will prove to be a preferred interface for many users of real-time analytics.

      Author's profile photo Former Member
      Former Member

      Hi Ronald,

      Did the code ever get published anywhere?

      I'm really keen to get hold of the SQL Plugin and test on my SiriProxy which I've installed on a Raspberry Pi.

      Thanks,

      Matt