- Parameter. Select to specify a parameter where you define values that you want to update without having to edit the task.
Default is Single Object.
Object
The source object for the task.
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.
When you select a single object or multiple objects, you need to choose objects only from the vobjects data model.
Parameter
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.
The Parameter property appears only if you select parameter as the source type.
The following table describes the query options that you can configure for a Veeva Vault source:
Property
Description
Filter
Filters record 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 based on a filter condition. 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 field mapping.
- 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
Multiple source objects
You can use a single Source transformation to read from multiple objects within the same data entity. When you read from multiple Veeva Vault sources, you can create multiple Source transformations, and then use a Joiner transformation to join the sources.
To read from multiple objects using a single Source transformation, select multiple objects as the source type, and then configure a join to combine these objects. You can either add related objects with PK-FK relationships that are already defined or you can define a relationship condition to join these objects. To set your own conditions to define the relationship between the objects, select Advanced Relationship from the Related Objects Actions menu, and then define the relationship. When you configure a join expression, select the fields and define a join query syntax. You need to specify only the condition and not the type of join in the query. The condition you specify in the text box for the expression is appended to the join condition.
For more information about how to create advanced relationships, see Source transformation.
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:
General guidelines
Consider the following general guidelines when you configure a mapping or mapping task:
- You can't display field names by labels when you configure source fields in a mapping.
- You can't read data from a VeevaVault object configured with self-referencing relationships.
Filter operations
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. You need to remove the object name that is appended to the field name in the filter condition.
Data types
When you use a simple source filter to import a Veeva Vault source object that contains Boolean or Date data types, ensure that you use the following formats in the filter condition: