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.
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:
|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:
- Navigate to Tools > EDC Tools > Jobs.
- For Type, select Workbench Export.
- To run the Workbench Export job once, click Run. To schedule a recurring export job, proceed to step 5.
- Select a Frequency other than Run Now.
- Enter a descriptive Name for your job. This displays in the Job Name column within the Job Schedule tab.
- Click Save.
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.
|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:
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.
|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:
- Navigate to Import > Packages.
- Locate your import package in the list.
- 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.