The De Villiers Walton Blog

Read our latest thoughts on all things SAP.

Connecting Microsoft BI with SAP

As an SAP customer, you have decided to incorporate Microsoft Business Intelligence into your Business Intelligence (BI) landscape. Congratulations! Not only have you made an excellent decision but you have also joined a club that – judging by the number of visitors to our website – is recruiting more members by the day.

To get the most out of your investments in Microsoft BI and SAP you will need to choose a suitable method for connecting Microsoft’s Excel PowerPivot add-in with SAP.

You could of course develop your own solution (perhaps using a tool such as SAP NetWeaver Gateway) or you could invest in one of a number of commercially available solutions developed by software vendors.

Most of the commercially available solutions require a 2-stage approach to integrating PowerPivot and SAP. By, “2-stage” integration I am referring to a solution in which the data is for example initially loaded into MS Excel using Business Objects Analysis or the OLE DB for SAP BW connector (stage 1) before being uploaded into PowerPivot (stage 2).

When we designed the DVW PowerPivot Connector for SAP, we wanted to streamline this process using a 1-stage integration approach and load data directly from SAP into PowerPivot in a single configurable step. Once implemented you can automate the data load process using Microsoft SharePoint.

We also looked to create a solution that had the lightest possible footprint on your SAP system, required little or no on-going involvement from IT post-installation and would enable two key objectives of Microsoft BI i.e. self-service BI and flexible reporting.

The following PowerPivot SAP data feed connectors are available:

  • SAP Table Extract
  • BW Query and BW QueryView
  • BW InfoProvider (including InfoCube, Data Store Object (DSO), InfoSet,  Virtual Cube & Hybrid Cube)
  • Table Metadata
  • Query Metadata
  • InfoProvider Metadata

The User can parameterize extracts from all seven connectors and standard SAP authorization checks are applied when using the Premium SAP Table Extract, BW Query and BW InfoProvider connectors. This ensures that a User can only access data that they have authorization to access.

Next Steps

If the De Villiers Walton PowerPivot Connector for SAP is of interest, please complete the short form below and a member of our team will contact you.

Fill out my online form.
Rate this blog entry:
SAP Usability and the User Experience
Cost-effectively send SMS messages directly from S...

Related Posts


No comments yet