The following section guides you through the creation of an SAP data source in the SQL Server Report Server (SSRS) environment. The screenshots may slightly differ depending on whether you use the wizard or manual creation. After installation the Xtract RS data source type can be used in the Reporting Services wizard. Create a new connection to SAP as described in the following.

  1. Run the XtractRSSetup.exe application on the same environment, where Visual Studio is installed.
  2. Make sure that the Microsoft Reporting Services Projects extension is installed and activated in VS2019.
  3. Create a new Report Server Project in VS2019.
  4. Right-click on the Shared Data Sources folder and select Add New Data Source.
  5. In tab General, assign a name for the new data source (optional), the default value is DataSource1 (1).
  6. Select the type Xtract RS (2). Report-Data-Source-001
  7. Fill in the connection string to the SAP source (3).
  8. Switch to the Credentials tab and enter your SAP username and password (4). Report-Data-Source-002
  9. Click [OK] to confirm.

Connection String Parameter #

Note: For more information, see the official SAP documentation.

Server Parameter Example value
Application ApplicationHost saperp.theobald.local
SystemNumber 00
Language EN
Client 800
Secure Network Communication SNCMode 1 - enable
SNCPartnerName p:SAPserviceERP/do_not_care@THEOBALD.LOCAL - Partnername des konfigurierten SAP Systems
SNCLibrary C:\SNC\gsskrb5.dll - lokaler Pfad zur Kerberos lib
SSOType 2 - SSO mit Kerberos
Message MessageServer saperp.theobald.local
UseLoadBalancing true
LogonGroup PUBLIC
SID MBS

Connection String Examples: #

SNC

ApplicationHost=saperp.theobald.local;SystemNumber=00;Language=EN;Client=800;SNCMode=1; SNCPartnerName=p:SAPserviceERP/do_not_care@THEOBALD.LOCAL;SNCLibrary="C:\SNC\gsskrb5.dll";SSOType=2

Single Application Server

ApplicationHost=ec5.theobald-software.com;SystemNumber=00;Language=EN;Client=800

Downloading Kerberos DLLs #

Note: You can download the relevant DLLs from the SAP ONE Support Launchpad.

Store the Kerberos libraries in the following local path: C:\SNC\gx64krb5.dll (64-bit) and C:\SNC\gsskrb5.dll (32-bit).