Open Automation Software
Moving Data From Anywhere to Anywhere

IoT Database Connector
Reliable High-Speed Data Transfer from Databases to IoT


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


Product Overview

The OAS Recipe product provides data transfer from databases. The data target can be from local or remote OAS Services of Tag Parameter Values. The execution can be continuous up to 1 second speed, event driven from a Tag Parameter value, or at a specific time of day.

The database providers can be SQL Server, SQL Server Desktop (MSDE), Access, Oracle, mySQL, or ODBC. OAS Recipe supports static or dynamic queries from other data sources such as device or operator input from your user interface.


  • Send values from SQL Server, Oracle, Access and MySQL to PLCs and DCS systems with full confirmation on successful data transfer.

  • The same data can also be shared with OPC Servers, OPC clients, .NET applications, and HTML Web applications.

  • Execute data transfer continuously, on event or specified time of day.

  • Improve database security by isolating the database from the destination application or device.

Edge Computing with OAS Distributed Network Architecture


  • MS SQL Server
  • Oracle
  • MS Access
  • mySQL
  • SQL Azure
  • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
  • .NET WPF HMI Applications – Use WPF HMI .NET to create HMI visualizations for WPF Smart Clients
  • .NET WinForm HMI Applications – Use WinForm HMI .NET to create HMI visualizations for WinForm Smart Clients
  • .NET Trending Application – Use Trend .NET for real-time trending for WinForm and WPF applications and historical trending when combined with OAS Data Historian.
  • .NET Alarming Applications – Use Alarm .NET for real-time alarming for WinForm and WPF applications and historical alarming with alarm notification via email, SMS text, and voicemail.
  • 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
  • Web-based HMI Applications – Use Web HMI to create cross-platform HMI apps
  • Web-based Trending Aplicatons – Use Web Trend to create cross-platform trending apps
  • Web-based Alarming Applications – Use Web Alarm to create cross-platform alarm apps
  • iOS and Android HMI Apps – Use PCL for Android and iOS to create iOS and Android applications for live data.
  • Data Historian – With OAS Data HIstorian you can log data to SQL Server, Oracle, Access, mySQL, SQL Azure and CSV files.
  • Reports – With OAS Reports you can create reports from OAS data logging products or other databases. Generate reports as Word, Excel, PDF, HTML or Email.
  • 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.
  • 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, and mySQL 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 UA and Classic OPC DA 2.0 and 3.0 OPC Servers. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Server or OAS IoT Driver.
  • Microsoft Azure – Use the SQL Azure Data Logging and SQL Azure Alarm Logging products to connect to Microsoft Azure SQL Databases
  • Microsoft Azure IoT Data Hub – Transfer any Data Source to Azure IoT Data Hub using the OPC Tunnel Connector

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

Recipe - Database Connector

OAS Introduction

OAS Introduction

Introduction to Open Automation Software. IoT / 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