×

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.
Configure the reporting database
After initially installing the reporting database, you can change the configuration information you provided as part of that process.

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

Configure the reporting database

After initially installing the reporting database, you can change the configuration information you provided as part of that process.

About this task

Important:

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 performance reasons, we recommend that you install the reporting database on a different computer from Workflow. After installing and configuring the reporting database, you can synchronize it with your production database. If you plan on frequent synchronization for reporting purposes, we recommend that you replicate your database and run reporting against the replicated database. This measure reduces the risk of system timeout or shutdown due to locking of tables in the production database. If, upon trying to save data after replication, you receive an error similar to "System.Data.SqlClient.SqlException (0x80131904): Length of LOB data (88064) to be replicated exceeds configured maximum 65536," use SQL statements to increase the volume of data to replicate.

Note:

For information on setting up database replication, visit the Microsoft Developer Network website and review the article, SQL Server Replication.

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.

Procedure

From the navigator, click Proficy System > Proficy System > Reporting > Default Reporting Schedule.
In the Displays panel, click Reporting Schedule Editor. The Default Reporting Schedule editor appears.
In the Server name field, enter the instance name of your reporting SQL Server.
If you configured your reporting database to use Windows authentication, clear the Use a Specific User Name and Password check box.
If you configured your reporting database to use SQL Server authentication, select the Use a Specific User Name and Password check box, and then enter the SQL Server user name and password.
Click Save.

Synchronization SQL Statements


sp_configure 'max text repl size', 2147483647
GO
RECONFIGURE
GO