The following section gives a general introduction to working with Xtract IS using the Table component as an example. The information described in the following section is a prerequisite for all subsequent sections.

Note: An SAP Connection is a requirement for using any of Xtract IS components.

Creating an Extraction #

  1. Set up a Data Flow Task by dragging the dataflow component into the “Control Flow” canvas. Double-click the component to access the dataflow canvas.
  2. Add an SAP Connection using the Connection Manager.
  3. Drag & drop the Xtract Table component to the data flow task. xis_table_overview
  4. Assign a Connection Manager by double-clicking the Xtract Table component.
  5. Double-click the Xtract Table component. The window “Extract Single and Joint SAP Tables or Views” opens.

Note: To assign a specific Connection Manager instead of assigning one automatically, follow the instructions in Assign a Connection Manager.

Look up a Table #

  1. In the main window of the component click [Add] to add a table. The window “Table Lookup” opens.
    table_main-window_add
  2. In the window “Table Lookup” enter the name of the table to extract (1). Use wildcards (*) if needed.
    Look-Up-Table
  3. Click [Search] ( magnifying-glass icon) (2). Search results appear in the preview window.
  4. Select a table (3) and click [OK] (4).

All relevant metadata information of the table is retrieved from SAP. The application now returns to the main window of the component.

Set Up a Table Extraction #

Set up the Table component to extract SAP tables:

  1. Select the columns you want to extract. By default all columns are selected. Deselect the columns you do not want to extract.
    Table-Form
  2. Optional: Define a WHERE clause or a HAVING clause to filter table records. By default all data is extracted.
  3. Click [Load live preview] to display a live preview of the first 100 records.
  4. Click [OK] to save the extraction.

You can now run the extraction.