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.
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.
Now the empty table dialog opens. Click on the Search button to search for a table.
In the search dialog enter the name of the table to be extracted, click on the Search button, select the desired table and confirm with OK.
As you can see, you can also enter a wildcard (*) in the search bar.
The application now returns to the main dialog. The columns of the table were retrieved from SAP and can be selected for extraction by clicking
. It is possible to select or deselect all columns available in the table via Select All or Select None or to select the columns to be extracted individually.
WHERE conditions can still be specified in the text field. These must correspond to the standard for OpenSQL specified by SAP.
Confirm with OK to save the extraction in the repository, i.e. on the server.