Use SQL2005 to Connect and Present SAP on SharePoint / Business Scorecard Manager — Part I
SQL 2005 is a Microsoft latest product. It provides a new way to access SAP data via new feature pack of.NET Provider for mySAP. The reports on SQL 2005 report server can be easily to display on another Microsoft product, SharePoint Portal Server or Windows SharePoint sites. And what’s more, after SAP data is extracted into SQL 2005 database, we can do more business intelligence work and then present drill through web tables on report server web sites / SharePoint pages, even to use analysis service result to build company KPIs and lastly use Microsoft Business Scorecard Manager 2005 to present KPIs in a visible way on SharePoint Pages.
