Enterprise Data Warehouse (EDW)

Last Updated: April 07, 2026

EDW is available for use with only Windows operating system and Microsoft SQL Database.

The EDW is a tool designed to help you to analyze your data using your own Business Intelligence (BI) tools. If you use a Microsoft SQL database, you can generate an access token from the Admin Console and download a utility to analyze your data.

With EDW, business analysts can create custom reports for resources managed with Vasion Print using standard BI tools like Crystal Reports, Domo, Tableau, and others.

Key Points

Here are some details about EDW:

  • Dimensional modeling is structured so that the tables, attributes, and values should be named clearly and descriptively, so the data structure can stand alone from the data source.
  • The business analyst who uses EDW does not necessarily need an understanding of Vasion Print to use the EDW data for reporting. However, because the data provided is related to sources Vasion Print tracks, the administrator must have it set up and configured correctly before running the reports.
  • The dimensions and facts required to build your reports are available in the EDW Dimensions topic.

You need to configure EDW before using your Business Intelligence (BI) tool to collect data on your printing environment.

Requirements

The following is required to configure EDW:

  • SQL Server version 2016 SP1 or later. Microsoft SQL Server 2019 is also required if you use Windows 11.
  • Windows Server 2016+, Windows 10, or Windows 11.
  • Admin access to your Microsoft SQL database.
  • Download the Enterprise Data Warehouse Utility.

We recommend access to Microsoft SQL Server Management Studio.

Once configured, the EDW Utility extracts, transforms, and loads data from printers and then deploys it to the SQL Server. This data is used with your BI tool to create custom reports on your printing environment. The following section guides you through this configuration.

Note that this documentation is written using Microsoft Windows Server 2019 with SQL Server 2019 Standard. We additionally suggest the use of the SQL Server Management Studio tool.

Next Steps

Here are the next steps to use EDW: