Skip to content

SAP Connection

This page shows how to connect to SAP using the Data Connection Manager (DCM) of Alteryx.
The installation of Xtract for Alteryx includes the Xtract data source technology that connects to SAP systems.

An SAP connection is required to use any Xtract for Alteryx component.

Warning

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

Note

The usage of the Alteryx Data Connection Manager is supported as of Alteryx Designer version 2022.3. To use the DCM, it needs to be enabled for your organization, see Alteryx Documentation: Data Connection Manager. If cannot use the Alteryx Data Connection Manager, refer to the knowledge base article Create an SAP Connection to create SAP connections using the Xtract for Alteryx UI.

Supported Connection Methods

  • Connection to a single application server
  • Connection to a message server (Load Balancing)

Supported Authentication Methods

Create an Xtract Data Source

Follow the steps below to create an Xtract data source that connects to SAP:

  1. In the main menu of the Alteryx Designer navigate to File > Manage Connections. The window "Connection Manager" opens.
  2. In the tab Data Sources click [New] to create a new data source.
  3. Select the Xtract technology to create an Xtract data source.
  4. Fill out the data source settings for your SAP system, see Xtract Data Source Settings.
    Data-Connection-Manager
  5. Click [Save] to save the SAP connection. The subsection Connection opens.
  6. In the subsection Connection select one of the following authentication methods:
    • Plain uses the SAP username and password.
    • SNC uses an encrypted connection between Xtract for Alteryx and SAP with an SAP username and password.
    • Ticket Issuer uses SAP Logon-Tickets in place of user credentials. This connection is not encrypted.
  7. Select an existing credential for your SAP system or click + Connect Credential to create a new credential. For more information, see Create Credentials.
  8. Click [Link] / [Create and link] to link the credential to the connection. Example:
    new-data-source

The SAP connection is now available for selection in the Xtract for Alteryx components, see Assign an SAP Connection to Xtract Components.

Create Credentials

Follow the steps below to create an Xtract data source that connects to SAP:

  1. In the main menu of the Alteryx Designer navigate to File > Manage Connections. The window "Connection Manager" opens.
  2. In the tab Credentials click [New] to create a new credential.
    Credentials
  3. Enter a name for the credential and select one of the following authentication methods:
    • Username and password uses the SAP username and password.
    • SAP SNC uses an encrypted connection between Xtract for Alteryx and SAP with username and password.
    • SAP Ticket Issuer uses SAP Logon-Tickets in place of user credentials. This connection is not encrypted.
  4. Enter your authentication details. The depicted example uses plain authentication.
    Plain-Credential
  5. Click [Save] to save the credential.

The credential is displayed in the list of credentials.

Tip

You can link credentials to multiple data sources.

Assign an SAP Connection to Xtract Components

  1. Drag&drop an Xtract for Alteryx component from the Alteryx Designer toolbox onto the canvas . The configuration window of the component opens.
    Create-New-Table-Extraction
  2. Select an SAP connection from the dropdown list .

If no SAP connections are available, create an Xtract data source in the Alteryx Connection Manager.

Last update: July 6, 2024