Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).
In this article we discuss VDM's View Data Storage / Data Warehouse feature through the Scheduler. This feature gives users the ability to write the Detail and/or Summary grid's results (includes grid level expressions) to a Microsoft SQL database; one option for each grid. You will have the ability to define the new table names for both the Detail and Summary data, with the option to overwrite or append to the table each time the View is ran.
In order to leverage the Data Warehouse through VDM's Scheduler, select "Export for Data Storage" in the job wizard. To edit the properties for this, users must do so through the property grid not the wizard. The following options can be set for the Job.
- Connection Profile
- Detail and Summary Table Names
- Overwrite or Append
Logging Related to the View Data Warehouse.
VDM logs the following information when using the Data Warehouse feature.
- Table Creation/Deletion/Append
- Records Counts
- Associated Connection Profiles
- Errors, Warnings, and Successes
Not Yet Available.
Steps to Create a View Data Warehouse Using the Scheduler.
Note: Only MS SQL connection profiles are available, and this feature does not support VoVs / multi queries.
1. Open VDM
2. Go in the Job section of the Scheduler.
3. Open or Add views / executions to the Job.
4. Inside the Execution Wizard, enable the "Export for Data Storage" option. Finish setting up any needed changes in the Wizard before the next step.
5. Modify any of the Data Warehouse properties on the property grid to the right for the selected Execution as needed.
Note: If the options/properties were set on the View prior to being set up in the Job, the values will be populated already.
Note: Follow best practices for MS SQL naming conventions.
6. Save the changes to your Job and Schedule to confirm the tables are created.