Getting Started

This section shows how to install and set up Xtract IS for the first time.

Installation

1. Download a 30 day trial version of Xtract IS or download the latest version from the customer portal.
2. Make sure you meet all prerequisites, before installing Xtract IS.
3. Run the Xtract IS executable (XtractISSetup.exe) to install Xtract IS. For information on system requirements, see Requirements.
4. Open Visual Studio and create a Visual Studio Integration Services project. The Xtract IS components are available in the SSIS toolbox of a Data Flow Task.

For more information, see Setup.

Connect to SAP

Before connecting to SAP for the first time, set up an SAP dialog user with the necessary SAP user rights.

1. Create a new connection manager by right-clicking within the “Solution Explorer” area and selecting New Connection Manager in the context menu. The window “Add SSIS Connection Manager” opens.
   
2. Select the XTRACT Connection Manager from the list of available connection managers and click [Add...]. The XTRACT Connection Manager is now available in the connection managers area.
3. Double-click the XTRACT Connection Manager. The window "XTRACT Connection Manager" opens.
   
4. Enter the system details of your SAP system and enter the SAP username and password of an SAP system or dialogue user.
   Input values for the SAP connection can be found in the Properties of the SAP Logon Pad or they can be requested from the SAP Basis team.
5. Click [Test connection] to validate the connection parameters.
6. Click [OK] to save the XTRACT Connection Manager.

For more information, see SAP Connection.

Use Xtract Components in Data Flow Tasks

Follow the steps below to add an Xtract component to your data flow task:

1. Set up a Data Flow Task by dragging the dataflow component into the "Control Flow" canvas. Double-click the dataflow component to open the dataflow canvas.
2. Make sure that at least one XTRACT Connection Manager is available in the data flow task.
3. Drag & drop an Xtract component from the SSIS toolbox into the data flow task:
   
4. Double-click the Xtract component. An XTRACT Connection Manager is automatically assigned and the main window of the component opens. The majority of the functions of the component can be accessed in the main window.

Xtract IS offers the following components:

A Simple SAP Data Extraction for Beginners

Follow the steps below to extract customer master data from the SAP table KNA1:

1. Drag & drop an Xtract Table component from the SSIS toolbox into the data flow task.
2. Double-click the Xtract Table component. An XTRACT Connection Manager is automatically assigned and the main window of the component opens.
3. Click [Add] to look up an SAP table. The window “Table Lookup” opens.
   
4. In the field Table Name, enter the name of the table to extract (KNA1) . Use wildcards (*) if needed.
   
5. Click [ ] . Search results are displayed.
6. Select the table KNA1 and click [OK]. The application returns to the main window of the component.
7. Optional: Select the table columns you want to extract. By default all columns are extracted. For more information on filter options and advanced settings, see, Define the Xtract Table Component
8. Click [Load live preview] to display a live preview of the first 100 records.
9. Click [OK] to save the component.

You can now add tools to process the data returned by Xtract Table and run the SSIS package.