View Data Storage / Data Warehouse in VDM

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

VDM's View Data Storage feature—also referred to as Data Warehouse—enables users to export results from the Detail and/or Summary grids (including grid-level expressions) directly to a Microsoft SQL Server database.

Each grid can be configured independently, and users can:

• Assign custom table names

• Choose between overwrite or append modes

• Automate exports through the Scheduler

What VDM Adds to the Exported Table

When data is written to SQL, two additional columns are automatically included in the table:

⚠️ Note: This feature is only supported for MS SQL connection profiles. It does not support VoVs or multi-query views.

Using View Data Storage with the Scheduler

You can also export data using VDM's Scheduler by enabling the "Export for Data Storage" option in the job wizard.

 The following properties are configurable:

• Connection Profile

• Detail/Summary Table Names

• Overwrite or Append

💡 Note: To customize export settings, use the Property Grid, not the job wizard interface. The wizard allows basic setup, but all advanced configuration must be done through the Property Grid to ensure proper export behavior.

What Gets Logged?

VDM tracks and logs the following activity related to Data Warehouse exports:

• Table creation, deletion, or append

• Record counts per export

• Connection profiles used

• Any errors, warnings, or success messages

Video Tutorial: 

Not Yet Available.

How to Create a View Data Warehouse

⚠️ Reminder: Only MS SQL connections are supported. VoVs and multi-query views are not compatible.

1. Open VDM: Launch the VDM application.

2. Open or Create a View: Load an existing .vdm view or create a new one.

3. Go to the View Options: Navigate to the View Options tab.

4. Enable Data Warehouse for the Grid(s): Choose whether you want to export the Detail, Summary, or both grids.

💡 Tip: If you plan to append data on each run, be sure to enable the Append option for the corresponding grid(s).

🖥️ UI Note: You may need to expand the Data Warehouse section manually depending on your screen resolution.

5. Select a Connection Profile: Assign a MS SQL connection profile for each desired grid.

💡 Note: Only MS SQL connection profiles are available

6. Enter a Table Name: Type a name for the new SQL table(s) that will store your data. 

💡 Note: Follow best practices for MS SQL naming conventions.

7. Save the View: Click Save to preserve your changes.

8. Run the View: Run the view to generate and transfer the data.

9. Click “Load All”: Once the view has run, click Load All to complete the export process.

10. Confirm Table Creation: Verify that the new tables were created successfully under the selected connection profile.

✅ Article Summary

This article provides a comprehensive overview of VDM's View Data Storage / Data Warehouse feature, which allows users to export data from Detail and Summary grids into a Microsoft SQL Server database. It covers configuration steps, automation through the Scheduler.