Two Weeks ago I was working on a dashboard to be developed out of FLEX for SAP BI. I had tons of help from SDN as well as Durairaj Athavan raja who helped me all through it.
Ultimately I achieved the goal I started out with – I managed to integrate SAP BI data with Google Maps ( a sortof first cut to get the client interested ) , instead of a jawdropping response I expected .. the first question was …
what will this cost ?
Answer : not much apart from the IDE , the rest is free
Are you sure ?
and later on no response … this made me think as to whether we are actually ready for open source in the realm of SAP BI…?
We keep hearing the word… Open Source Business Intelligence…. but are we there yet?
Lets weigh the points against and for such tools.
For – Points in favor of Open Source BI Tools
1: Of course the biggest point is cost of licenses ( I have said cost of licenses specifically for a purpose ). You have to pay for the hardware alone…. not exactly the case for some but then you can have a support fee included for enterprise installations.
2: Open development interfaces / APIs – almost all the BI tools come with a JAVA development interface that supports reporting and other features. This makes it relatively easier for you to build applications on top of the same
3: Easy integration with other tools
Most of them if not all of them support web services and enable connectivity both ways using web services.
1. Lack of a skillbase for the same – more of a chicken and egg story – more implementations would swell the resource base and vice versa. But then it is an issue – similar to SAP Installations on LINUX – you can find more people who have implemented SAP on an AIX / Solaris platform than Linux and hence for you to choose between the same would include a caveat of finding appropriate resources for the same!! ( Maybe with Novell coming up with SUSE 10 this might change !!)
2. No 911 available – like for SAP , I have OSS – with a GPL License – who do I call ? because the original product might have been modified for my usage or I might not be running the latest version…
But then ultimately are we supposed to embrace open source or not …?
Now coming to a more generic usage possibility….
You can however look at Open source for smaller implementations – that way you can look at the cost benefit since the implementation is anyway not going to be mission critical as compared to your Data Warehouse implementation – but then to keep costs down implementations of Adobe FLEX ( I never seem to remember any other!! ) or small MIS based on Pentaho etc might mean that you create miniature data islands within the enterprise but then the costs are down and you can also foster better development and set the stage for innovation using such tools which rank high on flexibility but lack the visibility as an enterprise offering.
Why am I saying this ? is it heresy ?
Not exactly – in many cases Business Intelligence implementations are stuck in a state of no growth or degrowth because of predominantly maintenance costs and also lack of flexibility in the case of reporting. This is where open source can come in and use the backend of SAP BI and built RIAs on SAP BI or have a data feed from SAP BI going into a pentaho instance and host some reports out of there instead and the reports can be sent for free ( or at a very competitive price )
This way BI Adoption will increase in the organization – this should ideally lead to better operational information and thereby better ROI and hence more people using BI in one way or the other….
Basically it does not mean that there should be a monopoly on tools being used in an enterprise but more driven towards using what’s available in the market and drive innovation within , where different teams try to outdo each other in terms of features possible leading to better bang for buck!!!
There are a lot of open source tools / Databases available which you can examine.
Pentaho , MySQL etc etc… as a BI option … as for front end there are too many options than that would fit the blog !!