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!
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 (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
| Vendor | Data Source Name | Driver Type | Comments |
|---|---|---|---|
| Afcon | PCIM SCADA/PULSE | Real-Time values | Native, proprietary (OEM only) |
| Afcon | PCIM SCADA/PULSE | Real-Time alarms | Native, proprietary (OEM only) |
| Afcon | PCIM SCADA/PULSE | Historical values | Native, proprietary (OEM only) |
| Afcon | PCIM SCADA/PULSE | Historical alarms | Native, proprietary (OEM only) |
| ARC Informatique | PcVue OPC | Real-Time values | Custom, OPC based |
| ARC Informatique | PcVue HDS server | Historical values | Direct |
| ARC Informatique | PcVue HDS server | Historical alarms | Direct |
| ARC Informatique | PcVue SCADA | Real-Time values | Native, web services |
| ARC Informatique | PcVue SCADA | Real-Time alarms | Native, web services |
| ARC Informatique | PcVue SCADA | Historical values | Native, web services |
| AspenTech | Aspen.IP21 | Historical values | Direct, ODBC based |
| AVEVA | Application Server | Real-Time values | Native, MX (with Galaxy) |
| AVEVA | Alarm DB Logger | Historical alarms | A2ALMDB, Direct |
| AVEVA EDGE (InduSoft HMI) | AVEVA EDGE (InduSoft HMI) | Historical values | Direct |
| AVEVA EDGE (InduSoft HMI) | AVEVA EDGE (InduSoft HMI) | Historical alarms | Direct |
| AVEVA EDGE (InduSoft HMI) | AVEVA EDGE (InduSoft HMI) | Real-Time values | Native, proprietary |
| AVEVA | InTouch | Real-Time values | Native, SuitLink |
| AVEVA | InTouch | Historical alarms | WWALMDB, Direct |
| AVEVA | InTouch Machine Edition | Historical values | Direct |
| AVEVA | InTouch Machine Edition | Historical alarms | Direct |
| AVEVA | InTouch Machine Edition | Real-Time values | Native, proprietary |
| AVEVA | Mobile Operator | Historical values | Direct |
| AVEVA | InSight (Historian Online) | Historical values | OData |
| AVEVA | InSight (Historian Online) | Historical alarms | OData |
| AVEVA | Historian | Historical alarms | ODBC based |
| AVEVA | Historian | Historical alarms | Native SDK, OData |
| AVEVA | Historian | Historical values | Direct |
| AVEVA | PI WEB API | Historical values | Web services |
| AVEVA | PI | Historical values | Direct, ODBC based |
| AVEVA | PI Asset Framework | Real-Time values | Native, proprietary |
| AVEVA | PI Asset Framework | Historical values | Native, proprietary |
| AVEVA | PI Asset Framework | Event frames | Native, proprietary |
| AVEVA | PI Asset Framework | Historical alarms | Native, proprietary |
| AVEVA | PI Asset Framework | Historical values | Native, proprietary (SDK 2018) |
| AVEVA | PI Asset Framework | Real-Time values | Native, proprietary (SDK 2018) |
| AVEVA | Plant SCADA | Historical values | Direct, ODBC based |
| AVEVA | Plant SCADA | Historical alarms | Direct, ODBC based |
| AVEVA | Plant SCADA | Historical values | Legacy historical values |
| AVEVA | Plant SCADA | Real-Time values | Native, proprietary |
| AVEVA | Plant SCADA | Real-Time alarms | Native, proprietary |
| AVEVA | Plant SCADA | Historical values | Native, proprietary |
| AVEVA | Plant SCADA | Historical alarms | Native, proprietary |
| AVEVA | Enterprise SCADA | Historical values | Direct, ODBC based |
| AVEVA | Enterprise SCADA | Historical alarms | Direct, ODBC based |
| Control Maestro | Wizcon/Control Maestro | Real-Time values | Native, proprietary |
| Control Maestro | Wizcon/Control Maestro | Real-Time alarms | Native, proprietary |
| Control Maestro | Wizcon/Control Maestro | Historical values | Native, proprietary |
| Control Maestro | Wizcon/Control Maestro | Historical alarms | Native, proprietary |
| Emerson | DeltaV SCADA | Real-Time values | Custom, OPC based |
| Emerson | DeltaV SCADA | Real-Time alarms | Custom, OPC based |
| 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) |
| Watlow (Eurotherm) | Review database access | Historical values | Direct |
| Watlow (Eurotherm) | Review database access | Historical alarms | Direct |
| Watlow (Eurotherm) | Review Batch Monitor | Real-Time values | Direct |
| Watlow (Eurotherm) | UHH SQL database access | Historical values | Direct |
| Watlow (Eurotherm) | UHH SQL database access | Historical alarms | Direct |
| Watlow (Eurotherm) | UHH SQL DB Batch Monitor | Real-Time values | Direct, ODBC based |
| Watlow (Eurotherm) | UHH files access | Historical values | Native, SDK |
| Watlow (Eurotherm) | UHH files access | Historical alarms | Native, SDK |
| Watlow (Eurotherm) | UHH files Batch Monitor | Real-Time values | Native, SDK |
| Watlow (Eurotherm) | Eurotherm controllers | Real-Time values | Modbus based |
| Watlow (Eurotherm) | Data Review | Historical alarms | Direct, ODBC based |
| Watlow (Eurotherm) | Data Review | Historical values | Direct, ODBC based |
| Watlow (Eurotherm) | Data Review batch monitor | Real-Time values | Direct, ODBC based |
| Proficy Software | Cimplicity | Historical values | Direct, ODBC based |
| Proficy Software | Cimplicity | Historical messages | Direct, ODBC based |
| Proficy Software | Proficy iHistorian | Historical values | Direct, OLEDB based |
| Proficy Software | Proficy iHistorian | Historical alarms and events | Direct, OLEDB based |
| Proficy Software | Proficy iHistorian | Hybrid Alarms and Historical Values | Direct, OLEDB based + SQL |
| Proficy Software | Smart Signal | Historical values | Native |
| Proficy Software | iFix | Real-Time values | Native, proprietary |
| Proficy Software | iFix | Real-Time alarms | Native, proprietary |
| Proficy Software | iFix | Historical values | Native, proprietary |
| Proficy Software | iFix6+ | Real-Time values | Native, proprietary |
| Proficy Software | iFix6+ | Real-Time alarms | Native, proprietary |
| Proficy Software | iFix6+ | Historical values | Native, proprietary |
| Proficy Software | GE iHistorian | Historical alarms | Driect, OLEDB-SQL Hybrid Driver |
| Proficy Software | Proficy Historian RestAPI | Historical values | RestAPI, proprietary |
| Geo SCADA | Geo SCADA | Real-Time values | Native, proprietary |
| Geo SCADA | Geo SCADA | Historical values | Native, proprietary |
| Geo SCADA | Geo SCADA | Historical alarms | Native, proprietary |
| InfluxData | InfluxDB | Historical values | Direct |
| Internal | System | Real-Time values | Internal |
| Internal | System | Historical values | Internal |
| Internal | LUA Script | Event frames | Internal |
| Internal | LUA Script | Historical values | Internal, LUA based |
| Internal | WEB Manual Driver | Historical values | Internal, manual data entry |
| Loytec | LWEB 801 database server | Historical values | Direct |
| Loytec | LWEB 801/900 | Historical values | Direct |
| Mitsubishi | CC-LINK (using SLMP) | Real-Time values | Ethernet |
| Mitsubishi | Mitsubishi HVAC | Real-Time values | serial (RS232) |
| Open protocol | Excel files | Real-Time values | Access to Excel files values |
| Open protocol | Advanced ODBC | Historical values | Advanced ODBC driver |
| Open protocol | Advanced ODBC | Historical Alarms | Advanced ODBC driver |
| Open protocol | OLEDB | Historical values | General OLEDB driver |
| Open protocol | OLEDB | Historical Alarms | General OLEDB driver |
| Open protocol | CSV files | Historical Alarms | Import from csv files |
| Open protocol | CSV files | Real-Time values | Import from csv files |
| Open protocol | CSV files | Real-Time alarms | Import from csv files |
| Open protocol | MQTT | Real-Time values | IoT online driver |
| Open protocol | BACnet | Real-Time values | Native |
| Open protocol | BACnet | Real-Time alarms | Native |
| Open protocol | BACnet | Historical values | Native |
| Open protocol | SNMP | Real-Time values | Native, SNMP ver.1 and 2 |
| Open protocol | ODBC | Historical values | ODBC driver |
| Open protocol | ODBC | Historical alarms | ODBC driver |
| Open protocol | OPC | Real-Time alarms | OPC AE |
| Open protocol | OPC | Real-Time values | OPC DA |
| Open protocol | OPC | Historical values | OPC HDA |
| Open protocol | OPC | Historical values | OPC UA |
| Open protocol | OPC | Real-Time values | OPC UA |
| Open protocol | FCI | Real-Time values | Serial |
| Open protocol | Modbus | Real-Time values | TCP/IP, Serial, ASCII, JBUS, RS232 |
| Open protocol | ICE | Real-Time values | |
| Open protocol | OPC UA Alarms | Historical alarms | OPC UA |
| Open protocol | Ethernet/IP | Real-Time values | Ethernet/IP communication protocol |
| Remote | Remote | Real-Time values | Internal, remote connector |
| Remote | Remote | Historical values | Internal, remote connector |
| Rockwell Automation | RsView | Historical values | *.dbf archives, direct |
| Rockwell Automation | FactoryTalk View database | Historical values | Direct, Database |
| Rockwell Automation | FactoryTalk View database | Historical alarms | Direct, Database |
| Rockwell Automation | FactoryTalk | Historical values | Native, Web Services |
| Rockwell Automation | FactoryTalk | Historical alarms | Native, Web Services |
| Rockwell Automation | FactoryTalk | Real-Time values | Native, Web Services |
| Rockwell Automation | Rockwell PLC | Real-Time values | Native, proprietary |
| Rockwell Automation | FT InfluxDB Historian | Historical values | InfluxDB (DatalogPro) |
| Schneider | ION | Historical values | Direct |
| Schneider | StruxureWare | Historical values | Native, Web services |
| Siemens | Desigo CC | Historical values | Web services |
| Siemens | Desigo database | Historical values | Direct |
| Siemens | WinCC SCADA | Real-Time values | Native, proprietary |
| Siemens | WinCC SCADA | Real-Time alarms | Native, proprietary |
| Siemens | WinCC SCADA | Historical values | Native, proprietary |
| Siemens | WinCC SCADA | Historical alarms | Native, proprietary |
| Siemens | PLC S7 | Real-Time values | Native, SDK |
| Siemens | PLC S7 -200/300/400 | Real-Time values | Native, TCP/IP |
| StreamX for ACC | ACC database | Historical values | Direct, ODBC based |
| Techno Trade | TVIEW HMI | Historical values | Native SDK |
| Techno Trade | TVIEW HMI | Historical alarms | Native SDK |
| Trihedral | VTScada | Real-Time values | Native, proprietary |
| Trihedral | VTScada | Historical values | Native, proprietary |
| Trihedral | VTScada | Historical alarms | 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 |