Reading Data from a Single SAP Table

The Read from SAP stage can be configured to read data from a single table in the SAP database or multiple tables. This procedure describes how to configure Read from SAP to read data from a single table.

  1. In Spectrum Enterprise Designer, drag Read from SAP onto the canvas.
  2. Double-click the Read from SAP stage on the canvas.
  3. In the Connection field, select the SAP server that contains the data you want to read into the dataflow. If there is no connection defined for the SAP server you need to create the connection by clicking Manage.
  4. In the Source type field, choose Single.
  5. Click Select.
  6. Select the table you want to read into the dataflow then click OK.
    Note: Only the first 200 tables are listed. Use the search feature to find tables not listed in the first 200. The search field only searches the values in the Name and Label columns.
  7. To view the field names that will be used in the dataflow, check the box Display technical name.

    Fields in SAP have a user-friendly name used for display purposes and a unique name that may be less readable. For example, a field may have a user-friendly name of "Distribution Channel" and a technical name of "DIS_CHANNEL". In order to ensure that the field name is valid in the dataflow, the technical name is used as the field name.

  8. Check the box in the Include column for each field you want to read into the dataflow.
  9. Click OK.
  10. If you want to read only certain records, you can specify filter conditions on the Filter tab. In order for a record to be read into the dataflow it must meet all the conditions you define.
  11. You can improve performance by specifying an appropriate fetch size on the Runtime tab.

    Select this option to specify the number of records to read from the database table at a time. For example, if the Fetch size value is 100 and total number of records to be read is 1000, then it would take 10 trips to the database to read all the records.

    Setting an optimum fetch size can improve performance significantly.
    Note: You can calculate an optimum fetch size for your environment by testing the execution times between a Read from DB stage and a Write to Null stage. For more information, see Determining an Optimimum Fetch Size.

    The default fetch size for Read from SAP is 10,000.

  12. Click OK.

The Read from SAP stage is now configured to read data from a single table in the SAP database into the dataflow.