Open Automation Software
Moving Data From Anywhere to Anywhere

SQL Azure IoT Data Logging
Log Big Data to Microsoft SQL Azure Databases


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

Product Overview

Log alarm or event data from any number of local or remote data sources to SQL Azure.

With our Azure SQL data connection not only can you log data quickly, you can rest assured that the data will be delivered even with slow or faulty network connections.

Our alarm logging products are used by military and fortune 100 corporations to move millions of data points per second globally at a fraction of the cost of far less reliable or secure products. Set up could not be easier.

Core Features of SQL Azure Alarm Logging

  • Fast reliable and secure data connections to Azure SQL
  • Data buffering to ensure data delivery even over poor quality networks
  • Up to 1,000,000 data points / second
  • Several logging types
  • Wide or narrow table format
  • Transfer live data from local or remote data sources
  • Use OAS Distribute Network Architecture for compressed and encrypted transfer



SQL Azure Data Logging

Data Sources:

Data Logging Types:

  • Continuous: Log continuously as fast as 100 nanoseconds.
  • Event Driven: Log one record based on trigger.
  • Data Change: Log a record for each value change.
  • Snapshot: Go back in time to record data prior to an event.
  • Time of Day: Log one record at a specific time each day.

Store and Forward:

No data loss on network failure or database fault.

100 Nanosecond Resolution:

Unique data handling of data from controller buffer to record values as fast as the controller can process values.

Open Format:

Data is logged to databases in an open format to access directly from any third party reporting system.

Scalable Big Data:

  • Log 1 to 1,000,000 data points from each server
  • Log data from up to 10,000 servers to central data server
  • Log to more than 10,000 tables from each server
  • Log all local and remote tags into one common table


Log data over your LAN, WAN, Intranet, or the Internet with 100 nanosecond resolution and no data loss on network failures.

Log data from a remote data source with the free Live Data Cloud feature using a standard Internet connection at both client and server systems.

Automated Setup:

Utilize One Click Database to automatically setup logging of all data from the controller.

Or utilize programmatic setup of Tags and Data Logging with a .NET application.

Edge Computing with OAS Distributed Network Architecture

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.

Stand Alone systems
start at
Networked unlimited user systems
start at


Data Logging Videos

Setup Data Logging

How to setup Data Logging Groups for Continuous, Event, Data Change, and Snapshot recording. Refer to One Click Database above to automate the setup.

One Click Database

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

Data Buffering

How to setup data logging so there is no data loss on a network or database engine failure.

Data Historian Features

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

OAS Introduction

OAS Introduction

Introduction to Open Automation Software. IIoT / SCADA / HMI software for .NET, web, and Big Data.

OAS IoT Software

Overview of IoT software products by Open Automation Software.

IIoT Software with Edge Computing Distributed Network Architecture

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