Skip to content

SAP Connection

This page shows how to connect to SAP.

A connection is required to use Xtract IS for designing ETL packages, extracting metadata, previewing data, and deploying data. Xtract IS provides two connection managers for accessing SAP:

  • XTRACT Connection Manager uses the Remote Function Call (RFC) protocol to connect to:
    • SAP single application servers
    • SAP message servers (Load Balancing)
  • XTRACT_ODATA Connection Manager uses the Open Data (OData) protocol to connect to:
    • SAP on-premise systems and SAP cloud systems

Warning

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

Connect to SAP

Follow the steps below to create a connection manager that connects to SAP:

  1. Create a new Integration Services Project and add a data flow task.
  2. Right-click within the “Solution Explorer” area and select New Connection Manager from the context menu. The window "Add SSIS Connection Manager" opens.
    Connection-Manager-01
  3. Select the XTRACT Connection Manager from the list of available connection managers and click [Add...]. The XTRACT Connection Manager is now available in the connection managers area.
  4. Double-click the XTRACT Connection Manager. The window "XTRACT Connection Manager" opens.
    Connection-Manager

  5. Enter the system details of your SAP system and enter the SAP username and password of an SAP system or dialogue user. For more information, see XTRACT Connection Settings.

    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.

  6. Click [Test connection] to validate the connection parameters.

  7. Click [OK] to save the XTRACT Connection Manager.

For information on how to set up Secure Network Authentication (SNC) with SAP, see Knowledge Base Article: SNC Authentication. For information on the properties the XTRACT Connection Manager, see Connection Settings - XTRACT.

  1. Create a new Integration Services Project and add a data flow task.
  2. Right-click within the “Solution Explorer” area and select New Connection Manager from the context menu. The window "Add SSIS Connection Manager" opens.
    Connection-Manager-01
  3. Select the XTRACT_ODATA Connection Manager from the list of available connection managers and click [Add...]. The XTRACT_ODATA Connection Manager is now available in the connection managers area.
  4. Double-click the XTRACT_ODATA Connection Manager. The window "XTRACT_ODATA Connection Manager" opens.
    sap-source-odata
  5. Enter the base URL of your SAP system.
  6. Enter login credentials for your SAP system.
  7. Click [Test] to validate the connection parameters.
  8. Click [OK] to save the XTRACT_ODATA Connection Manager.

For information on the properties of the XTRACT_ODATA Connection Manager, see Connection Settings - OData.

Assign Connection Managers to Xtract Components

XTRACT Connection Managers can be assigned to an Xtract component automatically or manually.

  1. Create an XTRACT Connection Manager as shown in Connect to SAP.
  2. Drag & drop an Xtract component into the data flow task.
  3. Double-click the Xtract component to automatically assign a Connection Manager. If there are multiple XTRACT Connection Managers, the window "Select Connection Manager" opens.
    select-connection-manager
    Select an XTRACT Connection Manager and click [OK].
  1. Create an XTRACT Connection Manager as shown in Connect to SAP.
  2. Drag & drop an Xtract component into the data flow task.
  3. Select the Xtract component and click Show Advanced Editor in the Properties menu of the component . The window "Advanced Editor" opens .
    assign-connection-manager
  4. Select an XTRACT Connection Manager from the drop-down-menu .
  5. Confirm your selection with [OK] .

Note

The Xtract BAPI component does not have an Advanced Editor.
To manually assign an XTRACT Connection Manager to an Xtract BAPI component, open the main window of the Xtract BAPI component. The main window of the Xtract BAPI component contains a Change Connection Manager menu.

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.

Last update: February 16, 2026