\Databases\MsSQLServer\Reporting
folder in the manual WorkflowGen installation pack:WFGEN
).
VIEW_PUB_*.sql
files to create the SQL views.CreateReportingDatabase.sql
to create the SQL reporting database on another SQL Server database instance.
Publisher
and a Distributor
to publish all the SQL views (e.g. VIEW_PUB_*
).
Subscriber
to retrieve the data from the Publisher
in real-time data replication. For each of the SQL views, configure the respective table to receive the data from the view. For example:DIR_V100
table gets data from the VIEW_PUB_DIR_V100
viewREQ_FILE_V100
table gets data from the VIEW_PUB_REQ_FILE_V100
viewPublisher
, Distributor
, and Subscriber
).