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.
If you want to overwrite the source connection properties at runtime, select the Allow parameter to be overridden at run time option.
Specify the parameter file directory and name in the advanced session properties.
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 task.
Default is Single Object.
Object
Name of the Veeva Vault source object for a single source.
Select the source object for a single source. You can also select an existing object from the list.
If you select multiple source objects as the source type, you can add multiple source objects and configure a relationship between them.
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.
If you want 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 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.
  • - Advanced. Uses an advanced filter to define a complex filter condition.
For more information on filters and operators that you can configure, see Filter options and operators.
Sort
Not applicable for Veeva Vault Connector.
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.
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: