View Data Storage / Data Warehouse

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. This view level 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.

When creating the Data Warehouse, VDM will add two additional columns in the data.

1. VDMImportDateTime - Date/Time Field: writes current system date/time.
2. VDMReportFileName - Varchar(250) Field: writes the .vdm report file name.

NOTE: Only MS SQL connection profiles are available, and this feature does not support VoVs / multi queries.

This feature is also supported through VDM's Scheduler by selecting "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.

1. Connection Profile
2. Detail and Summary Table Names
3. Overwrite or Append

Logging Related to the View Data Warehouse.

VDM logs the following information when using the Data Warehouse feature.

1. Table Creation/Deletion/Append
2. Records Counts
3. Associated Connection Profiles
4. Errors, Warnings, and Successes

Video Tutorial: 

Not Yet Available.

Steps to Create a View Data Warehouse.

Note: Only MS SQL connection profiles are available, and this feature does not support VoVs / multi queries.

1. Open VDM

2. Open or create a view.

3. Click on the View Options ribbon bar.

4. Select which grid(s) you want to create a data warehouse for.

OPTIONAL: If you want to append the table, make sure to enable each accordingly. 

Note: You may need to click / Expand the Data Warehouse options depending on the size of your screen.

5. Select the Connection for each selected grid.

Note: Only MS SQL connection profiles are available

6. Enter a table name to create on the selected connection for each grid.

Note: Follow best practices for MS SQL naming conventions.

7. Save any changes to the View, then run it.

8. Click the Load All button after the view finished running.

9. Browse to your connection that your tables were created on to confirm the proper tables were created.