Connecting to SAP #

Every Xtract IS component needs a connection manager to establish access to the SAP system.

Warning! Missing Authorization To establish a connection to SAP the access to general authority objects (RFC) must be available. Make sure to gain access to the general authority objects. For more information, refer to the knowledge base article SAP User Rights.

  1. To create a new connection manager right-click in the connection managers within “Solution Explorer” area and choose New connection Manager. The window “Add SSIS Connection Manager” opens. Connection-Manager-01
  2. Select the XTRACT Connection Manager from the list and click [Add]. Xtract IS Connection manager appears under the tab Connection Managers.
  3. To configure the SAP connection, double-click the Xtract IS Connection Manager icon. The window “Xtract IS Connection Manager” opens. Connection-Manager
  4. Fill in all the necessary data (Client, Username, Password ect. see below).
  5. Click [Test connection] to check the connection to your SAP system.
    If the connection test is successful, the Xtract IS component is ready to use.

SAP source system (1) #

There are two possibilities to connect to an SAP source system:

  1. Use Single Application Server
    • Application server: host name or IP address of the application server (Property Host)
    • Instance number: a two-digit number between 00 und 99 (Property SystemNumber)
  2. Use Load Balancing Server (message server)
    • System ID: three-digit System ID (Property SID e.g., MSS)
    • Message Server: name or IP address of the message server (Property MessageServer)
    • Logon group: property LogonGroup, usually PUBLIC See also SAP online help: Load Balancing.

Accessing via SAP 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.
If the application server is “hamlet” and the router string is “/H/”, set the host property to “/H/”.

See also SAP online help: SAP-Router.

Tip: Values to fill out the forms can be found in the SAP Logon Pad in the Properties or acquired from SAP Basis team.

Trace Directory (2) #

You can log debug information and save it locally. Fill the Trace directory field with a local path to a folder, where you want to save the debug information. See further details in the knowledge base article Trace Directory.

Warning!: Increase of used hard drive memory
A big amount of information is collected when debug logging is activated. This can decrease the capacity of your hard drives dramatically. Activate the debug logging only when necessary e.g., upon request of the support team.

RFC libraries (3) #

The RFC API (Remote Function Call) allows to establish an RFC connection to an SAP system from an external system that communicates as Client or Server with the SAP system.
There are two options for using RFC libraries in Xtract IS:

  • Use classic RFC library (librfc32.dll)
  • Use NetWeaver RFC libraries (sapnwrfc.dll)

Recommendation: Use the not supported librfc32.dll for some extraction types, e.g., DeltaQ as runs more stable than the NetWeaver RFC library.

See additional information on SAP libraries on the SAP Help Site - RFC Libraries
SAP does not support librfc32.dll anymore.

For some older SAP releases, e.g., R/3 4.6C, it is necessary to enter the user name in upper case when using the NetWeaver RFC library.

Note: When using the NetWeaver RFC library with DeltaQ or OHS extractions, the RFC destination in SM59 must be set to Unicode.

Additions (4) #

In the upper part of the “Xtract IS Connection Manager” click Additions (4). The window “Xtract IS Connection Manager Additions” opens. XIS_ConnectionManager_AdditionsTab


In the window “Xtract IS Connection Manager Additions” you can find several SNC (Secure Network Connection) options. For more details see SAP Connection with SNC

Expert Options

Since 09.2017, SAP connection parameters are no longer stored as Connection Strings, but as Properties.
There is a Property for each component of the Connection string.

  • Legacy storage mode (connection string):
    SAP connection parameters are set via a single Connection string (default in XIS versions pre 09.2017). You can either use Connection properties or a Connection string, not both. Connection string does not support sensitive environment variable.
  • Obfuscate Password:
    Masks the SAP connection password. This option is switched on per default when activating Legacy storage mode.
  • Internal Table Function:
    States the function module used for Xtract IS’ internal communication with SAP, e.g., retrieving metadata. To change the selected function module, type the name of function module manually. Using another function module can be necessary when adding permission restrictions within the functional module.
  • AttachesSapGui:
    This option is only acessible in the Properties of the Connection Manager and not in the GUI. There are Reports and BAPIs that require an installed SAP GUI even when they are called remotely. In this case, set the AttachesSapGui property in the Expert Options of the Connection Manager to True.

Warning! ‘sapgui’ start failed. Sometimes SAP opens a pop-up window that requires input when running extractions. To deactivate pop-up windows, open the SAP GUI Logon pad and navigate to Options… > Security Settings. Click the [Open Security Configuration] button and select Allow as the Default Action. Apply the changes and close the SAP GUI Logon pad.

Assigning a Connection Manager to an Xtract Component #

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

Automatically Assign a Connection Manager

  1. Create a Connection Manager as shown in Connecting 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 multiple Connection Managers are available, the window “Select Connection Manager” opens. Select a Connection Manager and click [OK].

Manually Assign a Connection Manager

  1. Create a Connection Manager as shown in Connecting to SAP.
  2. Drag & drop an Xtract component into the data flow task.
  3. Select the Xtract component. Under Properties open Show Advanced Editor (1). The window “Advanced Editor” opens (2).
  4. Select a Connection Manager from the drop-down-menu (3).
  5. Confirm your selection with [OK] (4).

Note: The Xtract BAPI component does not have an Advanced Editor. To manually assign a 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.