Veeva Vault Connector > Mappings and mapping tasks with Veeva Vault Connector > Veeva Vault targets in mappings
  

Veeva Vault targets in mappings

To write data to Veeva Vault, configure a Veeva Vault object as a target in a mapping.
Specify the name and description of the Veeva Vault target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure for a Veeva Vault target:
Property
Description
Connection
Name of the target connection.
You can select an existing connection or create a new connection, or define parameter values for the target connection property.
To overwrite the target connection properties at run time, select the Allow parameter to be overridden at run time option.
Object Type
Type of the target object.
Select one of the following object types:
  • - Single Object. Select to specify a single Veeva Vault target object.
  • - Parameter. Select to specify a parameter where you define values that you want to update without having to edit the mapping.
Default is Single Object.
Object
The target object for the task.
Select the target object for a single target.
Parameter
This property appears only if you select parameter as the object type.
A placeholder to dynamically assign values at run time for the target object without the requirement to edit the task.
Select an existing parameter for the target object or click New Parameter to define a new parameter for the target object.
To overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option.
Operation
Type of the target operation.
Select one of the following operations from the list:
  • - Insert
  • - Update
  • - Upsert (Update or Insert)
  • - Delete
  • - Data Driven. Not applicable
Default is Insert.
Update Columns
This property appears only if you select update, upsert, or delete as the operation type.
Select the unique key column as the condition field for the update, upsert, or delete operation in a Veeva Vault target.
Data Driven Condition
Not applicable.
The following table describes the advanced target properties that you can configure for a Veeva Vault target:
Property
Description
Staging File Directory
The directory on the Secure Agent machine where target data is temporarily stored before the mapping writes data to Veeva Vault.
Update As Upsert
Upserts data to the target.
Select when you choose the operation type as Upsert (Update or Insert) and perform both the update and insert operations on the target.
Default is disabled.
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops them. By default, the mapping task forwards rejected rows to the next transformation.
If you select the Forward Rejected Rows option, the Secure Agent flags the rows as rejected and writes them to the reject file.
If you don't select the Forward Rejected Rows option, the Secure Agent drops the rejected rows and writes them to the session log file. The Secure Agent does not write the rejected rows to the reject file.
Default is enabled.