Configuring Reporting Services to Use the Microsoft .NET Framework Data Provider 1.0 for SAP NetWeaver Business Intelligence
New: 14 April 2006
SQL Server 2005 Reporting Services (Service Pack 1 and later) includes support for the Microsoft .NET Data Provider v1.0 for SAP NetWeaver® Business Intelligence so you can retrieve and use SAP multidimensional business intelligence data in reports.
To configure the data provider for use on a report server to publish reports or to use as a data source in the design view of Report Designer, you must do the following:
- Check RSReportDesigner.config and RSReportServer.config files to verify this data provider is registered. If it is not registered, the steps below give you the information you need to register this data provider. Each of these configuration files identifies the data extensions that can be used in reports. By adding the specific registration information for a data extension, you enable its use by a report.
Modifying the RSReportDesigner.config File
Before you can build report definitions that retrieve data using the Microsoft .NET Data Provider for SAP NetWeaver Business Intelligence, you must verify that the following two changes have been made to the RSReportDesigner.config file:
Using a browser, locate <drive>:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.
Make a backup copy of RSReportDesigner.config.
Using a text editor, open the RSReportDesigner.config file.
In the <Data> section, add the following entry if it is not already there. This entry must be on one line with no line breaks.
<Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/>This registers the data processing extension on the client that connects to a SAP NetWeaver Business Intelligence system.
In the <Designer> section, add the following entry if it is not already there. This entry must be on one line with no line breaks.
<Extension Name="SAPBW" Type="Microsoft.ReportingServices.QueryDesigners.SapBw.SapBwQueryDesigner,Microsoft.ReportingServices.QueryDesigners.SapBw"/>This registers the query designer for the SAP NetWeaver Business Intelligence system.
With these entries in the configuration file, the SAP NetWeaver Business Intelligence data provider becomes available as a data source type that you can select in the Data Source dialog box in Report Designer. To learn more about specifying the connection string and queries that retrieve multidimensional SAP business intelligence data, see Defining Report Datasets for Multidimensional Data from an SAP NetWeaver BI System.
Modifying the RSReportServer.config File
Before you can build report definitions that retrieve data using the Microsoft .NET Data Provider for SAP NetWeaver Business Intelligence, you must verify that the following change has been made to the RSReportServer.config file:
Using a browser, locate <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer.
Make a backup copy of RSReportServer.config.
Using a text editor, open the RSReportServer.config file.
In the <Data> section, add the following entry if it is not already there. This entry must be on one line with no line breaks.
<Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/>This registers the report server on the client that connects to a SAP NetWeaver Business Intelligence system.
Save the file.
Requirements
The Microsoft .NET Data Provider for SAP NetWeaver Business Intelligence supports SAP BW 3.5B, patched as follows:
- BASIS Level 11
- ABAP Level 11
- BASIS Plug-In Level 8
- BW Level 11
- BI Content Level 3
The following operating systems are supported:
- Microsoft Windows Server 2003
- Microsoft XP Professional
- Microsoft Windows 2000 Professional
See Also
Concepts
Reporting Services Configuration Files
RSReportDesigner Configuration File
RSReportServer Configuration File
Other Resources
Deploying a Data Processing Extension