IIoT Database Connector
The OAS Database Connector product facilitates data transfer from various databases, including SQL Server, Oracle, MySQL, PostgreSQL, and SQLite, to all OAS data sources. This includes Industry 4.0 data sources such as Modbus devices, Allen Bradley PLCs, Siemens S7 controllers, OPC UA servers, OPC DA servers, MQTT, Sparkplug B, and more.
Read DB Data into OAS Tags
The target can be any local or remote OAS Engine. The execution can be continuous up to 1 second rate, event-driven, or at a specific time of day.
The Database Connector product also supports setting an OAS Tag data source to a database record from a table or view, with an optional dynamic query.
a server-based, highly-scalable, network platform that enables the transport and transformation of your data
Data HistorianAchieve fault-tolerant logging, zero data loss, and multi-destination storage with our high-performance Store and Forward technology.
Visualization ToolsBuild Visualizations, User Interfaces, and server configuration interfaces for .NET, web technologies, native iOS and Android mobile apps
Device & Data ConnectorsThe OAS Platform provides rapid communications and connectivity to a wide variety of PLCs, devices, and databases.
IoT ConnectorsConnect to cloud-base IoT gateways such as AWS, Azure IoT Hub, Azure Event Hubs, Kafka, and more.
Alarm Logging & NotificationCapture events on each data point, log to open formats for historical analysis and archiving, and trigger real time notifications
SDKs & APIsExplore a wide variety of Developer Tools and APIs to allow you to create applications and system integrations to execute in any environment.
Networking FeaturesOpen Automation Software implements edge computing with a Distributed Network Architecture.
Download a fully functional trial of Open Automation SoftwareKey Features & Benefits
Wide DB Support
Read 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 to the final destination.
Integrate Data with Other Sources
Data can also be shared with all OAS data sources, including open standards like Modbus, OPC UA, OPC DA, MQTT, Sparkplug B, and cloud servers like Azure IoT, AWS IoT Core, and Kafka.
Customizable Import Behavior
Execute data transfer continuously, on an event, or specified time of day. Recipe execution and import can be enabled and disabled based on other tags or calculations.
Industry 4.0 Targets
You can send data to various destinations including Modbus, Allen Bradley PLCs, Siemens S7 Controllers, OPC UA, OPC DA, MQTT, Sparkplug B, MTConnect, AWS IoT Core, Kafka, .NET, REST Clients, and other Databases.
Controller Handshaking
Each transaction can be initiated using data from a PLC (Programmable Logic Controller) and full confirmation feedback will be provided to verify the values being set.
Database Tags for Visualization
Implement database tags to read any database record and column value for live updates, visualization, trending, alarming, calculated values, and more. Database tags are also writable with the Data Historian product.
Dynamic Queries
The comprehensive calculation engine integrates diverse data sources to determine which records should be processed.
Edge Computing
OAS is an on-premise edge solution that employs first-in, first-out (FIFO) processing, guaranteeing complete delivery for each record that is processed before confirmation is sent.
Networking
Data transfer can be extended to remote databases and OAS Engines for peer-to-peer data exchange.
Common Use Cases
Batch Sequencing
Utilize OAS to retrieve setpoints and limits from a database for each step in a batch sequence. The controller notifies OAS when it is prepared for the next step and specifies which record to obtain. OAS then reads the data from the database, delivers it to the controller, and compares the values sent to those received back from the controller. Once all values match, OAS sends confirmation to the controller.
Order Processing
Controller setpoints can be updated with values from a database associated with a specific order number or batch ID. By using a string calculation tag, a WHERE filter can be generated from data within the controller to determine which order number should be retrieved from the database.
Database User Interface
Create Human Machine Interfaces (HMIs) for data from a database using the cross-platform UIEngine without any coding required. Together with the Data Historian product values can also be updated in the database. The UIEngine features an extensive library of components that allow for drag-and-drop design, along with integrated support for Web Trend and Web Alarm products.
Learn how thousands of customers are using the OAS Product Platform around the globe to achieve truly open industrial automation
24/7/365
Support
Technical support available by phone, chat, and email
30+ Years
Experience
Product efficacy, market testing, and reliability
Used in 10K+
Data Servers
OAS is used in thousands of businesses worldwide
OAS Platform Features
Cross-Platform Support
The OAS Platform supports multiple operating systems and deployment options including Windows, Linux, Docker Containers, and can even run on low footprint devices such as a Raspberry PI 4.
Networking
OAS is an edge solution that offers flexible networking options for standalone installations, multi-tenant data aggregation, and even secure unidirectional data transport.
Programmatic Setup
Utilize our .NET SDK or REST API for flexible and automated setup, ensuring full integration with your asset management software. You can also import and export CSV files, which helps you work with Excel and third-party applications.
Calculations, Time On, Counts, and Totals
Merge data from various controllers and additional data sources while performing real-time computations and logic processing, all without the need for coding. Monitor the duration of activities for specific points and the frequency of their transitions over a defined period. Aggregate analog values both daily and over the entire timeline.
See How We Compare
The initial cost of OAS is far less than our competitors – but the savings don’t stop there. We work with OEMS and System Integrators to provide perpetual licenses with quantity discounts with flexible tag pricing and unlimited client connections.
No Question Left Unanswered
We make getting started with OAS easy - Follow this step-by-step introduction to using the Open Automation Software platform, from selecting your data sources, product features, and data destinations.
Getting Started - Download, Setup & Support
Step-by-step introduction to using the Open Automation Software platform
An overview of the recipe transactions and how values are transactionally obtained.
Follow these essential steps and video to set up recipe executions.
An overview of database tag operation and how to enable database values as a tag data source.
Getting Started - Database Tags
Guided steps and video on how to define a value from a database column as a data source.
Related Videos
