Run Extractions

This page shows how to run extractions directly in the Designer and in Board.
Extractions are triggered by an HTTP request and executed on the Board Connector Server.

The configuration of source, destination and extraction type defines how the data transfer is performed. This configuration can contain dynamic elements, like extraction parameters and script expressions.

Run Extractions in the Designer

The Board Connector Designer offers a test run option for extractions to make sure that the extraction runs properly. You can define runtime parameters and other options to run an extraction directly in your web browser.

1. Select an extraction from the list of extractions and click [Run] . The window "Run Extraction" opens.
   
2. If needed, define extraction parameters:
   • Select the checkbox of the parameter you want to override . The parameter is added to the extraction URL.
   • Enter a value for the parameter.
3. Click [Run in Browser] to display the extraction results in your browser.
   

Extractions are triggered by an HTTP request and executed on the Board Connector server.

Run Extractions in Board

Extractions can be loaded in Board using the Data Reader.
The depicted example uses an extraction "Plants" that extracts data from the SAP table T001W.

1. In Board, select [+ DATA READER] to create a new Data Reader. Enter a name and a group . Select the source type SAP.
   
2. Create a new connection to the Board Connector Server or select an existing connection. Set a name and the URL of the Board Connector Server, e.g., localhost:8197.
   
3. Click the "Connect" icon to pull a list of extractions from Board Connector.
4. Select an extraction (here: T001W) from the EXTRACTOR box on the right hand-side. The extraction's metadata (field names, data types) is listed in the window below.
5. Optionally: Specify URL parameter(s) to add to the connection string. In the depicted scenario a WHERE-clause is specified, restricting the extraction to purchasing organization (EKORG) '1000'. For more information about URL parameters, see Dynamic Connection Parameters.
6. Click [Browse Table] to get a preview of the extracted SAP data. The preview displays real or dummy data depending on the extraction type.
   
7. Click [MAPPING] to proceed to mapping the fields of the extraction with existing Board entities.
8. Select the corresponding fields for mapping (e.g., WERKS, NAME1, etc.).
9. In the column Position, map each field of the entity to an SAP field. Select the correct mode for Insert or Update. In the depicted example, the mode "ADD NEW ITEM" is selected for all fields.
10. Click [Browse Query] and [OK].
    
11. Execute the Data Reader to extract the SAP data.
    

After executing the Data Reader, the Board protocol shows how many rows are loaded.