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.
The core of the OAS Platform, enabling data connectivity, server-to-server networking, and more
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
Log events to open databases, and send notifications via SMS, email, and voicemail
Read and write data to Allen Bradley, Siemens, and Modbus devices, Universal Drivers, OPC, OPC UA, databases, Excel, and read MTConnect.
Connect to cloud-base IoT gateways such as AWS, Azure IoT, Kafka, and MQTT
Build custom Visualizations, User Interfaces, HMIs and Dashboards for Windows, web, as well as native iOS and Android devices
Develop custom automation apps for Windows, web, and mobile devices. Integrate with .NET and REST APIs. Build custom integrated device drivers.
Provides the most robust, scalable, and reliable distributed networking platform for IIoT solutions
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.
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
- SQL Azure
- 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.
Modbus TCP, Modbus RTU, and Modbus ASCII for Master and Slave
- Allen Bradley
ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5
S7-200, S7-300, S7-400, S7-1200, and S7-1500
- OPC UA Servers
- OPC DA Servers
- OPC UA Clients
- OPC DA Clients
- MQTT Connector
- Azure IoT
- AWS IoT Gateway
SQL Server, Oracle, Access, mySQL, MariaDB, PostgreSQL, SQLite, Casandra, MongoDB, and InfluxDB
- .NET Applications
- REST API
- Universal Driver Interface SDK
Automated Data Source Setup
Setup data sources manually, automatically, programmatically, or using CSV file import.
- 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
- 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
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.
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
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
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.
Getting Started with Data Historian
- Getting Started – Download, Setup, and Support
- Getting Started Tags
- Getting Started Data Logging
- One Click Database – Automatically setup Data Logging
- High Speed Logging from a PLC
- High Speed Logging from .NET with 100 nanosecond resolution
- .NET Programmatic Data Logging Setup
- Default Service Options
- Activate License