SAP Table Sources in Mappings
To read data from an SAP application, configure an SAP Table object as the Source transformation in a mapping.
Specify the name and description of the SAP Table source. Configure the source and advanced properties for the source object.
The following table describes the source properties that you can configure in a Source transformation:
Property | Description |
|---|
Connection | Name of the source connection. |
Source Type | Select one of the following types: - - Single. Select to specify a single SAP Table object.
- - Multiple. Select to specify multiple SAP Table objects. You can use custom relationships to join multiple source objects. When you create a custom relationship for SAP Table objects, you can select the type of join and the source fields to use.
- - Parameter. Select to specify a parameter name. You can configure the source object in a Mapping Configuration task associated with a mapping that uses this source transformation.
|
Object | Source object. When you specify multiple source objects, you must create relationships between the source objects. |
The following table describes the SAP Table advanced source properties:
Property | Description |
|---|
Number of rows to be fetched | The number of rows that are randomly retrieved from the SAP Table. Default value of zero retrieves all the rows in the table. |
Number of rows to be skipped | The number of rows to be skipped. |
Packet size in MB | Packet size. Default is 10 MB. |
Enable Compression | Enables compression. If the Secure Agent and the SAP System are not located in the same network, you may want to enable the compression option to optimize performance. |
Tracing Level | Sets the amount of detail that appears in the log file. You can choose terse, normal, verbose initialization or verbose data. Default is normal. |