Match & Download from Veeva OpenData


During data load, you can automatically match incoming records against records in Veeva OpenData and download the matched records to your Network instance.

To match records against Veeva OpenData, you must have a subscription for Veeva OpenData for that country so those records are available for match consideration. The settings in the OpenData subscription; however, are not used for this feature. If an incoming record is matched with a record in Veeva OpenData, only the OpenData record is downloaded; no parent HCO records are downloaded with the record.

Enable the feature

To enable this in your source subscription, select the following settings:

When you enable these settings, the match process first looks for matches to OpenData records that exist in your Network instance. If a match is found using any of the ACT match rules, your locally managed record is merged into that Veeva OpenData record.

Enable additional match options

Administrators can enable the Consider records in OpenData Master setting that directs the match process to keep looking the highest ranked match. This means that Network will continue looking for a superior match in the Veeva OpenData master instance even if a match has already been found in your Network instance. This ensures that you have the best possible match.

To make this option available in your Network instance, contact Veeva Support. After it is enabled by Veeva Support, administrators can select the Consider records in OpenData Master setting on the General Settings page.

Downloaded records limit

A limit of 5000 records can be downloaded when each source subscription job runs. The limit ensures that customers who pay for Veeva OpenData per record do not accidentally match and download OpenData records in bulk. The limit is set by country because you might buy OpenData per record in some countries but you have an Enterprise Level Agreement (ELA) for other countries.

This enhancement is enabled by default when you buy OpenData per record in a country.

Note: This limit does not apply to ELA customers.

Exceeding the record limit

When the job runs, incoming records that are matched with records in Veeva OpenData are downloaded to your Network instance.

If you buy OpenData per record in that country and the job tries to download more than 5000 matched records, the job will fail; no records will be created or updated in your Network instance. The Job Error Log advises that the number of matched records exceeds the limit of records that can be downloaded for the country.

To increase the limit or discuss your subscription options, contact Veeva Support.

Reporting on downloaded records

Users with access to advanced reporting can create a query to view the number of records that were downloaded from Veeva OpenData for any job. A metric, {object_name}.mam.downloaded, has been added to the job_stats reporting table to support this query. Use the job ID to create your query.

Example query

SELECT
        *
    FROM
        job_stats
    WHERE
        job_id = '3496'

Match considerations

In source subscription jobs, matches are identified using key matching (local records) and fuzzy matching (the match rules that are defined in the Match Configuration section of the subscription).

If fuzzy match is not enabled for the subscription (in Advanced Mode, the property job.match.fuzzyMatch is set to false) but Match & Download from OpenData is enabled, Network uses keys (custom keys and alternate keys) to match local records but still uses the match rules in the source subscription to find matches between local records and records in the Veeva OpenData instance. If Network entity IDs (VIDs) are included in the source file, the VIDs are used in the key matching to look for matches between local records and records in the Veeva OpenData instance.

This could result in a match being found to a record in Veeva OpenData, and then the record will be downloaded to your Network instance. If the Veeva OpenData record was in your Network instance, it will be updated by the resulting merge or download.

Downloading unsubscribed Veeva OpenData records

Veeva OpenData records can be unsubscribed. If Match & Download from OpenData is enabled, the unsubscribed records can be matched during data load and downloaded to your Network instance again.

If an incoming file includes Veeva IDs (VIDs) that have been have mapped in the source subscription, Network uses them as a key/ID match.

When using fuzzy match to match against OpenData, unsubscribed OpenData records can be downloaded. When the match is identified by VID, a match will not be found.

Moving custom keys between merged records

If your source subscription creates a match and a Veeva OpenData record is downloaded to your Network instance, a custom key (created by the subscription job) is added to the downloaded record. If the record that is downloaded is the merge loser, it will still be updated with an active custom key. The winning record should contain the custom key because it indicates the source that contributed data. To inactivate the custom key on the losing record and add it to the winning record, perform a Sync with OpenData job from the search results or the Data Lineage page. For more information, see Sync with OpenData.