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, or SQL Azure. 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, Cassandra, MongoDB, Access, SQL Azure 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, OPC and OPC UA, open databases, and Excel

IoT Connectors

Connect to cloud-base IoT gateways such as AWS, Azure IoT, and MQTT Brokers

Developer Tools & APIs

Develop custom Visualizations, User Interfaces, and Automation apps for Windows, web, native iOS and Android, integrate with .NET and REST APIs

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, 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, 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.

Recipe

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