Reporting Database

Workflow includes an option to install a reporting database. This database can be used with any valid reporting tool, and allows you to build reports on up-to-date data that you synchronize from your production database.

Note: The user account used for reporting synchronization (this can be a different user than the SOA database user), must have the following SQL server roles:
  • SQLAgentOperatorRole for the msdb database, in order to initiate the SQL Agent job
  • Db_owner on the reporting database

For more information on the Reporting Database, see Reporting.