- 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.
Select an existing parameter for the source object or click New Parameter to define a new parameter for the source object.
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.
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.
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:
•= (Equals)
•<> (Not equals)
•< (Less than)
•< = (Less or equal)
•> (Greater than)
•> = (Greater or equals)
•Is Null
•Is Not Null
Consider the following rules and guidelines when you filter data from Veeva Vault sources in mappings or mapping tasks:
•To use advanced data filters to filter data from a Veeva Vault source, ensure that the filter condition contains only the field name, operator, and field value. Remove the object name that is added before the field name in the filter condition.
•You can't use the Contains, Starts With, or Ends With operators in a filter operation.
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 how to create advanced relationships, see Source transformation.
Consider the following rules and guidelines when you read data from multiple Veeva Vault sources in mappings or mapping tasks:
•You can't read data from a related object configured with self-referencing relationships.
•When you configure a mapping to read data from a related object that is defined with multiple relationships, you can select only one relationship instead of all relationships.
Rules and guidelines for Veeva Vault sources
Consider the following rules and guidelines for Veeva Vault objects used as sources in mappings and mapping tasks:
•You can't display field names by labels when you configure source fields in a mapping.
•When you use a simple source filter with a Veeva Vault source object that contains Boolean or Date data types, ensure that you use the following formats in the filter condition: