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 |