Data Historian

High-speed, fault-tolerant logging to databases such as MS SQL Server, Oracle, mySQL, SQL Azure, MongoDB, and Access.
Log IIoT data to multiple destinations at once with Store and Forward functionality to local and remote databases in an open format.

Platform Components

Universal Data Connector

The core of the OAS Platform, enabling data connectivity, server-to-server networking, and more

Data Historian

Log data in open format to MS SQL Server, Oracle, mySQL, Access, SQL Azure and CSV files.

Alarm Logging & Notification

Log events to open databases, and send notifications via SMS, email, and voicemail

Device & Data Connectors

Read and write data to Allen Bradley, Siemens, and Modbus devices, OPC and OPC UA, open databases, and Excel

IoT Connectors

Connect to cloud-base IoT gateways such as AWS, Azure IoT, and MQTT Brokers

Developer Tools & APIs

Develop custom Visualizations, User Interfaces, and Automation apps for Windows, web, native iOS and Android, integrate with .NET and REST APIs

Networking Features

Provides the most robust, scalable, and reliable distributed networking platform for IIoT solutions

Product Overview

The OAS Data Historian software allows you to log data to SQL Server, Oracle, Access, MySQL, Azure SQL and CSV files based on event, continuously, time of day, or on data change in both wide and narrow table formats.

The data source can be local or remote without exposing your database. With OAS store and forward feature built in you will never lose records on an network failure. OAS implements edge computing with its Distributed Network Architecture to process and retain data at the source for up to 1 million data points per OAS Data Engine.

Reliability

Never lose data on network or database engine failure. The OAS Data Historian buffers data in real time. If communications is lost to the destination database, or if the destination is unavailable for any reason, no data is lost. As soon as communications are reestablished, all data is transferred at high speed.

Supported Data Destinations

Log data to one or more locations simultaneously, each with configurable parameters so data is targeted for each destination data store.

  • MS SQL Server
  • Oracle
  • MS Access
  • mySQL
  • SQL Azure
  • MongoDB
  • CSV Files

Additional Features

  • Log data in an open format
    Once data is logged, you are free to access it with your own or 3rd party tools for reporting or analytics
  • Log data to stored procedures
    Pass logged data into stored procedures for in-database processing
  • Log to over 10,000 separate tables per server
  • Up to 100 nanosecond resolution
  • Log up to 1 million records per call to local or remote SQL Server
  • Flexible data logging configuration
    Log data continuously, based on event, specific time of day, or based on data change
  • Log data in wide or narrow table formats
  • One Click Database
    Set up data logging for all of your data in less than 5 minutes

Data Visualization and Reporting

Data logged using the Data Historian can be visualized in HMIs and other applications, and it can be the source of customized reports using the following Platform components

Trend .NET 

Visualize real time and historical data in WPF and WinForm applications. Build customizable, interactive data explorers using Visual Studio, and any .NET language such as C# and VB.NET

Web Trend

Visualize real time and historical data in web and mobile applications. Deliver interactive web-based data interfaces with HTML, CSS, and Javascript in any web application environment

Reports

Automate the generation of reports and deliver them in multiple at custom intervals (e.g. hourly, daily, weekly, or monthly). Deliver reports as Word or Excel documents, PDFs, and HTML files or even sent directly to a networked printer

Download and start a free, unlimited trial, or schedule a live, interactive demo