We've recently been so busy in the office with all things BI on HANA that it's been a while since I had an opportunity to blog. Wow, how the world is changing, and how quickly too!
I was messing about last week with some custom views to support a direct Lumira connection and thought it would be interesting to see how difficult it would be to connect to SAP HANA via PHP and ODBC.
Those who have seenandrew.jabbitt01 will know that I love building visualisations using the D3.js library, and acquiring a dataset is the foundation step of all good visualisations.
It struck me that connecting directly to SAP HANA from my own web server might open up a few interesting opportunities. Also, since the advent of B4HANA and SAP's stated objective to remove all barriers to the Enterprise BI datasets held in SAP BW systems it seems we are all now becoming DBAs (its views all the way down). And what better way to prove your HANA modelling concepts than messing about with your own custom UX.
(Note: this is just a PoC and not intended to usurp the Fiori UX development approach - I just wanted to see if I could connect and what the effort would be).
Well, probably not surprisingly, it was pretty easy (once I had configured the correct ODBC drivers!)
Here is an image of a subset of one of our Product Hierarchies to illustrate what I was able to achieve: