IIoT Database Connector

Reliable High-Speed Data Transfer from Databases to OAS IIoT Data Engine.

Product Overview

The OAS Database Connector product provides data transfer from databases. The data target can be from local or remote OAS Data Engine. The execution can be continuous up to 1 second rate, event driven from a Tag Parameter value, or at a specific time of day.

The database providers can be SQL Server, Access, Oracle, mySQL, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, SQL Azure, Amazon Aurora, Amazon RDS or Google Firebase. OAS Database Connector supports static or dynamic queries from other data sources such as device or operator input from your user interface.

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


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

Core Features of OAS Recipe

  • Send values from SQL Server, Oracle, Access, SQL Azure, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, MySQL, Amazon Aurora, Amazon RDS, and Google Firebase 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, Web interfaces, cloud servers like Azure IoT, and AWS IoT Gateway, and MQTT brokers.
  • Execute data transfer continuously, on event or specified time of day.
  • Improve database security by isolating the database from the destination application or device.


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