TN 029: Using Dream Report with AVEVA Edge HMI and InduSoft Web Studio

1.    Summary

This Tech Note describes actions to be performed in order to connect Dream Report to AVEVA InTouch Edge HMI (Machine Edition) and InduSoft Web Studio projects.

This document is applicable to the following versions of products:

·         Dream Report:   4.83x, 5.x, 2020R2

·         InTouch Edge HMI/InduSoft Web Studio:   8.0, 8.0 SP1, 8.0 SP2, 8.1, 8.1 SP1, 8.1 SP2, 8.1 SP3, 8.1 SP4, 8.1 SP5, 2020

2.    Supported Drivers

Various versions of Dream Report include different sets of drivers, and use various naming systems for them (as applicable to the respective software, at their time of release).

In Dream Report Studio, the drivers for connecting to InTouch Edge applications are located in the AVEVA (Wonderware) folder of Dream Report’s Communication Configuration Wizard. The names of the drivers are as follows:

 The drivers for connecting to IWS projects are located in the InduSoft folder of the DR’s Communication Configuration Wizard. The names of the drivers are as follows:

* - Legacy drivers are applicable for Wonderware InTouch Edge/IWS versions 8.1 SP1 or lower. Starting from InTouch Edge/IWS version 8.1S P2, the new drivers should be used.

3.    Installation Requirements

MS SQL Native Client 11 must be installed on the PC where DR resides.  If not installed, the install for SQL Native Client 11 is included in the \ODS\Dream Report\Utilities\ folder.  Please refer to the tech note SQL Server Requirements for Dream Report – SQL Native Client for more information.

4.    InTouch Edge/IWS project settings

•   InTouch Edge/IWS project must be running.

• Security is either disabled, or, if enabled, Remote Security System and Remote Debugging Tools option must also be enabled.  In InTouch Edge/IWS:

Open

Open

• For DR version 4.X Unencrypted port 1234 is to be used and enabled for communications to the real-time data (if being used).

• For the Alarm History and Events, as well as for the Trend logs, Database option must be selected.
  Note: Dream Report does not support the proprietary log files in InTouch Edge/IWS.

• For the default database, OLE-DB provider must be used to connect to SQL Server.

5.    Dream Report node Configuration

The latest InTouch Edge/IWS communications toolkits and latest Dream Report drivers need to be used for DR connectivity to InTouch Edge/IWS.  Before the next steps, stop your DR project from the Runtime Management Console and close Dream Report Studio (if open).

• InTouch Edge/IWS Toolkits - To apply the latest InTouch Edge/IWS toolkits, copy the following files from the \Bin folder of the InTouch Edge/IWS installation folder to the DR \System folder (by default C:\ODS\Dream Report\System), replacing the original files:

Copy all files from the folder that corresponds to your version of InTouch Edge/IWS to the DR \System folder (by default C:\ODS\Dream Report\System), replacing the original ones. The following files need to be copied:

• Dream Report Drivers - Note that the steps which are required to apply the latest Dream Report drivers are DR-version specific.  Follow the section below that corresponds with the version of Dream Report you are using.

DR 5.0:

Download and apply modified DR drivers.  The drivers can be downloaded from:

 https://www.dropbox.com/s/ozsmeysh934ab8j/Drv_InduSoft_DR5.0.rar?dl=0

 DR 4.83 SP2:

Download and apply modified DR drivers.  The drivers can be downloaded from:

https://www.dropbox.com/s/j4wmzj3frh5iehm/4.83.rar?dl=0

 DR 4.83 and 4.83 SP1

Upgrade your Dream Report installation to version 4.83 SP2 or higher, and perform the steps for the corresponding version. Dream Report 4.83 SP2 can be downloaded from:

https://www.dropbox.com/s/frp002cz6bgou6f/DreamReport 4.83 SP2.exe?dl=0

After updating the toolkits and drivers, start Dream Report Studio, and in the Communication Configuration Wizard, configure the drivers you need in your reporting project. Please review the following video on Using Dream Report with AVEVA Wonderware InTouch Edge and InduSoft - https://dreamreport.atlassian.net/wiki/x/BYBZE . You can also find more information on setting up the respective drivers in the Dream Report Help/User Guide under the "Communication Drivers" section.

6.    Remote Connection

To establish remote connection to an InTouch Edge/IWS project, the following actions are required:

• Turn off Firewall on both Dream Report and InTouch Edge/IWC PCs.

• On both PCs in the Network & Sharing Center, click on Change advanced sharing settings (on the left side of the window) to open the Advanced sharing settings. Check that the parameters are set as shown below:

• In Windows Services, the following services have to be running and their Startup Type set to Automatic on both machines: