Configuring Reporting Services to Use the Microsoft .NET Framework Data Provider for mySAP Business Suite

New: 5 December 2005

SQL Server 2005 includes support for the Microsoft .NET Data Provider for mySAP Business Suite so that you can retrieve and use SAP data in Integration Services packages and in Reporting Services reports.

To use the data provider, you must install and configure it. The Microsoft .NET Data Provider for mySAP Business Suite is available as a separate download that you can install on an existing SQL Server 2005 instance. For more information about the data provider, including installation instructions and examples of how to use it, see Microsoft .NET Data Provider for mySAP Business Suite.

To run the data provider on a report server and to reference it in the design view of Report Designer, you must do the following:

• Add code groups to the Report Designer and report server policy configuration files to grant permission to the data provider. These code groups are not specified by default.
• Modify the RSReportDesigner.config and RSReportServer.config files. Each of these configuration files includes settings that specify the Microsoft .NET Data Provider for mySAP Business Suite. By default, the configuration settings are commented out in each file.

After you install the Microsoft .NET Data Provider for mySAP Business Suite on your computer, follow the step-by-step instructions provided in this topic to deploy the data provider in your Reporting Services installation.

Adding a Code Group to the RSPreviewPolicy.config File

To run the Microsoft .NET Data Provider for mySAP Business Suite in Full Trust, you must add a code group to the Report Designer policy file.

1. Open the in RSPreviewPolicy.config file, located by default at C:\ Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

2. Add the following code group:

   <CodeGroup
       class="UnionCodeGroup"
       version="1"
       PermissionSetName="FullTrust"
       Name="Microsoft_Generic_Signing"
       Description="This code group grants code signed with the generic Microsoft key full trust.  Used by the Microsoft .Net Data Provider for mySAP Business Suite.">
      <IMembershipCondition
        class="StrongNameMembershipCondition"
        version="1"
        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100b5fc90e7027f67871e773a8fde8938c81dd402ba65b9201d60593e96c492651e889cc13f1415ebb53fac1131ae0bd333c5ee6021672d9718ea31a8aebd0da0072f25d87dba6fc90ffd598ed4da35e44c398c454307e8e33b8426143daec9f596836f97c8f74750e5975c64e2189f45def46b2a2b1247adc3652bf5c308055da9"
                   />
   </CodeGroup>
   

3. Save the file.

Modifying the RSReportDesigner.config File

Before you can build report definitions that retrieve data using the Microsoft .NET Data Provider for mySAP Business Suite, you must remove comments from two sections in the RSReportDesigner.config file.

1. Using Windows Explorer, locate <drive>:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

2. Using a text editor, open the RSReportDesigner.config file.

3. Remove the comment marks (delete <!-- and --> characters from the beginning and end of the line) for this entry in the <Data> section:

   <!-- Extension Name="SAP" Type="Microsoft.Adapter.SAP.SAPConnection,Microsoft.Adapter.SAP.SAPProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/ -->
   

4. In the <Designer> section, remove the comments from this entry:

   <!-- Extension Name="SAP" Type="Microsoft.ReportingServices.QueryDesigners.GenericQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/ -->
   

5. Save the file.

After you modify the configuration file, the 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 how to specify the connection string and queries that retrieve SAP data, see Microsoft .NET Data Provider for mySAP Business Suite.

Adding a Code Group to the RSSrvPolicy.config File

To run the Microsoft .NET Data Provider for mySAP Business Suite in Full Trust, you must add a code group to the report server policy file.

1. Open the in RSSrvPolicy.config file, located by default at <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer.

2. Add the following code group:

   <CodeGroup
       class="UnionCodeGroup"
       version="1"
       PermissionSetName="FullTrust"
       Name="Microsoft_Generic_Signing"
      Description="This code group grants code signed with the generic Microsoft key full trust.  Used by the Microsoft .Net Data Provider for mySAP Business Suite.">
      <IMembershipCondition
        class="StrongNameMembershipCondition"
        version="1"
        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100b5fc90e7027f67871e773a8fde8938c81dd402ba65b9201d60593e96c492651e889cc13f1415ebb53fac1131ae0bd333c5ee6021672d9718ea31a8aebd0da0072f25d87dba6fc90ffd598ed4da35e44c398c454307e8e33b8426143daec9f596836f97c8f74750e5975c64e2189f45def46b2a2b1247adc3652bf5c308055da9"
                   />
   </CodeGroup>
   

3. Save the file.

Modifying the RSReportServer.config File

Before you can process a report that retrieves data using the Microsoft .NET Data Provider for mySAP Business Suite, you must remove comments from RSReportServer.config file.

1. Open the in RSReportServer.config file, located by default at <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer.

2. In the <Data> section, remove the comments from this entry:

   <Extension Name="SAP" Type="Microsoft.Adapter.SAP.SAPConnection,Microsoft.Adapter.SAP.SAPProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
   

3. Save the file.

See Also

Concepts

Reporting Services Configuration Files
RSReportDesigner Configuration File
RSReportServer Configuration File

Other Resources

Deploying a Data Processing Extension

Help and Information

Getting SQL Server 2005 Assistance