Please login to download a sample. If you do not have an account, please register for your FREE AVEVA Digital Exchange account.

DataHub OPC Logger

Logs OPC server data to any table of any database. Enables you to query data from any database table and write it to any OPC server or client
Documents
To download the documents, please login to your account. If you do not have an account, please register for your FREE AVEVA Digital Exchange account.
Any Database, Any Table
  • Write data from OPC servers into any ODBC compliant database, such as Microsoft SQL Server, MySQL, PostgreSQL, DB2, and more. 
  • Use existing tables, or create new ones fully customized to meet your needs. 
  • Query any database and send data back to OPC for production schedules, recipes, process setpoints, and more.
Any Database, Any Table
Use Cases
Use Cases
  • Connect to any SQL database running on the same computer as the Datahub, and log your OPC data to any new or existing table
  • Log your OPC data to any database that is visible on the network.  The DataHub's built-in Store and Forward mechanism stores the data in memory whenever the database is unavailable and forwards it in time-sequential order when the connection is restored
  • Query your database and send the results back to your OPC server.  This is useful for supervisory control, changing set points, sending recipes, and more
Optional Add-On Features
  • Tunnel/Mirror – securely network OPC data without DCOM.
  • Data Bridging – connect two or more OPC servers to share data.
  • OPC A&E – connect to OPC A&E servers and clients.
  • Modbus – connect to Modbus TCP slave devices.
  • Email/SMS - notification sent based on data changes.
  • DDE/Excel Support - live data in Excel or other DDE programs.
  • Redundancy - hot standby switching of redundant data streams.
  • Camera - stream live video or images of your system.
  • API - connect custom programs.
Optional Features
How-To Video - Write Data to a Database
See how to log OPC data to an SQL database.
How-To Video - Read from a Database
See how to query an SQL database and write the data to an OPC server.
Specifications
Type
Software
Optimised Scenario
Write and query any ODBC database with OPC UA or OPC DA (Classic) data using fully customizable trigger events and conditions.
Available on
PC
Security Compliance
None
Languages
English
Spanish
Japanese
Portuguese
Chinese Traditional
Russian
System Requirements
Windows 10
Windows Server 2012
Windows Server 2016
Windows 7
Windows Server 2003
Windows Server 2008
Windows 8
Windows 8.1
Windows XP
Top