IIoT Data Historian

High-speed, fault-tolerant logging to databases such as MS SQL Server, Oracle, mySQL, SQL Azure, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, InfluxDB, Amazon Aurora, Amazon RDS, Amazon Redshift, Google Firebase, and MS Access. Log IIoT data to multiple destinations at once with Store and Forward functionality to local and remote databases in an open format.

Product Overview

The OAS Data Historian software allows you to log data to SQL Server, Oracle, MS Access, MySQL, Azure SQL, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, InfluxDB, Amazon Aurora, Amazon RDS, Amazon Redshift, Google Firebase, and CSV files.  Supporting both time series data and event based data recording in an open format for easy retrieval.

Log data to database engines

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, PostgreSQL, InfluxDB, MongoDB, SQLite, MariaDB, Access, SQL Azure, Amazon Aurora, Amazon RDS, Amazon Redshift, Google Firebase, 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, Universal Drivers, OPC, OPC UA, databases, Excel, and read MTConnect.

IoT Connectors

Connect to cloud-base IoT gateways such as AWS, Azure IoT Hub, Azure Event Hubs, Kafka, MQTT, and Sparkplug B

Visualization Tools

Build custom Visualizations, User Interfaces, HMIs and Dashboards for Windows, web, as well as native iOS and Android devices

SDKs & APIs

Develop custom automation apps for Windows, web, and mobile devices. Integrate with .NET and REST APIs. Build custom integrated device drivers.

Networking Features

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

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 Databases

Log data to one or more locations simultaneously, each with configurable parameters so data is targeted for each destination data store. Data can be logged to a wide variety of Database Engines as well as CSV files.

  • MS SQL Server
  • Oracle
  • mySQL
  • SQL Azure
  • MongoDB
  • MariaDB
  • PostgreSQL
  • Cassandra
  • SQLite
  • InfluxDB
  • Amazon Aurora
  • Amazon RDS
  • Amazon Redshift
  • Google Firebase
  • MS Access (Windows only)
  • CSV Files

Supported Data Sources

OAS supports a large library of Industry 4.0 data sources including Allen Bradley and Siemens PLCs, Modbus and MTConnect devices, OPC UA and DA Servers and Clients, Databases, applications, and more.

Automated Data Source Setup

Setup data sources manually, automatically, programmatically, or using CSV file import.

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
    Open Database Format
  • Log data to stored procedures
    Pass logged data into stored procedures for in-database processing
  • High Scalability
    Log to more than 10,000 separate tables per server
  • Up to 100 nanosecond resolution
    Log data from PLCs and controllers with resolution up to 1 ms limited only by the controller clock cycle
    High Speed Data from PLC
    Even faster up to 100 nanoseconds data from your own source
    Log High Speed Data from .NET Application
  • Log up to 2 million values per second to local or remote SQL Server
    OAS implements bulk insert routines eliminating the possibility for a data blockade
    Performance Benchmarks
  • Flexible data logging configuration
    Log data continuously, based on event, specific time of day, or based on data change
    Getting Started – Data Historian
  • Log data in wide or narrow table formats
    Map one or more tags per column with wide format or log millions tags into one table with narrow format
  • Store and Forward
    No data loss on network failure or database engine failure
    Store and Forward demonstration video
  • Automated Setup
    Set up data logging for all of your data in less than 5 minutes
    One Click Database
  • Programmatic Setup
    Set up data logging using the .NET or REST API
    .NET Configuration
    REST API

Data Visualization and Reporting

Open data can be accessed directly in user interface and other applications.
The OAS platform has the following additional components that can consume and visualize any open historical data.

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

Networking

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.

Log data over the Internet
Log data over the Internet

Learn more about Edge Computing with OAS Distributed Network Architecture

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

Getting Started with Data Historian

Related Videos

OAS Data Historian

Data Logging
Data logging for IIoT data to SQL Server, Oracle, Access, mySQL, SQL Azure, PostgreSQL, Cassandra, MongoDB, and CSV files.
Data Historian Features
10 Things Your Data Historian Should Do and how to implement OAS Data Logging automated setup.
Setup Data Logging
How to setup Data Logging Groups for Continous, Event, Data Change, and Snapshot recording. Refer to One Click Database above to automate the setup.
Database Tags
Define a database table or view as a data source of OAS Tags for read and write access to SQL Server, Oracle, mySQL, MariaDB, SQLite, PostegreSQL, and Cassandra.
Data Accuracy
See how OAS transfers all values over a network with 100 nanoseconds resolution and log with store and forward to MS SQL Server.
Log Buffered PLC Data
Log high speed buffered data from a controller at 1 millisecond per sample.
Update Records
How to setup Data Logging to update existing records based on dynamic query Tag.
High Speed Data Logging
How to log data with 100 nanosecond resolution for up to 1,000,000 records per second to SQL Server from a .NET application.
Data Buffering
How to setup data logging so there is no data loss on a network or database engine failure.
One Click Database
Automatically setup data logging to SQL Server of all data from Kepware OPC Server in one step.
High Speed ControlLogix
Data Logging using AB Driver to log data at a high speed rate.

OAS Introduction

OAS Introduction
Introduction to Open Automation Software. IIoT / SCADA / HMI software for .NET, web, and Big Data.
IIoT Software
Overview of IIoT software products by Open Automation Software.
Networking
OAS Distributed Network Architecture with decentralized edge computing for the most reliable and effective data hosting.