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
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.
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: