Xtract OHS

This page shows how to use the Xtract OHS component.
The Xtract OHS component can be used to extract data from Open Hub Service (OHS) destinations.

Prerequisites

• A connection to an SAP system is available, see SAP Connection.
• The SAP user has sufficient user rights, see SAP Authority Objects.
• Configure your SAP BW system to make data sources accessible, see Customization for OHS in BW.

Add an Xtract OHS Component

Follow the steps below to add an Xtract Table component to your SSIS package:

1. Drag&drop the Xtract OHS component from the SSIS toolbox into your data flow task.
   

2. Double-click the component. A connection manager is automatically assigned to the component and the main window of the component opens.

   Note

   If there are multiple connection managers, the window "Select Connection Manager" opens, see SAP Connection. Once a connection manager is selected, the main window of the component opens.

The majority of the functions of the component can be accessed in the main window.

Look up an OHS Destination

1. In the main window of the component, select an Extraction type in the main window of the component.

   • Select Table if you use BW4Hana2.0 and make sure that the open hub destination type in SAP is set to database table.
   • Select Third party tool (legacy) if you use BW4Hana2.0 and make sure that the open hub destination type in SAP is set to third party tool.

   

2. Click [ Lookup]. The window “OHS Lookup” opens.
   

3. In the field OHS Destination, enter the name of an OHS destination . Use wildcards (*) if needed.
   
4. Click [ ]. Search results are displayed .
5. Select an OHS destination and click [OK] to confirm.

The application now returns to the main window of the component.

Define the Xtract OHS Component

The Xtract OHS component offers the following options for OHS extractions:

1. If Process Chain is empty, enter an SAP process chain assigned to your OHS destination, see SAP Help: Display/Maintenance of Process Chain Attributes.

   Note

   If Process Chain is left empty, the extraction fails.

   

2. Optional: Use the Timeout setting to set a maximum time period to wait for a notification from the BW system. If the time limit is reached, the extraction fails.

3. Check the Settings before running the SSIS package.
4. Click [OK] to save the component.

You can now run the SSIS package.