Wednesday, December 21, 2011

A Journey using SharePoint 2010 and SAP BusinessObjects 4.x

Recently we've spun up a project to explore migrating all our public and private reports to a new SAP BusinessObjects Business Intelligence (BI) 4.x environment. The portal site to deliver the reports will be SharePoint 2010. The reports will be used by the general public and privately by users through a SharePoint-based extranet.

We plan on using the full gamut of BO BI reporting capabilities including WebI, Crystal, Dashboard (Xcelsius), QaaWS, all underpinned by Universes. Our existing Oracle RAC data warehouse will be the source for all reports, with operational databases feeding the data warehouse in near real time using a combination of PL/SQL ETL and SAP BusinessObjects Data Services 4.x ETL.

Over the next few months I hope to blog on some of the benefits and challenges of this project. In particular, gluing these technologies together. If you have a similar project or have some experience using this same technology stack, I would love to hear from you.