The following section describes the functions of the Xtract Query component of Xtract IS.

Warning! Missing Authorization To use the SAP Query component, access to the designated authority objects (RFC) in SAP must be available. For more information, refer to the knowledge base article SAP User Rights: SAP Query.

Tip: To get information on the basics, refer to Getting Started with Xtract IS.

How to use the Xtract Query component #

  1. Define a valid connection manager that connects to an SAP system, see Connection Manager.
  2. Drag&drop the Xtract component from the SSIS toolbox into your data flow task.
    Toolbox

  3. Double-click the component. The main window of the component opens. The majority of the functions of the component can be accessed using the main window.

More information on working with the Xtract Query component is provided in the following sections.


Defining a Query Extraction

Variants and Selections

Settings

Parameterization