Create SAP connection #
Select the menu item Server -> Manage Sources.
Click on Add.
Enter the freely selectable connection name in the Name field. The SAP connection details must then be entered.
The following parameters must be set:
- Client (Client)
- Language (Language)
- User (User) and
- Password (Password).
If you want to connect to a single application server, fill the Host and System Number fields.
If you want to connect to a message server using load balancing, fill the Message Server , Group, and SID fields.
If you do not know the parameters, look in your SAP GUI or ask your SAP Basis.
Then click on Test Connection to test the successful connection.
The SAP connection has now been set up successfully.
Create Extraction #
Click New to create a new extraction.
Choose the SAP connection you created previously and give the extraction a unique name.
Then define the type of extraction. In our case, we want to extract a table from SAP.
Adding tables #
- Within the window “Define data source for SAP Tables” click [Add] to add a table.
The window “Table Lookup” opens.
- In the field Table name (1) enter the name of the table to extract.
- Click [Search] (magnifying glass) (2). Search results appear in the preview window.
- Select the desired table (3) and click [OK] (4).
Tip: Wildcard such as * are supported. Make sure to place them after the name of the searched item.
The application now returns to the main window “Define data source for SAP Tables”.
Columns of the table retrieved from SAP are displayed in the subsection Fields.
Filtering tables #
You can select either all or only individual columns for extraction.
All columns are automatically selected for table extraction. Deselect the ones you don’t wish to extract.
Click the header fields to sort the columns by name or description.
To search for a certain column name or description, start typing the word in the filter boxes.
Using live preview #
- Click [Load live preview] to load 100 records for preview.
- Click [OK] to confirm and save the extraction in the repository, i.e. on the server.