Intelligent Object Connector for Veeva Data Cloud

Data from Veeva Data Cloud can be loaded into Nitro using Intelligent Object Connectors and predefined whitelists, which replace table definition files. The following whitelists are provided for Veeva Data Cloud for use with the Intelligent Object connector:

  • Veeva Data Cloud prescriber longitudinal data
  • vdc_longitudinal_prescriber
  • vdc_rcrd_cnts_pr__v
  • Veeva Data Cloud patient longitudinal data
  • vdc_patient_longitudinal__v
  • vdc_rcrd_cnts__v

When a query is run, the tables are created in Nitro. The Query Name is appended to the table names. Only one set of whitelists is needed for multiple Veeva Data Cloud queries. For example, a query named “Bacterial Conjunctivitis” results in the following tables:

  • vdc_bacterial_conjunctivitis_patient_longitudinal__v
  • Vdc_bacterial_conjunctivitis_rcrd_cnts__v

To create an Intelligent Object connector for Veeva Data Cloud:

  1. Log into the NAC.

  2. Select Inbound Connectors from the Connectors section of the side menu.

  3. Select the New Connector button.

  4. Add connector details including display name and description.

  5. Select Veeva Data Cloud as the connector type under Intelligent Objects.

  6. Select Save.

  7. Create a support ticket for Nitro to set up the VDC S3 Copy.

  8. Create a connector user in the NAC specific for this connector. This user will allow you to log into the SFTP site.

To load data to Veeva Data Cloud:

  1. Log into the NAC.

  2. Run the VDC S3 Copy to Nitro job.

  3. When the job is complete, run the Data Lake Intelligent Load job.

To access the data once the job completes, users must view the Report Current or Report History schema using a BI tool, for example, Nitro Explorer.