Importing Data from Vault EDC into Data Workbench


With Vault CDMS, you can easily move data from Vault EDC into Vault Data Workbench with the Workbench Export job. The Workbench Export job exports your study’s execution data from EDC to the Data Workbench application. In Data Workbench, Vault creates a Core Listing for each Form in your study. Each time you run this job, Vault updates the data within Data Workbench to reflect that in EDC.

In the current release, Vault Clinical DataBase (CDB) is only available to specific early adopter customers. Contact your Veeva Services representative for details.
Prerequisites

Before you can use the Workbench Export job to move data from EDC to Workbench, Veeva Services must perform some additional configuration tasks to connect your Study in EDC to your Study in Workbench. Contact your Veeva Services representative for details.


The following permissions are required to perform the actions described below.

Users with the standard CDMS Lead Data Manager study role or the Vault Owner security profile can perform the actions described below by default. If your vault uses custom Study Roles, your role must have the following permissions:

Type Permission Label Controls
Standard Tab EDC Tools Tab

Ability to access the EDC Tools tab

Functional Permission Manage Jobs

Ability to create, edit, and delete scheduled jobs

If your Study contains restricted data, you must have the Restricted Data Access permission to view it.

Learn more about Study Roles.


Run the Workbench Export Job in EDC

You can choose to run the Workbench Export job once, or schedule it on a recurring basis.

To create a Workbench Export job:

  1. Navigate to Tools > EDC Tools > Jobs.
  2. Click + New Job. New Job Button

  3. For Type, select Workbench Export.
  4. To run the Workbench Export job once, click Run. To schedule a recurring export job, proceed to step 5.
  5. Select a Frequency other than Run Now.
  6. Enter a descriptive Name for your job. This displays in the Job Name column within the Job Schedule tab.
  7. Select a time to Run at for your job. The New Job dialog to schedule a Workbench Export job, running daily at 12:00AM

  8. Click Save.

Job Statuses

Vault displays the status of your job in the Job History, along with other details about the job. You can click the Information (i) icon for additional details about a job.

Status Meaning
In Progress Vault is currently performing the job.
Failed The job instance encountered one or more errors.
Completed The job instance completed without errors.

Job Logs & Output Files

Vault provides a CSV job log file for each job. This log includes details about which objects were affected by the job and whether or not the job was successful on each object. When applicable, Vault also provides a link to the output files from a job. For example, a link to download the ODM XML file for an ODM Export job.

To access these files, click the icon in either the Log or File column.

Vault automatically sends the output file to Vault CDB. You can download and view the output from EDC Tools > Jobs or from Workbench > Import.

Importing the Data in Workbench

Workbench automatically imports the data exported from Vault EDC, without any additional action from you. Similarly to how 3rd party data is imported into Workbench, the data exported from Vault EDC is normalized at the Form level.

Workbench automatically generates a Core Listing for each unique Form in a Study. The default CQL query for these listings is:

SELECT @HDR, * from source.filename

For example, if a Study contains a Chemistry form and a Hematology form, Vault creates two Core Listings: Chemistry and Hematology, using these queries:

Chemistry
SELECT @HDR, * from labs.Chemistry
Hematology
SELECT @HDR, * from labs.Hematology

Viewing Import Status

You can check the status of your import package from Import > Packages. This page lists the status of every import package, from both Vault EDC and 3rd party tools. You can also download import packages and issue logs (errors and warnings) from this page.

Downloadable import packages and issue logs only include restricted (blinded) data when downloaded by users with permission to access restricted data.

Any time you import a package into Workbench, Workbench automatically reprocesses the most recent packages for all other sources. For example, when your nightly Workbench Export EDC job runs, and then imports into Workbench, Workbench reprocesses your most recent Lab Data and Imaging packages as well.

Workbench Import Statuses

When an import package is able to import with only warnings, Workbench highlights the status in orange to indicate that there are warnings. When import finishes, you can download the issue log to review the warnings.

Status Description
In Progress The import process has begun for this package, and Workbench has not identified any errors or warnings.
In Progress (with warnings) The import process is ongoing, but Workbench has identified a warning.
Error Import failed because there are one or more errors in the import package. Download the issue log and review the errors.
Complete Workbench imported the package successfully, with no errors or warnings.
Complete (with warnings) Workbench imported the package successfully, but there are one or more warnings. Download the issue log and review the warnings.
Not Imported Workbench skipped this package because a newer package for the same source was uploaded before processing began.
Reprocess in Progress Workbench has begun reprocessing this package because a new package from another source was imported.
Reprocessed Complete Workbench finished reprocessing this package with no errors or warnings.
Reprocessed Complete (with warnings) Workbench finished reprocessing this package, but there are one or more warnings. Download the issue log and review the warnings.
Reprocessed Error Reprocessing failed because there are one or more errors in the import package. Download the issue log and review the errors.

Download the Import Package

To download the import package:

  1. Navigate to Import > Packages.
  2. Locate your import package in the list.
  3. Click the Package link.
    Click to download the import package

  4. Extract the files from the ZIP folder and view them in a tool of your choosing.

Download the Issue Log

You can download an Issue Log (CSV) that lists all errors and warnings that Workbench encountered while importing the package. See a list of possible errors and warnings here.