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. If you need a Modbus database connector, SQL database connector, Allen Bradley database connector, or MQTT database connector, OAS has you covered. You can also connect with Siemens controllers, OPC UA, OPC DA, and Sparkplug B, all from one platform.
Read DB Data into OAS Tags
You can bring values from your databases into live OAS Tags at any rate from once per second to scheduled times or triggered events. It's simple to link tag data to a database record or view using flexible query filters.
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
Connect to SQL Server, Oracle, Access, SQL Azure, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, MySQL, Amazon Aurora, Amazon RDS, and Google Firebase. The OAS database connectors ensure your data gets to PLCs and DCS systems with full confirmation that everything was transferred successfully.
Integrate Data with Other Sources
With support for Modbus, OPC UA, OPC DA, MQTT, Sparkplug B, and cloud servers like Azure IoT, AWS IoT Core, and Kafka, you can share data across all systems using the same platform. The OPC database connector, IIoT database connector, and Siemens database connector are all built in.
Customizable Import Behavior
You choose how and when data transfers happen. It can be continuous, triggered by an event, or run at specific times. You can even control it with other tag values 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
Use database tags to monitor live data from your database. You can set up visualization, alarms, trending, and calculations. You can also write back to your database when using the OAS Data Historian.
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. The database connector makes this kind of distributed setup easy to manage.
Common Use Cases
Batch Sequencing
Pull setpoints and limits from a database for each step in a batch process. The controller lets OAS know when it's ready for the next step, and OAS grabs the right record, sends it over, and confirms the values match.
Order Processing
Use controller values to filter your database and grab data for specific order numbers or batches. You can generate a WHERE filter dynamically using calculation tags, which helps automate the process.
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
