SAP HANA – we did it in 4 days, and lived to tell the tale


SAP Teched is fast approaching, and I have an ASUG session on HANA where I am presenting.  Due to a variety of reasons – I could not get my presentation and demo completed earlier. And then the idea dawned on me – why not crowd source this within the larger organization ? Having worked on a number of global projects in IBM – there was not a doubt in my mind that I could  find a team of super smart people from across the globe who will work with me to accomplish the goal.  We also enlisted the help of SAP, which they gladly provided.

Goal was simple – Stand up a whole infrastructure from scratch – hardware and software, and do a meaningful scenario of loading data using data services, putting it in HANA, and getting it to show up in multiple BI 4.0 reporting tools. We explicitly did not want to take any short cuts – no programming workarounds – enhancements or mods, no use of existing stable systems in the landscape, etc. And if we could not complete it in less than a week – we decided to stop. And for the information of my friends in enterprise collaboration – we made utmost use of lotus suite. Lotus connections, sametime, lotus notes and good ol’ telephone.

We did not want any “managers” in the team – we only wanted hands-on techies, irrespective of the official titles.  As it turned out – we had a core team comprised of folks from India, Europe and USA.  Plus we had an extended team in IBM and SAP who we could call on if we needed help. Some of the core team guys were on vacation, some had to do fasting through the day and only eat at night – and those who were working, all had one or more active projects that needed their attention.  Essentially – this had to be done on the side. This team had skills in basis, Linux, BI, ETL, SQL and some java.  I think on an average – we all had more than 10 years experience in SAP and/or BO  technologies.

The first big challenge was getting the Linux OS loaded on the box. It took almost a day to figure it out, but then finished quickly.  We could not have done this without the active help of  the IBM HANA/BWA  expert  Henning Sackewitz – thanks guys. HANA installation was next – and it was relatively smooth. We did the Rev 13 of HANA, and we could finish this in a few hours.  Although my basis colleagues are routinely used to seeing .SAR files and SAPCAR utility – I was a bit annoyed using them. Eventually I got the right version installed on my laptop – and studio/client got installed very quickly. However, not every one had the same luck. Few others had to fight the studio install before they were up and running.  Bottom line – my question for SAP – Why do I need to do command line options to install a windows application in 2011?  Is it that hard to package a visual installer that I can unzip and install?

Onwards to data services. Seriously a huge pain in the neck to get this one up and running. The post installation steps needed to get it working are not explained in a straight forward manner. We spent a lot of time hunting for the right .jar files and .dll files for the front end. Even as I type this, designer does not work on my PC. Thankfully – it did work for few others, so we could move ahead.

Data services integration to HANA was also quite painful. If the source is ECC- it is quite smooth. But once we  used some flat file sources – it gave us a tonne of false starts. Just setting up the connections with HANA took us a while. So my next question to SAP – why can’t I connect two of your systems in a more straightforward way?  For example : why would I need to read through your documentation to understand that the only port that works  is 30015? if you have a consistent logic to derive this anyway according to the documentation, why can’t the software figure this out without me wasting time?  SAP should consider spending some serious design thinking time on making sure the integration between data services, hana and BI 4.0 is seamless as advertised.

BI 4.0 was a known beast since we had experience playing with it before – and hence the additional grief was kind of minimal.  The connections to HANA are not exactly straightforward – but not too difficult either. We could expose universes and Explorer to HANA relatively quickly.

HANA studio is eclipse based, and hence had a familiar feel to it. However, when SAP talks about design thinking – this would not be what they are referring to as a top example. Context menu is not always very useful – and getting help on some features are just not possible. Quick launch is a nice touch – except there are some links which do not give useful responses. For example : Configure import server – you put in the data, hit an ok and then you wait. Guess what – data is saved, and you can see it if you go in a second time. But system won’t tell u what happened after you hit the OK button.  Another example: If you right click a table – would you not expect to see an option to see the data flow on how it is getting populated? or even an option to create data provisioning for it? well – no dice.  If you find me at Teched, I can give a few more of these misses.

And what is with the error messages? If you try to display data – and if you don’t have the right previleges, all you get is a java exception that shows up in top right of the screen. It is useless – and we have to trace to find the issue.  Took us a bit to figure out all the right access requirements. I did not get a good feeling that I can implement HANA security for a productive instance. Need to work on this some more .

Other than to test some inserts – we did not use SQL script at all. We stuck to the visual tools, and all its limitations. Calc views would work a lot better with SQL, but our intent was to do it in the most straightforward manner possible. Visual modelling is ok – but has room for plenty of improvement on consistency.  For example – I could get automatic mapping for unions, but not for joins.

In any case – by yesterday evening, we over came all the hurdles – and could get data to flow from source to hana, and get it to show up in BI 4.0 reports.  That is quite an achievement – and I am incredibly proud to be part of the team.

Special thanks to my fellow gang members – Gagan, Tomas, Manish, Ayub, Sudhir ,Suresh and Abhishek.  You guys rocked it. It is amazing that a small group of passionate techies could accomplish so much, with limited time and resources.  We speak different languages, work in different time zones, belong to different organizations and hold various formal titles – but we made it work.
Without Tag Robertson doing the needful in getting us the shiny new hana box, none of this would have worked in the first place – thanks Tag !.  And many thanks to Bill, Elaine, Birdie and entire hosting team for the fast turnaround in getting the box wired and ready for us.  The ever helpful Xavier was always came through for us and we owe him one.  And I specifically want to thank our BI Partner Craig Rich and IBM’s SAP CTO Chuck Kichler for their unwavering support.

And from SAP – Patrice, Balaji, Mani and other colleagues – many thanks for the continued support.   There are many more from SAP and IBM who have contributed to our success – you know who you are, and I am very grateful to all of you.

Although I criticized it a fair bit – I also admire how well HANA has turned out to be by Rev 13.  SAP’s HANA team should be genuinely proud in getting a 1.0 product this far ahead. There is some work to be done – but that does not take away any of the credit that is due to the team that develops hana at SAP.

Now – lets try to put HANA into the cloud over the next weekend 🙂

SAP HANA, Mobility and On Demand – where is the money ?


SAP had a great quarter – and deserves kudos for that.  Not a surprise either that maintenance revenue is the big contributor. Despite what analysts say about disruption and other such stuff – when you have a stable and committed install base, they are not going anywhere in a hurry. So SAP can take reasonable time to get new revenue streams. However it is not a permanent hall pass, and investors will become annoyed quickly if EPS drops.

 

So they have these three opportunities to make new money – HANA, Mobility and On-demand.

 

HANA is the biggest name from a pure marketing POV – SAP is shouting from the roof tops that HANA is awesome.  But what is the reality? Dennis Howlett’s post http://www.zdnet.com/blog/howlett/jim-snabe-co-ceo-sap-explains-current-business-drivers/3313?tag=mantle_skin;content says Snabe could not name a live customer for HANA.  We know there are several POC customers from the SAPPHIRE videos. We also heard the 10 Million a week pipeline .  We also heard it is fast and easy to stand up a high value HANA scenario. So why is not Snabe listing out several customer names using HANA and deriving value in production ?  Assuming 20% of the pipeline will close sales – it should bring in 72M in 2011.  May be for a 1.0 product that is pretty good.

 

So then what happens when HANA moves under BW as its database? There are about 15000 installations or so of BW as I heard somewhere. How many of these will move from ORCL, DB2 etc to HANA?  I am not convinced there will be a mass exodus from existing DB to HANA DB. For one – SAP needs to prove HANA can be fail safe in HA environments. And of course legacy DB vendors are not dumb – they will use licensing terms, instability of a new product and other FUD to delay a transition.  It is an even bigger problem when HANA goes under business suites. So how much money will SAP make out of HANA eventually?Remains to be seen.

 

Moving on to On Demand – they have two things at play. ByD  and LOB on demand. In my opinion, it is hard for SAP to make it big on ByD any time soon.  They started late, had delays, and still are aiming for low numbers. There is also the worry of cannibalizing ERP on premises.  Maybe some day this will change – but not soon enough.

 

However, LOB on demand solutions I think is a money shot.  Compared to HANA – the upfront development cost is low. A small team of product managers need to figure out a good solution. Technology is already there from ByD, and since both report into same SAP executive in Peter L, I am pretty sure ByD can be extended as needed for a good reason, if an on-demand application needs it. Development skills are existing – not new, like HANA.  And even if SAP takes time to sell this – one big customer is all they would need to break even. And since it is on internet, it can reach more people quickly. And they can/should be used on mobile. And once you institutionalize the development process – each successive application can be made faster and cheaper.

 

However, on flip side there are two big issues. One – it is never easy for a small developer to be an SAP partner to build applications on top.  And two – SAP needs scalable data centers to host this. Neither is particularly easy to pull off soon.

 

And then there is mobility – which should be the easiest place for SAP to make money., given the growing market. Every client I know of has a mobility initiative. And very few know what SAP has to offer. Which is a pity to say the least.

 

Bottom line – SAP seems to portray the next big things as HANA, On Demand and Mobility. And I think it should be exactly the other way around. What say you?

Google plus – tribes won’t follow till chiefs jump in with both feet


Couple of weeks ago – I posted my opinion on G+ in this blog. I have been lurking there since then for a bit to see if anything has changed, or whether anything has improved. And guess what – nothing has changed for me.

 

The people I follow on twitter, and via RSS feeds – they are all on G+. Not surprisingly, they are all conversing there primarily on the same discussions they are having on twitter and on their various blogs. And a lot of it is happy talk about G+ 🙂 . I also know first hand that several of these folks also have extensive back channel conversations between themselves on email threads due to privacy concerns etc.

 

As long as these folks continue to share content via twitter and other media that I am already present in, I find no reason to have yet another channel to hear the same stuff. In fact it is extremely boring and frustrating to see the same content coming at you from multiple places. In case some one says something interesting on G+, I have invariably seen some one else post it on twitter almost real time. Works for me.

 

Till such time as G+ becomes the primary channel for creating and sharing content – most of the “ordinary”, “non-geek”,”non-socmed expert” people (tribes) will stay with the incumbent platforms like facebook and twitter. I don’t think Google invited people with socmed clout (chiefs) just because platform was not ready, or because these early adopters are known for jumping into anything that is new and stay for some time at least – I think they primarily did it hoping that tribes  will follow their chiefs wherever they go. What they probably did not realize was that the chiefs will play it safe and keep a foot on old and new worlds. As long as chiefs don’t jump in with both feet, I don’t see the tribes having any reason to glance at the new shiny world.

 

Last week I read – on twitter – that G+ now has 20 million users. Very cool – impressive start. But that is a very low number if you consider the over all population of potential users (about 190M for twitter, and 750M for facebook I gather).  I have seen the “ROI is the wrong metric for social media” message touted by social media experts. I don’t buy that for a minute. And now I see a very similar argument being put forward on G+ – along the lines of “I don’ t care how it is today, I am in for the pleasure of the ride, lets see where it takes me” .  Not me – I don’t have the time or inclination to jump in for an unknown thrill ride.

 

I stayed out of google wave, SAP streamwork and twitter when they started – and once twitter proved useful, I jumped in wholeheartedly. Wave died (not unexpected), and streamwork has been steadily improving, and I have started to dip my toes a bit.  Facebook was a winner for me from day 1 – it was one place where everything I wanted to know about the latest on my hobby was posted.  I will do exactly the same for Google plus – If  (not yet sure if I can say “when”) I see the chiefs commit fully, and not treat G+ as yet another channel, I will jump in and stay.  The rationale is simple – I am less of a content provider, and more of a content consumer.  If  I become primarily a content provider, my whole perspective on this topic might have been very different.