Data Extractor

This topic describes how to configure the options of the Data Extractor tab.

These settings are applied to all the SAP systems globally.

To configure the options on the Data Extractor tab

  1. In Process Runner, select Tools > Options. The Options window is displayed.
  2. Select Data Extractor.
  3. To stop all subsequent calls if a data dump is encountered, select Stop all the subsequent calls on the first short dump.
  4. To set the threshold for data extraction blocks, select Turbo Processing threshold and enter the number of rows for data extraction blocks. The default value is 1. Select the following:
    • Enable Turbo mode for Phase 1 Excel writes: Achieves better Excel performance by writing in block mode instead of row mode.
    • Set columns format to "General" while running: Applies General format to all the columns before extracting the data.
    • Remove extra space(s) for each fields: Removes extra space before or after the Excel values. This mainly applies to CHAR data types.
  5. To convert SAP date format to Excel system date, select Convert SAP date to Excel system date.
  6. To convert SAP time format to Excel system time, select Convert SAP date to Excel system time.
  7. To implement standard RFM methods of SAP for Data Extraction for all SAP systems, select Use Standard RFM. Select one of the following options:
    • Auto Method: Indicates that the standard method is used.
    • Method 1 - BBRT: Is optional and is used if the standard method fails.
    • Method 2 - RT: Is used when both the standard method and Method 1 fails.
  8. To implement extensively customized RFM methods of Magnitude for data extraction for all SAP systems, select Use Extended RFM. Perform the following:
    • Name of Extended function: Enter Y_PROCESS_RUNNER_DE in the text box.
    • Reset settings for packed numbers: Select only if instructed by Magnitude and if you are using the SAP OSS note.
  9. To set the total width of records extracted using extended RFM, enter the number in the Record/Row width text box. The default row width for standard RFM is 512.
  10. Note: To update the Use Standard RFM and Use Extended RFM settings for a specific SAP system, go to <SAPSystemName> > Properties > Data Extractor Settings from Magnitude Connector for SAP .

  11. Select Apply and then OK. The changes are saved.

You can use the Defaults option to revert to the default settings.