Integration Services developer Matt Masson has already blogged about the new connectivity components for SAP BW for SQL Server 2008 Integration Services. This set of components will consist of a connection manager, source, and destination. They will be released shortly after SQL Server 2008 as a download on the Feature Pack Web page, for users of Enterprise/Developer/Evaluation editions. (There has not yet been a preview release, so you won't find these anywhere on the Microsoft Web site at this point.)
Here are answers to some potential FAQ about these upcoming components:
- There are (or will be) 2 SAP adapters from Microsoft:
- one for SAP R/3 which is shipped in the BizTalk Adapter Pack.
- one for SAP BW which will be shipped on the Feature Pack Web page for SQL Server 2008 Integration Services.
- The SAP BI components work only with Integration Services.
- The SAP BI components work only with SQL Server 2008 Integration Services. They do not work with SQL Server 2005 Integration Services. However they can be used with SQL Server 2000, 2005, and 2008 as a source or destination.
- The SAP BI components support SAP BW 7.0 only. It does not support SAP BW 3.5.
- The SAP BI components use OHS (Open Hub Services).
- The SAP BI components will be certified by SAP.
For now, however - that is, in the SQL Server 2005 world - Microsoft posted new information on Tuesday on the SAP page on microsoft.com (which I didn't know about), including several PowerPoint 2003 slide decks of interest to Integration Services users. These decks consist mostly of very detailed sets of screenshots, and describe how to work with SAP R/3 today in Integration Services by using features in the BizTalk Adapter Pack. (Since the links below point directly to the .PPT files, you'll see an "open or save?" prompt.)
Please see the page linked above for additional documents.