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, 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
The core of the OAS Platform, enabling data connectivity, server-to-server networking, and more
Log data in open format to MS SQL Server, Oracle, mySQL, PostgreSQL, InfluxDB, MongoDB, SQLite, MariaDB, Access, SQL Azure, and CSV
Log events to open databases, and send notifications via SMS, email, and voicemail
Read and write data to Allen Bradley, Siemens, and Modbus devices, Universal Drivers, OPC, and OPC UA, open databases, and Excel
Connect to cloud-base IoT gateways such as AWS, Azure IoT, and MQTT Brokers
Develop custom Visualizations, User Interfaces, and Automation apps for Windows, web, native iOS and Android, integrate with .NET and REST APIs
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, 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.