Sunday, June 24, 2007

SharePoint BDC and SAP

Share Point now has a Business Data Catalog for storing useful business information and making it easily available in customizable web parts. This is not to be confused with SAP BDC sessions, which are completely different. The Share Point BDC is just begging to be populated with data from your SAP system. There are two approaches, one of which is heresy if you come from a SAP background.

1. Use web services to access SAP data retrieval functions (correct)
2. Connect directly to the underlying SAP tables (so wrong!)

Option 2 is easier, more efficient and more elegant. However, it breaches the integrity of the SAP "data vault" model by ignoring the security and business logic programmed into the SAP interfaces.

We are going down the former path, exposing SAP master data to the Share Point BDC using the appropriate web services (and writing our own if none are available).

No comments: