Supercharge your Proficy solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Explore our Proficy 2024 releases!

Home
Get Started
Get Started Guide
Install a Reporting Database
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.

Workflow IPI
Get Started
- Get Started Guide
  - Installation Requirements
  - Pre-Installation Consideration
  - Installation Procedures
  - Server Clustering Implementation
  - Deploy the Web Task List
  - Log On Overview
  - Post-Installation Configuration
  - Upgrade Workflow
  - Install a Reporting Database
    - 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.
    - Install the reporting database
      The reporting database allows you to use the data synchronized from your production database to build reports for your facility. You can use any reporting tool to extract the information from the reporting database and create your reports.
    - Configure Component Services
      If your production database is on a different computer than the Reporting Database, the following configuration changes are required.
    - Uninstall the reporting database
      When you uninstall reporting, the database remains intact; however, you lose the ability to synchronize the data from your production database. Uninstalling reporting does not affect the production database or the data contained in it; you can still run reports on the data stored in the database.
    - Upgrade a replicated database
      When upgrading the application, if you are using a replicated database and have replication turned on, you must turn it off, upgrade, and then turn it on again. You must also upgrade the replicated database.
  - Terminal Server
  - ActiveX Task Controls
  - Workflow Task Client
  - Installation Security
  - Troubleshooting Workflow Issues
    This topic describes how to troubleshoot issues that you encounter when working with Workflow.
Tutorials
Orientation
Configure Your Environment
Security
Resource Information and Configuration
Data Administration
Forms and User Displays
Building and Configuring Workflows
eSOP
ActiveX Task Controls
Service Interfaces
Operator Task List in the Workflow Client
Best Practices

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.