PowerExchange for SAP NetWeaver User Guide

10.4.0
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.2
- 10.5
- 10.4.1

Back Next

Advanced Properties

The advanced properties determine how the Data Integration Service reads data from the SAP tables.

You can configure the following advanced properties for an SAP Table data object read operation:

Data transfer mode: You can transfer data in staging or streaming mode.

When you run a mapping in staging mode, the Developer tool creates a stage file on the SAP application server. The Data Integration Service reads source data and loads it into the stage file.

When you run a mapping in streaming mode, PowerExchange for SAP NetWeaver starts an HTTP session and requests data from SAP. SAP streams data over the HTTP protocol to the Data Integration Service.
Number of rows to fetch: You can enter the maximum number of rows that you want to fetch from the SAP table. The Data Integration Service then fetches data based on the number of rows you enter.

To read all the rows from a table, set the value to 0. Default is 0.
Number of rows to skip: You can enter the number of rows that you want to skip in an SAP table. The Data Integration Service then skips those rows that you entered and fetches the remaining rows.

For example, if you set the value to 10, the Data Integration Service skips the first 10 rows in the SAP resource and reads from the next row.

To read all the rows from a table, set the value to 0. Default is 0.
Run in background: You can choose to run a mapping in the background when the data volume is high and the Data Integration Service takes a very long time to read data from the SAP tables.
Stage file name: Name of the stage file. You can assign parameters to the stage file name.
Reinitialize the stage file: When you select the
Reinitialize the stage file
option, the Data Integration Service reads data and replaces the existing files. You can reinitialize the stage file when the source data has changed and you want to refresh the source data.

If you reinitialize the stage file without persisting it, the Data Integration Service reinitializes the stage file and deletes the stage file after reading it.

If you reinitialize and persist the stage file simultaneously, the Data Integration Service does not delete the stage file after reading the file.
Persist the stage file: When you select the
Persist the stage file
option, the Data Integration Service connects to the stage file directory where you saved the stage file and reads the file.

If you disable the
Persist the stage file
option, the Data Integration Service deletes the stage file from the stage file directory after reading it.