SQL Reporting Module
The WorkflowGen SQL reporting module uses SQL views to gather important information about your users, requests, and actions, allowing you to create custom data reports.
- WorkflowGen version 7.12.0 or later
- SQL Server 2014 or later
The SQL reporting module setup files are located in the
\Databases\MsSQLServer\Reportingfolder in the manual WorkflowGen installation pack:
To install the SQL views:
- 1.Open SQL Server Management Studio (SSMS) or Azure Data Studio.
- 2.Connect to your WorkflowGen database (e.g.
- 3.Run each of the
VIEW_PUB_*.sqlfiles to create the SQL views.
If you have existing SQL views in your WorkflowGen database from an earlier version, reinstall them using these steps.
For better performance without overloading the main WorkflowGen database, you can create a dedicated SQL reporting database and replicate the SQL views data to their specific tables.
- 1.In SSMS, run
CreateReportingDatabase.sqlto create the SQL reporting database on another SQL Server database instance.
- 2.Set up your WorkflowGen database as a
Distributorto publish all the SQL views (e.g.
- 3.Set up the dedicated SQL reporting database as a
Subscriberto retrieve the data from the
Publisherin real-time data replication. For each of the SQL views, configure the respective table to receive the data from the view. For example:
DIR_V100table gets data from the
REQ_FILE_V100table gets data from the
The dedicated SQL reporting database should now be ready to use for custom data reports.
If you have an existing SQL reporting database from an earlier version, update the affected tables and columns accordingly, then reconfigure the data replication service (