Time for some bloggin’ again! I was initially triggered to post this blog when Gartner published its Magiq Quadrant for BI 2008. I was disappointed by the position of MicroStrategy, just inside the leaders quadrant. Gartner explicitly favours vendors who adopt an integrated approach and support the entire stack of functionality. But do these platforms like SAP / Cognos or Oracle (with Hyperion) deliver upon their promise? And what should or must be the benefits of such an integrated approach?
I particularly know MicroStrategy and SAS and have seen and worked with both products. Although SAS has a broad platform with all the major BI functionalities and uses a central metadata server, I am rather disappointed by its front-end capabilities. Its core analytic functionality is strong, no doubt, but when it comes to reporting one needs to work with multiple components to get some straightforward functionality, like a look-up prompt or an outline (expand / collapse) report. Compare that to the way MicroStrategy works, a world of difference.
So what should be the advantages of an integrated platform?
- Costs: fewer platforms / vendor solutions are needed
- Integrated metadata: but what does this really mean? In SAS, for some parts it seems to imply that all the metadata objects are maintained in the same metadata server but the objects itself are less integrated. Also granularity of metadata is rather high.
- Lineage: trackin’and tracing your data from the source to target and vice versa
- Leverage: functionality may be reused for other purposes, e.g. using ETL-functionality for front-end / end-user purposes like a periodic data export or something like that.
So next question: do all these integrated platforms deliver on their promise. My impression – but I don’t know the other platforms / vendors – is that they are still a long way from true integration.
Final question: what is the optimum sourcing strategy? integrated platform or best-of-breed. I know, if market consolidation continues there isn’t much to choose, but I’m curious: what are your thoughts on this topic? Hope to hear from ya!