Rules and guidelines for Veeva Vault objects

General guidelines

Consider the following general guidelines when you configure mappings or mapping tasks:

• - You can't display field names by labels when you configure source fields in a mapping or mapping task.
• - You can't write column names with the leading or trailing spaces to the Veeva Vault target. The mapping trims these spaces from column names when it writes to the target.

Filter operations

Consider the following rules and guidelines when you filter data from Veeva Vault sources in mappings or mapping tasks:

• - 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:
• ▪ Boolean: 0 or 1
• ▪ Date: YYYY-MM-DD HH24:MM:SS.US
• - 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. Otherwise, the mapping fails.

Multiple source objects

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.
• - You can't use a simple filter to filter data from a related object when the parent object contains the same field name as specified in the filter condition for the related object. Otherwise, the mapping fails.

Data types

When you write data of the Attachment data type to a flat file from a Veeva Vault object, ensure that you change the Binary transformation data type to the String native data type using an Expression transformation in a mapping. Otherwise, the mapping writes incorrect data to the target.