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

Home
Data Administration
Reporting
Reporting
Creating reports on data is an important part of any business and Workflow provides a reporting database for you to install that is specially designed to facilitate reporting and analysis. You can use any valid reporting tool with the reporting database and you have the flexibility to design your own ad-hoc reports.
Default Reporting Schedule Editor
The Default Reporting Schedule editor is used to configure a connection with your reporting database, and to configure the synchronization schedule between the production and reporting databases. Synchronizing the two databases allows you to run up-to-date reports on your data.
Manually synchronize databases

Workflow IPI
Get Started
Tutorials
Orientation
Configure Your Environment
Security
Resource Information and Configuration
Data Administration
- Data Administration Introduction
- Electronic Signatures and Audit Trails
- Data Sources
- Archives
- Custom Property Types
- Transferring Workflow
- Reporting
  - Reporting
    Creating reports on data is an important part of any business and Workflow provides a reporting database for you to install that is specially designed to facilitate reporting and analysis. You can use any valid reporting tool with the reporting database and you have the flexibility to design your own ad-hoc reports.
    - Reporting Database Replication
      Workflow includes an option to install a reporting database. This database can be used with any valid reporting tool, and allows you to build ad-hoc reports on up-to-date data that you synchronize from your production database.
    - Default Reporting Schedule Editor
      The Default Reporting Schedule editor is used to configure a connection with your reporting database, and to configure the synchronization schedule between the production and reporting databases. Synchronizing the two databases allows you to run up-to-date reports on your data.
      - Access the Default Reporting Schedule Editor
      - Configure the reporting database
        After initially installing the reporting database, you can change the configuration information you provided as part of that process.
      - Manually synchronize databases
      - Synchronize databases using scheduled events
        Synchronizing databases allows you to run reports on up-to-date data.
      - Activate and deactivate a synchronization event
    - Reporting Datamart Tutorial
    - Post-Installation Checks for Reporting
    - Microsoft Reporting Service Samples Files
Forms and User Displays
Building and Configuring Workflows
eSOP
ActiveX Task Controls
Service Interfaces
Operator Task List in the Workflow Client
Best Practices

Manually synchronize databases

Before you begin

You must configure your reporting database before you can synchronize it with your production database.

Note: You cannot synchronize your databases manually if there are unsaved changes to the Reporting Schedule Editor.

Procedure

From the navigator, click Proficy System > Proficy System > Reporting > Default Reporting Schedule.
In the Show Compatible panel, click Reporting Schedule Editor. The Default Reporting Schedule editor appears in the Workspace.
In the Manual Synchronization area, click Synchronize NOW.
If manual synchronization starts, the Feedback Zone displays a status message that manual synchronization has started. If manual synchronization fails, the Feedback Zone displays an error message.
Note: The Feedback Zone does not indicate whether manual synchronization is successful. You can use the reporting database auditing tables to determine that status of a data synchronization.