SAP Connection

This page shows how to connect to SAP.
An SAP connection is required to use any Xtract Universal extraction type.

Warning

Missing Authorization.
To establish a connection to SAP, the access to general authority objects must be available. Adjust the SAP Authority Objects accordingly.

Supported Connection Methods

Connection to a single application server
Connection to a message server (Load Balancing)
Connect to a single application server or public or private cloud instance via RFC over WebSocket.

Supported Authentication Methods

Plain login using SAP username and password (system or dialogue user)
Secure Network Communication (SNC) using username and password via basic authentication
SSO with Logon-Ticket using username and password via basic authentication

Connect to SAP

Follow the steps below to create a source that connects to SAP:

In the main window of the Designer, navigate to the menu bar and select Server > Manage Sources. The window "Manage Sources" opens.
Click [Add] to add a new SAP connection or click [ ] to edit an existing connection. The window "Change Source" opens.
Enter a name for the SAP connection in the field Name.
In the General tab, select a connection method and enter the system details of your SAP system.

Tip

Input values for the SAP connection can be found in the Properties of the SAP Logon Pad or they can be requested from the SAP Basis team.
In the Authentication tab, select one of the following authentication methods:
- Plain uses the SAP username and password.
- Secure Network communication (SNC) uses an encrypted connection between Xtract Universal and SAP with an SAP username and password.
- SAP Logon Ticket uses SAP Logon-Tickets in place of user credentials. This connection is not encrypted.
In the RFC Options tab, select an RFC library for the SAP connection. The default is the NetWeaver RFC library.
Optional: In the Access Control tab, you can restrict read and write access to the SAP source, see Access Management.
Click [Test designer connection] to validate the connection between the Xtract Universal Designer and the SAP system.
Click [Test server connection] to validate the connection between the Xtract Universal Server and the SAP system.
Click [OK] to save the SAP source.

For more information on the input options, see Connection Settings.

Assign an SAP Source to Extractions

An SAP source is assigned when creating an extraction.
Follow the steps below to change the SAP source of an existing extraction:

Select an extraction from the list of extractions in the main window of the Designer.
Click [ Source]. The window “Change Source” opens.
Select an SAP source from the dropdown list.
Click [OK] to confirm your input.

Single-Sign-On (SSO)

BI client tools such as Power BI, Power Pivot, Alteryx, etc. can start extractions in Xtract Universal. Xtract Universal loads the extracted data directly into the tools. In this use case, it is often required that the extraction is executed with the SAP credentials of the (Windows AD) user, whose BI client triggered the extraction. This means that the SAP authorizations of the user apply. This is especially important when extracting BW/BEx queries.

The Windows credentials of the user are forwarded to SAP using Xtract Universal. On the way to SAP or on the SAP side, the Windows user and its SAP credentials are mapped.

Supported SSO Scenarios

Xtract Universal supports the following procedures for Single Sign-On (SSO):

The authentication method can be selected in the SAP source connection settings.

Connect via Router

If you access the SAP source system (Application server or Message server) via an SAP router, set the router string before the host name. For more information on SAP routers, see SAP Help: SAP-Router.

Example:
If the application server is "hamlet" and the router string is /H/lear.theobald-software.com/H/, set the host property to /H/lear.theobald-software.com/H/hamlet.

Connection Settings

Last update: June 12, 2024