Microsoft .NET Data Provider for mySAP Business Suite

SQL Server 2005 includes support for accessing SAP data by using the Microsoft .NET Data Provider for mySAP Business Suite. This provider lets you create an Integration Services package that can connect to a mySAP Business Suite solution and then execute commands to access data via supported interfaces. You can also create Reporting Services reports against a server running the mySAP Business Suite.

You will be able to use the Microsoft .NET Data Provider for mySAP Business Suite in the SQL Server Import and Export Wizard and in various Integration Services features (including the Script task, the DataReader Source component, and the Script component), as well as the data processing extensions in Reporting Services.

The Microsoft .NET Data Provider for mySAP Business Suite is not included in SQL Server 2005. The preview version is licensed as pre-release software as outlined in the License Terms. See the Readme included with the download for information on the prerequisites for using the Microsoft .NET Data Provider for mySAP Business Suite.

Microsoft SQL Server 2005 supports two special remote function calls (RFCs) for use with the SAP R/3 system: - Data Extraction RFC (Z_EXTRACT_DATA_FULL): This RFC extracts data from virtually any table or view in the SAP R/3 system, converts the data, and returns the data synchronously in a SQL Server table, or dumps data to a flat file. This RFC supports SELECT statements and WHERE clauses. The performance of this RFC is dependent on your SAP system hardware. - Function Module Metadata Extraction RFC (Z_READ_FUNCTION_METADATA). This RFC extracts basic function metadata and parameter metadata for any function module in SAP R/3.