Coupa V2 Connector > Coupa V2 Mappings and Mapping Configuration Tasks > Coupa V2 Target Transformation in Mappings

Coupa V2 Target Transformation in Mappings

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:

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:
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:
  1. 1. Create a flat file connection to read data from the flat file.
  2. 2. Create a Coupa V2 connection to write data to Coupa.
  3. The following image shows the configured Coupa V2 connection:
    The image shows the Coupa V2 connection properties.
  4. 3. Create a Coupa V2 mapping.
  5. 4. Add a Source transformation to include the flat file object that contains the user group information. Add the flat file connection.
  6. 5. Add a Target transformation to write the user group information to Coupa using POST_UserGroups_create operation. Perform the following tasks on the Target tab:
    1. a. In the Connection field, select the Coupa V2 connection to connect to Coupa.
    2. b. In the Operation field, select POST_UserGroups_create as the operation.
    3. The following image shows the POST_UserGroups_create in the list of write operations:
    4. c. In the Advanced Properties section, set the cache size and the transaction commit interval.
  7. 6. On the Field Mapping tab, select the input elements to map to the target fields.
  8. The following image shows all the mapped fields between the input file and the Coupa V2 target:
  9. 7. When you save and run the mapping in a mapping task, the Secure Agent creates the user group in Coupa.
  10. The following image shows the Coupa V2 mapping: