Open Automation Software
Moving Data From Anywhere to Anywhere

Data Historian
Log Data in an Open Format to SQL Server,
Oracle, Access, mySQL, and CSV Files


Everything you need to build world-class SCADA, HMI, .NET, and Web Applications quickly. Without touching a line of code!

OAS Data Historian – Product Overview

data historian iconThe 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. Allows for moving data to stored procedures. Includes nanosecond resolution and data buffering for accurate, secure and reliable data logging for up to 1 million data points per service.

Combine the OAS Data Historian software with the Trend and Reporting products for complete Data Historian at a fraction of the cost of other historian products.




  • Log data in an open format

  • Log data to SQL Server, Oracle, Access, mySQL, SQL Azure, and CSV files

  • Log data to stored procedures

  • Log to over 10,000 separate tables per server

  • Never lose data on a network or database engine failure

  • 100 nanosecond resolution

  • Log up to 1 million records per call to local or remote SQL Server

  • Log data continuously, based on event, specific time of day, or based on data change

  • Log data in wide or narrow table format

  • Use One Click Database to setup data logging for all of your data in less than 5 minutes

Edge Computing with OAS Distributed Network Architecture


  • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
  • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
  • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
  • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
  • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
  • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
  • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
  • Excel – Use the Excel Connector to use Microsoft Excel as data source
  • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, mySQL and  SQL Azure databases
  • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
  • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
  • OPC Servers – Connect to OPC DA 2.x, 3.0, OPC UA, OPC A&E, and OPC UA Alarm and Conditions. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Servers
  • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
  • REST – With the REST API Connector you can connect to data sources via the REST API
  • iOS and Android Apps – Use PCL for Android and iOS to connect to data on iOS and Android devices.
  • MS SQL Server
  • Oracle
  • MS Access
  • mySQL
  • SQL Azure
  • CSV Files

Cost-effective Licensing

OAS licensing is based on three simple factors:

  1. The number of tags you need to connect to
  2. The number of OAS products needed to connect your data sources
  3. Whether you need a networked or stand-alone system

You can deploy unlimited client applications for each Distributed Network Architecture enabled server.

starts at


Data Historian Videos

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.

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.

Data Historian Software Features

10 Things Your Data Historian Should Do
How to implement OAS Data Logging automated features for local and networked data logging.

One Click Database

Automatically setup data logging to SQL Server of all data from Kepware OPC Server in one step.

OAS Systems Introduction

The Possibilities are Endless!

Connect Data Sources

Make virtually limitless connections from a huge range of data sources with OAS Universal Data Connector feature.

Universal Data Connector

Move Data

Move data quickly and securely and in an open format using our innovative Distributed Network Architecture.

Distributed Network Architecture

Create Applications

Create powerful .NET, web and cross-platform mobile HMI applications. Access OAS data from anywhere and from any device.

Application Development