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

Veeva Vault sources in mappings

To read data from Veeva Vault, configure a Veeva Vault object as a source in a mapping.
Specify the name and description of the Veeva Vault source. Configure the source, query options, and advanced properties for the source object.
The following table describes the source properties that you can configure for a Veeva Vault source:
Property
Description
Connection
Name of the source connection.
You can select an existing connection, create a new connection, or define parameter values for the source connection property.
To overwrite the source connection properties at runtime, select the Allow parameter to be overridden at run time option.
Source Type
Type of the source object.
Select one of the following source types:
  • - Single Object. Select to specify a single Veeva Vault source object.
  • - Multiple Objects. Select to specify multiple Veeva Vault source objects.
  • - 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 source object for the task. You can choose objects only from the vobjects data model.
Select the source object for a single source.
When you select multiple source objects as the source type, you can add multiple source objects and configure a relationship between them.
Parameter
This property appears only if you select parameter as the source type.
A placeholder to dynamically assign values at run time for the source object without the requirement to edit the task.
Select an existing parameter for the source object or click New Parameter to define a new parameter for the source object.
To overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option.
The following table describes the query options that you can configure for a Veeva Vault source:
Property
Description
Filter
Filters records based on the filter condition in a read operation.
You can configure a simple filter or an advanced filter to filter rows from the source. You can improve efficiency by filtering early in the data flow.
Click Configure to add conditions to filter records from the data that the Secure Agent reads from the source.
Select one of the following filter options from the list:
  • - Not Parameterized. Uses a basic filter to specify the object, field, operator, and value to select specific records.
  • - Completely Parameterized. Uses a parameter to represent the filter condition.
  • - Advanced. Uses an advanced filter to define a complex filter condition.
Default is Not Parameterized.
For more information about filters and operators that you can configure, see Filter options and operators.
Sort
Not applicable.
The following table describes the advanced source properties that you can configure for a Veeva Vault source:
Property
Description
Page Size
Determines the number of rows to read in each request.
Specify 0 to read all rows from the source.
Default is 0.
Page Offset
Sets the number of rows you can skip from the beginning of the dataset before returning the result.
For example, you can set this property to n to skip the first n rows in a source and read from the (n+1) row.
Default is 0.
Tracing Level
Determines the amount of detail that appears in the log file.
Select one of the following options from the list:
  • - Terse
  • - Normal
  • - Verbose Initialization
  • - Verbose Data
Default is Normal.

Filter options and operators

You can configure the Source transformation to filter data before the data enters the data flow. Use either a simple or advanced filter.
To filter data, configure the source query options on the Source tab of the Source transformation. Expand the Query Options section, and configure the filter condition.
When you configure a filter, you can use the following operators in a filter expression:

Multiple source objects

You can configure the Source transformation to read from multiple Veeva Vault objects.
To read from Veeva Vault related objects in a mapping, select Multiple Objects as the Source Type.
You can define relationships between the objects by selecting Add Related Objects or Advanced Relationship from the Related Objects Actions menu.
For more information about creating advanced relationships, see Source transformation.