Tech Notes

Tech Note 52: How to configure and query Wonderware Historian 9.0 as a linked server to another Microsoft SQL Server

Sometimes clients who request data from the Wonderware Historian (previously known as IndustrialSQL Server or simply InSQL) may not be directly connected to the Historian (for instance, if the Wonderware Historian is behind a firewall), or there may be a need to present data from multiple Wonderware Historians on the network within a single report.

Therefore it may be necessary or beneficial to set up a central reporting server and have that server retrieve data from one or more Wonderware Historians. In such scenario data clients would connect only to the central reporting server, which in turn would query the...

Tech Note 46: How to modify existing Microsoft SQL Server 2005 installation to comply with Wonderware Information Server 3.0

This Tech Note details the procedure to modify the existing Microsoft SQL Server 2005 installation (described in Wonderware PacWest Tech Note 8: Recommended Microsoft SQL Server 2005 installation procedure for Wonderware products) to comply with requirements of Wonderware Information Server 3.0. Microsoft Reporting Services is a major component required by Wonderware Information Server that is not included into the generic Microsoft SQL Server 2005 installation procedure described in the Wonderware PacWest Tech Note 8.

For brand new installation of Microsoft SQL Server 2005 for Wonderware Information Server 3.0 refer to Wonderware PacWest Tech Note 28: Microsoft SQL Server 2005 installation...

Tech Note 31: How to backup IndustrialSQL Server Historian databases in Microsoft SQL Server 2005

This Tech Note details recommended backup procedure for Wonderware IndustrialSQL Historian related SQL databases in the case IndustrialSQL Server/Historian (InSQL) is installed in conjunction with Microsoft SQL Server 2005. It's the third part of a series of 3 tech notes that will detail recommended backup procedure for IndustrialSQL Server databases and history blocks in Microsoft SQL Server 2000 and 2005 environments.

...

Tech Note 23: How to backup IndustrialSQL Server Historian databases in Microsoft SQL Server 2000

This Tech Note details recommended backup procedure for Wonderware IndustrialSQL/Historian (InSQL) related SQL databases in the case IndustrialSQL Server Historian is installed in conjuction with Microsoft SQL Server 2000. It's the first part of a series of 3 tech notes that will detail recommended backup procedure for IndustrialSQL Server databases and history blocks in Microsoft SQL Server 2000 and 2005 environments.

...