Dream Report Drivers for Industrial and Business Data

The Connectivity Value Proposition – Visibility to ALL your Data

Imagine telling your team that you’ve found an industrial solution that can connect to data from anywhere in your plant, and from any system.  Moreover, it can generate any statistics for reports and dashboards, even combining the data from all your sources.  It will do all that automatically, delivering the results you desire to those that need it and it can do that interactively, through quick and easy to develop dashboards of your own design.  That’s the benefit of Dream Report!

All Data Types – Real-time, History, Analog, Discrete, Alarm and Event

But it gets even more amazing.  There are several forms of data that unlike business tools, Dream Report offers purpose built handling for.  These include Real-time, Alarm and Historical data structures.  A Real-time Data Source provides access to instantaneous data or data that is a response to a current value query.  This is important for real-time dashboards and statistics, and for triggering analytics based on process parameters.  An example can be the automatic generation of an End of Batch Report or the generation of a Run Report for a piece of equipment.  Alarm History data typically comes from connection to an Alarm or Event Log, that can be queried for a range of information.  These logs offer many fields for querying and it is common to generate reports of the most common alarms, alarms sorted by priority, equipment, site or by operator.  There are even best practices for alarm reporting (ISA 18.2), that define how alarms should be managed over time for continuous improvement.  Finally, Historical Data is typically provided by a database of some sort and can be queried for arrays of data.  In many cases, History data from specialized Historian products can be pre-filtered or pre-analyzed by the Historian.  Historian data is also often stored with compression to improve performance and reduce archive sizes.  This compression can be a challenge for traditional Business Intelligence products.  Dream Report understands these challenges and will make use of ALL your data sources, in the most powerful ways possible.

Drivers for Accessing Data through Standard and Proprietary Interfaces

Drivers (connectors or interfaces to data sources) also fall into several categories.  There are industry standards for connectivity such as those of the OPC Foundation (OPC DA, OPC AE, OPC HDA, OPC UA), and MODBUS – a simple protocol that is quite pervasive in industry.  There are a wide range of proprietary communication protocols, specialized to the various vendors in the automation marketplace.  There are also business standards such as ODBC, OLE-DB, and standard file formats like CSV or Microsoft Excel.  Dream Report offers connectivity to most products in industry through one or more of these interfaces.  There is usually more than one way to offer connectivity to the data sources you’ll want to report on.  All Drivers are included with Dream Report (however OEM versions of Dream Report, available from many different automation vendors, will vary).

Ocean Data Systems has developed a DDK (Driver Development Kit), streamlining the development of new drivers.  The addition of a new Driver is a common occurrence and if you have requirements, please contact us.  Sales@dreamreport.com

Communication Driver List:

DreamReport Communication Drivers – 2020 R2 (view as pdf)

Vendor

Data Source Name Driver Type Comments
ARC Informatique PcVue HDS server Historical alarms Direct
ARC Informatique PcVue HDS server Historical values Direct
ARC Informatique PcVue OPC

Real-Time values

Custom, OPC based
ARC Informatique PcVue SCADA Historical values Native, web services
ARC Informatique PcVue SCADA Real-Time values Native, web services
AspenTech Aspen.IP21 Historical values Direct, ODBC based
AVEVA Alarm DB Logger Historical alarms & events A2ALMDB/WWALMDB, Direct
AVEVA Application Server Real-Time values Native, MX (with Galaxy)
AVEVA Edge HMI Historical alarms & events Direct
AVEVA Edge HMI Historical values Direct
AVEVA Edge HMI Real-Time values Direct
AVEVA Historian Historical alarms & events Native SDK, OData
AVEVA Historian Historical values Direct
AVEVA InSight (Historian Online) Historical alarms OData
AVEVA InSight (Historian Online) Historical values OData
AVEVA IntelaTrac Historical values Direct
AVEVA InTouch Historical alarms & events ALG files, direct
AVEVA InTouch Historical values LGH files, native
AVEVA InTouch Real-Time values Native, SuiteLink
Citect Citect DBF Historical values Legacy historical values
Citect Citect Historian Historical alarms Direct, ODBC based
Citect Citect Historian Historical values Direct, ODBC based
Citect Citect SCADA Historical alarms Native, proprietary
Citect Citect SCADA Historical values Native, proprietary
Citect Citect SCADA Real-Time values Native, proprietary
ControlMaestro Wizcon Historical alarms Native, proprietary
ControlMaestro Wizcon Historical values Native, proprietary
ControlMaestro Wizcon Real-Time values Native, proprietary
Elutions Wizcon/Control Maestro Historical alarms Native, proprietary
Elutions Wizcon/Control Maestro Historical values Native, proprietary
Elutions Wizcon/Control Maestro Real-Time alarms Native, proprietary
Elutions Wizcon/Control Maestro Real-Time values Native, proprietary
Emerson DeltaV SCADA Historical alarms Custom, OPC based
Emerson DeltaV SCADA Historical values Custom, OPC based (New driver), Historical data access
Emerson DeltaV SCADA Historical values Custom, OPC based (old driver for backward compatibility)
Emerson DeltaV SCADA Real-Time alarms Custom, OPC based
Emerson DeltaV SCADA Real-Time values Custom, OPC based
Eurotherm Data Reviewer Batch Monitor Real-Time values Direct
Eurotherm Data Reviewer Historical Messages Historical alarms Direct
Eurotherm Data Reviewer Historical Values Historical values Direct
Eurotherm Eurotherm controllers Real-Time values Modbus based
Eurotherm Review historical alarms/messages Historical alarms Direct
Eurotherm Review historical values Historical values Direct
Eurotherm UHH files access Historical alarms Native, SDK
Eurotherm UHH files access Historical values Native, SDK
Eurotherm UHH files Batch Monitor Real-Time values Native, SDK
Eurotherm UHH SQL database access Historical alarms Direct
Eurotherm UHH SQL database access Historical values Direct
Eurotherm UHH SQL DB Batch Monitor Real-Time values Direct, ODBC based
General Electric Cimplicity Historical messages Direct, ODBC based
General Electric Cimplicity Historical values Direct, ODBC based
General Electric iFix Historical values Native, proprietary
General Electric iFix Real-Time alarms Native, proprietary
General Electric iFix Real-Time values Native, proprietary
General Electric iFix 6+ Historical values Native, proprietary
General Electric iFix 6+ Real-Time alarms Native, proprietary
General Electric iFix 6+ Real-Time values Native, proprietary
General Electric Proficy Historian Historical alarms and events Direct, OLEDB based
General Electric Proficy Historian Historical values Direct, OLEDB based
General Electric Smart Signal Historical values Native
Geo SCADA Geo SCADA Expert Historical alarms & events Native, proprietary
Geo SCADA Geo SCADA Expert Historical values Native, proprietary
Geo SCADA Geo SCADA Expert Real-Time values Native, proprietary
Indusoft InduSoft Web Studio Historical alarms & events Direct
Indusoft InduSoft Web Studio Historical values Direct
Indusoft InduSoft Web Studio Real-Time values Direct
Internal DBatch Historical values Internal, access to DBatch historical values
Internal LUA Script Historical values Internal, LUA based
Internal Remote Historical values Internal, remote connector
Internal Remote Real-Time values Internal, remote connector
Internal Simulation Historical alarms Internal
Internal Simulation Historical values Internal
Internal Simulation Real-Time values Internal
Internal System Historical values Internal
Internal System Real-Time values Internal
Internal Web Manual Driver Historical values Internal, manual data entry
Loytec LWEB 801 database server Historical values Direct
Loytec LWEB 801/900 Historical alarms Direct
Mitsubishi CC-LINK (using SLMP) Real-Time values Ethernet
Mitsubishi M-NET Driver Real-Time values Serial (RS232)
Open protocol Advanced ODBC Historical alarms & events Advanced ODBC driver
Open protocol Advanced ODBC Historical values Advanced ODBC driver
Open protocol CSV files Real-Time alarms Import from csv files
Open protocol CSV files Real-Time values Import from csv files
Open protocol Excel files Real-Time values Access to Excel files values
Open protocol FCI Real-Time values Serial
Open protocol Modbus Real-Time values TCP/IP, Serial, ASCII, JBUS, RS232
Open protocol MQTT Real-Time values IoT online driver
Open protocol ODBC Historical alarms ODBC driver
Open protocol ODBC Historical values ODBC driver
Open protocol OLEDB Historical Alarms General OLEDB driver
Open protocol OLEDB Historical values General OLEDB driver
Open protocol OPC AE Real-Time alarms OPC AE
Open protocol OPC DA Real-Time values OPC DA
Open protocol OPC HDA Historical values OPC HDA
Open protocol OPC UA Historical values OPC UA
Open protocol OPC UA Real-Time values OPC UA
Open protocol SNMP Real-Time values Native, SNMP ver.1 and 2
OSI Soft PI Historical values Direct, ODBC based
OSI Soft PI Asset Framework Historical values Native, proprietary
OSI Soft PI Asset Framework Real-Time values Native, proprietary
Rockwell FactoryTalk Historical alarms Native, Web Services
Rockwell FactoryTalk Historical values Native, Web Services
Rockwell FactoryTalk Real-Time values Native, Web Services
Rockwell FactoryTalk View SE database Historical alarms & events Direct, Database
Rockwell FactoryTalk View SE database Historical values Direct, Database
Rockwell PLC Access Real-Time values Native, Ethernet CompactLogix, ControlLogix, SLC500, PLC5, MicroLogix
Rockwell RSView32 Historical values *.dbf archives, direct
Schneider-Electric ION DB (PM Expert) Historical values Direct
Schneider-Electric StruxureWare Central Historical values Native, Web services
Siemens Desigo database Historical values Direct
Siemens PLC S7 Real-Time values Native, SDK
Siemens PLC S7 -200/300/400 Real-Time values Native, TCP/IP (legacy)
Siemens WinCC SCADA Historical alarms Native, proprietary
Siemens WinCC SCADA Historical values Native, proprietary
Siemens WinCC SCADA Real-Time alarms Native, proprietary
Siemens WinCC SCADA Real-Time values Native, proprietary
StreamX ACC database Historical values Direct, ODBC based
Techno Trade TVIEW HMI Historical alarms Native SDK
Techno Trade TVIEW HMI Historical values Native SDK
Trihedral VTScada Real-Time values Native, proprietary
Trihedral VTScada Historical alarms Native, proprietary
Trihedral VTScada Historical values Native, proprietary
Yokogawa Batch monitor Historical Files Native SDK
Yokogawa Yokogawa files access Historical Files Native SDK
Yokogawa Yokogawa files access Historical Messages Native SDK