Software Toolbox Technical Blog

In case you aren't familiar with the Dream Report reporting solution from Ocean Data Systems, Dream Report is a real-time report generator that is quickly and easily configurable via a very easy-to-use interface with a ton of flexibility relating to not only collection and archiving of data and alarms but also for analysis and options for report generation.

In this post, I'm going to go through five of the key features released in 2018 for Dream Report and how they benefit you, either as an existing Dream Report user or as a process industry professional looking at reporting solutions.

With DDE (Dynamic Data Exchange) fast becoming obsolete technology (Microsoft superseded DDE with OLE years ago), OPC DA and, more recently, OPC UA data sources have become the primary go-to for process data integration.  Recently, Microsoft even disabled certain DDE functionality in MS Office applications due to security concerns and malware exploitation targeting the DDE interface.

But the usefulness of MS Excel for data analysis across many industries even today is still undeniable and the primary mechanism for MS Excel to connect to a data source is via DDE.  So what do you do if you're still using MS Excel for process data analysis and reporting via DDE?  What's the alternative?

The following short video blog demonstrates step-by-step how to easily read/write data from process data sources (OPC DA and OPC UA Servers) using MS Excel (without DDE) with the Cogent DataHub.