When you select a Coupa V2 connection for a target, you can select an operation from the list of operations.
You can add multiple input groups into the Coupa V2 target and define the primary and foreign key relationships between the multiple input groups before the mapping.
Target Transformation Properties
You can configure target properties, such as target details and advanced properties, based on the connection type you select. Configure target transformation properties on the Target tab of the Properties panel.
When you select a target, the Properties panel displays the following areas and information:
•General. Defines the transformation name and a description.
•Incoming Fields. Includes the field rules that define the data written to the target. Allows a preview of target fields.
•Target. Defines the target connection, operation, and advanced options.
•Target Fields. Not applicable for Web Service targets.
•Field Mapping. Defines the field mappings from the upstream transformation to the target.
Advanced Target Properties
In a mapping, you can configure a target to represent a Coupa V2 target. For Coupa V2 target connections used in mapping tasks, you can configure advanced properties in the Targets page of the Mapping Task wizard.
The following table describes the advanced properties that you can configure in a Target transformation:
Property
Description
Cache Size for Web Service Request (KB)
Memory available for the web service request. If the web service request contains many rows or columns, you might want to increase the cache size. Default is 100 KB.
Transaction Commit Control
Control to commit or roll back transactions based on the set of rows that pass through the transformation. Use the transaction commit control if you have a large amount of data and you want to control how it is processed.
Input settings properties
You can enable Sorted Input under Input Settings. Sorted Input indicates that input data is presorted. Default is disabled.
Enable sorted input for better performance.
Note: When Sorted Input is enabled and the input is not sorted, the Secure Agent does not process input and the mapping fails.
Target Transformation Mapping Example
You are an operation administrator and you want to create an user group in Coupa using Coupa V2 connection.
To create an user group in Coupa from a flat file using Coupa V2 connection, perform the following tasks:
1Create a flat file connection to read data from the flat file.
2Create a Coupa V2 connection to write data to Coupa.
The following image shows the configured Coupa V2 connection:
3Create a Coupa V2 mapping.
4Add a Source transformation to include the flat file object that contains the user group information. Add the flat file connection.
5Add a Target transformation to write the user group information to Coupa using POST_UserGroups_create operation. Perform the following tasks on the Target tab:
aIn the Connection field, select the Coupa V2 connection to connect to Coupa.
bIn the Operation field, select POST_UserGroups_create as the operation.
The following image shows the POST_UserGroups_create in the list of write operations:
cIn the Advanced Properties section, set the cache size and the transaction commit interval.
6On the Field Mapping tab, select the input elements to map to the target fields.
The following image shows all the mapped fields between the input file and the Coupa V2 target:
7When you save and run the mapping in a mapping task, the Secure Agent creates the user group in Coupa.
