Xtract Query

This page shows how to use the Xtract Query component.
The Xtract Query component can be used to extract data via SAP queries.

About SAP Queries

SAP Queries are used to access data sets in SAP, see SAP Help - Working with Queries for more information. The SAP queries that can be used with Xtract Query component are created by the SAP transactions SQ02 and SQ01. To use a BW Query as a data source, see BW InfoCubes and BExQueries.

Prerequisites

• A connection to an SAP system is available, see SAP Connection.
• The SAP user has sufficient user rights, see SAP Authority Objects.

Add an Xtract Query Component

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

1. Drag&drop the Xtract Query 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 SAP Query

1. In the main window of the component, click [ ]. The window "Query Lookup" opens.
   
2. Enter the name of an SAP query in the field Query Name or the name of a user group in the field User group . Use wildcards (*) if needed.
   
3. Select the query work area that contains the query object . For more information, see SAP Help: Query Areas.
4. Click [ ]. Search results are displayed.
5. Select a query and click [OK].

The application returns to the main window of the component.

Define the Xtract Query Component

The Xtract Query component offers the following options for query extractions:

1. If the SAP query has variants, select a variant from the drop-down-list Variant. For more information, see Choose a Variant.
   
2. In the section Selection Screen, edit a selection criterion you want to change or dynamize . For more information, see Edit Selections.
   
3. Check the Settings before running the SSIS package.
4. Click [OK] to save the component.

You can now run the SSIS package.