To write data to an SAP BW/4HANA application, configure an SAP ADSO object as the Target transformation in a mapping.
Specify the name and description of the SAP ADSO target. Configure the target and advanced properties for the target object.
The following table describes the SAP ADSO Writer target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the source connection.
Target Type
The source type.
Select from one of the following types:
- Single Object. Select to specify a single SAP ADSO object.
- Parameter. Select to specify the SAP ADSO object as a parameter.
Object
Target object for the task. Click Select and then select the target object.
Operation
The type of operation for the task.
Only Insert is applicable.
Preview Data
Not applicable.
The following table describes the SAP ADSO Writer advanced target properties:
Property
Description
Activate Option Mode
Loads the data into the target ADSO object and then sends data activation requests to SAP BW/4HANA based on the activate options you select.
You can select from the following activate options:
- 0-Do Not Activate. Does not send an activate request.
- 1-Activate. Creates a single activation request for all load requests in the queue.
- 2-Activate Request by Request. Creates a separate activation request for each of the load requests in the queue.
- Parameter. Use this option to parameterize the activate options. Specify a valid activate option value in the Parameter Name for Activate Option Mode field.
Default is Do Not Activate.
Parameter Name for Activate Option Mode
The parameter name that you defined for the Activate Option Mode in the parameter file.
You can specify the following values for the data fetch mode:
- 0 for Do Not Activate
- 1 for Activate
- 2 for Activate Request by Request
If you pass any other value, the jobs fail when you run the mapping,
Packet size in MB
The packet size of each SAP data packet while writing data to SAP BW4/HANA.
Default value is 10 MB.
Tracing
Sets the amount of detail that appears in the log file.
You can choose terse, normal, verbose initialization, or verbose data.
Default is normal
Activate option mode for SAP ADSO Writer mappings
You can select the activate option mode when you load data to the ADSO target in SAP BW/4HANA.
When you specify the activate mode, the Secure Agent first loads the data into the target ADSO object and then sends the data activation requests to SAP BW/4HANA based on the following activate options you select:
•0-Do Not Activate. Does not send an activate request and the activation precessing does not occur.
•1-Activate. Creates a single activation request for all load requests in the queue.
•2-Activate Request by Request. Creates a separate activation request for each of the load requests in the queue.
The activation request activates all the previous load requests in the queue that are pending for activation. Activation occurs per load request in a chronological sequence, starting from the earliest pending request to the most recent load request. The Secure Agent waits for the activation to be fully processed in SAP BW/4HANA system. The wait time depends upon the number of load requests in the queue that were available earlier to the load request associated with the current mapping.
During the activation process, if the activation of a specific load request fails, the whole activation process fails and the rest of the load requests are also not activated. In such cases, the mapping fails even though the Secure Agent loaded the data correctly based on the enabled activate mode.