After starting the Designer, the Designer must first be connected to a server and thus to an extraction repository. In the case of a local Xtract server, the address is the localhost (as in the screenshot), or a different network address, depending on where the server component is running. The default port 8064 may differ depending on the configuration. If the server is running on a different machine than the Designer, make sure that the port is not blocked by your firewall. Click Connect to connect to the server.
After the successful connection the buttons for the new creation and the manipulation of extractions are active. The list at the bottom of the screen is filled with all extractions that have already been created on the server.
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.