After successfully establishing a connection to the server, the buttons to create and configure extractions are enabled. The list shows all the extractions, which have already been created on the server.
Step A: Create SAP Source Connection
Select the menu Server -> Manage Sources.
Set the connection name in the Name field.
Set the SAP connection details.
The form must be filled in as shown below.
Please fill in the text boxes with the logon data (Client, Language, User, Password).
To log on to a single application host, fill in the fields Host and System Number.
To log on by load-balancing the message server field, the logon group and SID must be filled in.
If you do not know what these parameters in your SAP system environment are, please ask your SAP Basis Components department for help.
If everything is filled in correctly, try to establish a connection to SAP by clicking the Test Connection button.
The SAP Source connection is successfully created.
Step B: Create SAP Extraction
Click New to define a new extraction and select the SAP source connection.
Enter a unique name. Select the extraction type SAP Table or View to extract data from an SAP table. and click OK.
Now the Table window opens. Click the binocular button to open a dialog for selecting a table.
Enter the name of the table (wildcards like * are supported) and click the binocular button again to invoke the search.
The editor is now filled in with all the columns from the table. The columns must be marked in the checkbox before they can be extracted.
To define an optional WHERE statement, please fill in the multi-line text box below the grid. The statement must be conform to the OpenSQL Standard. Please remember that it is necessary to put blanks between the values and the operators.
Click OK to save the extraction to the repository of the Xtract Server.
Step C: Define the extraction destination
After the extraction has been created, we have to define the destination, where the SAP data should be loaded to. In this scenario we use the default destination http-csv, the extraction data can be requested via http and is delivered in csv format.
Click on Destination to check the extraction-specific settings.