SAP Connector > Part IV: Data Integration using SAP Table > Mappings and mapping tasks with SAP Table > SAP Table sources in mappings
  

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 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
The HTTP packet size.
When you use bulk mode to read data from an SAP table, you can tune the packet size to increase the throughput. Tune the packet size according to the network bandwidth, memory, and CPU resources available on the Secure Agent. Based on the packet size that you configure and the row length, the Secure Agent calculates the number of rows to be read in a single packet. If you increase the packet size, increase the heap size accordingly to improve the throughput.
Default is 10 MB.
Data Extraction Mode
You can use one of the following modes to read data from an SAP Table:
  • - Normal Mode. Use this mode to read small volumes of data from the SAP Table.
  • - Bulk Mode. Use this mode to read large volumes of data from the SAP Table. Use bulk mode for better performance. Bulk mode consumes more resources as compared to normal mode. You might need to tune the packet size according to the available resources and data set to increase the performance.
Default is normal mode.
Enable Compression
Enables compression.
If the Secure Agent and the SAP system are not located in the same network, you might want to enable the compression option to optimize performance.
Update Mode
When you read data from SAP tables, you can configure a mapping to perform delta extraction. You can use one of the following options based on the update mode that you want to use:
  • - 0- Full. Use this option when you want to extract all the records from an SAP table instead of reading only the changed data.
  • - 1- Delta initialization without transfer. Use this option when you do not want to extract any data but want to record the latest change number in the Informatica custom table /INFADI/TBLCHNGN for subsequent delta extractions.
  • - 2- Delta initialization with transfer. Use this option when you want to extract all the records from an SAP table to build an initial set of the data and subsequently run a delta update session to capture the changed data.
  • - 3- Delta update. Use this option when you want to read only the data that changed since the last data extraction.
  • - 4- Delta repeat. Use this option if you encountered errors in a previous delta update and want to repeat the delta update.
  • - Parameter. When you use this option, the Secure Agent uses the update mode value from a parameter file.
Default is 0- Full.
Parameter Name for Update Mode
The parameter name that you defined for update mode in the parameter file.
Override Table Name for Delta Extraction
Overrides the SAP table name with the SAP structure name from which you want to extract delta records that are captured with the structure name in the CDPOS table.
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.