openautomationsoftware.com Open in urlscan Pro
18.164.96.48  Public Scan

Form analysis
2 forms found in the DOM

GET /

<form id="general_search" method="get" action="/"><input type="text" name="s" value="" placeholder="search" required="required"><button type="submit" title="submit search" style="display:none;">submit search</button></form>

GET /knowledge-base/

<form id="kb-search" method="get" action="/knowledge-base/">
  <input type="text" name="s" id="s" placeholder="search knowledge base"><i class="wp-svg-custom-oas-search oas-search"></i>
  <input type="submit" style="display:none;">
</form>

Text Content

Skip to content

Open Automation Software
 * Open Automation Software
 * submit search
 * 1-303-679-0898
 * Download
 * Support Expand child menu
   * Knowledge Base
   * Security
   * Videos
   * How To …
   * Request a Product Demo
   * Request a Price Quotation
   * Request a Product Feature
   * Chat with Support
   * Contact Us
 * About OAS Expand child menu
   * What is OAS?
   * Why Us?
   * Industries
   * OEMs & Integrators
   * Use Cases
   * News & Articles
 * Products Expand child menu
   * 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
   * SDKs & APIs
     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
   * Pricing
     Learn more about product pricing and request a quote based on your
     requirements


KNOWLEDGE BASE

Product documentation, step-by-step instructions, and sample code for developer
tools and APIs

 * Getting Started with OAS
   * Installation
     * Download
     * Windows Installation
     * Linux Installation
     * Raspberry Pi Installation
     * OAS in Docker
     * File Locations
   * Quick Start
     * Evaluation Guide
     * Software Workflow
     * Quick Start Example
   * OEM Information
     * Advantages
   * Private Label
   * OAS System Requirements
     * OAS System Requirements – Overview
     * Operating Systems
     * Recommended Hardware
     * SQL Server System Requirements
     * Installing SQL Server
   * Redundancy
     * Overview – Redundancy
     * Driver Interface Failover
     * Client Application Failover
     * Data Log to Same Table
     * FAQs – Redundancy
   * OAS Service
     * OAS Service – Overview
     * Selecting Service
     * Runtime Control
     * Service Logon
     * Service Control Manager
     * Service Control
     * Service Defaults
     * Remoting Security
     * FAQs – Windows Services
   * License Activation
     * License Activation – Overview
     * Activate with Internet
     * Activate License Manually
     * Move Software License
     * Update Software Version
     * License Properties
     * Software Licensing
     * Annual Software Maintenance
     * End User License Agreement
     * FAQs – License
     * Troubleshooting – License
   * Options
     * Options – Overview
     * FAQs – Options
   * Typical Deployments
   * Videos – Getting Started
   * FAQs – Getting Started

 * Security
   * Overview – Security
   * Getting Started – Security
   * Restrict Tag Access
   * CSV Export & Import
   * Programmatic Interface
   * Videos – Security
   * Security Updates
   * FAQs – Security

 * Data Processing
   * Tags
     * Overview – Tags
     * Getting Started – Tags
       * Manage – Tags
       * Add Group
       * Delete Group
       * Add Tag
       * Delete Tag
       * Modify Tag
       * Save and Load Tags
     * Parameter Properties
     * Tag Variables
     * Alarm Limits
     * Time On and Counts
     * Total
     * CSV Export and Import
     * Tags Programmatic Interface
     * Watch Window
     * Videos – Tags
     * FAQs – Tags
     * How To Tags
     * Troubleshooting – Tags
   * Calculations
     * Getting Started – Calculations
     * Math Functions
     * Trig Functions
     * Compare Functions
     * Limit Functions
     * Logic Functions
     * Text Functions
     * Statistic Functions
     * Date Functions
     * Tag Alias Functions
     * JSON Functions
     * Videos – Calculations
   * Data Route
     * Overview – Data Route
     * Getting Started – Data Route
     * Tag to Tag – Data Route
     * Multiple Tags – Data Route
     * IoT Publish – Data Route
     * Time On and Time Off
     * FAQs – Data Route
     * Videos – Data Route
     * How To – Data Route
   * JSON Features
     * JSON Handling
     * JSON Data Source
     * How to – JSON
 * Device Interfaces
   * Allen Bradley
     * Getting Started Allen Bradley
     * One Click Allen Bradley
     * Videos – Allen Bradley
     * FAQs – Allen Bradley
     * How To – Allen Bradley
     * Troubleshooting – Allen Bradley
   * Modbus
     * Getting Started Modbus
     * Videos – Modbus
     * How To – Modbus
     * Troubleshooting – Modbus
   * MTConnect
     * Getting Started MTConnect
     * Videos – MTConnect
     * How To – MTConnect
     * Troubleshooting – MTConnect
   * OPC DA Client
     * Overview – OPC DA Client
     * Getting Started – OPC DA Client
     * OPCSystems.NET OPC Server Install
     * Browsing – OPC DA Client
     * IP Address – OPC DA Client
     * Runtime – OPC DA Client
     * Videos – OPC DA Client
     * FAQs – OPC DA Client
   * OPC DA Server
     * Getting Started OPC DA
     * One Click OPC DA
     * Videos – OPC DA
     * FAQs – OPC DA
     * How To – OPC DA
     * Troubleshooting – OPC DA
   * OPC UA Client
     * Getting Started – OPC UA Client
   * OPC UA Server
     * Getting Started OPC UA
     * One Click OPC UA
     * Videos – OPC UA
     * How To – OPC UA
     * Troubleshooting – OPC UA
   * OPC Alarm & Events
     * Getting Started A&E OPC Servers
   * Raspberry Pi GPIO
     * Getting Started GPIO
     * Videos – GPIO
   * Siemens S7
     * Getting Started – Siemens S7
     * Siemens S7 Address Syntax
     * Siemens S7 Security Setup
     * Videos – Siemens S7
     * How To – Siemens S7
     * Troubleshooting – Siemens S7
   * Sparkplug B
     * Getting Started – SpB EoN Node
     * Getting Started – SpB Host App
     * How To – Sparkplug B
     * Videos- Sparkplug B

 * User Interfaces
   * UI Engine – No Code
     * Overview – UI Engine
     * Getting Started – UI Engine
     * Reference – UI Engine
       * Editor Basics
       * Configuration
       * Security
       * Components
       * Connectors
     * Videos – UI Engine
     * How To – UI Engine
   * Web HMI
     * Overview – Web HMI
     * Getting Started – Web HMI
     * Web HMI Wizard
     * Web HMI in WordPress
     * Web HMI Graphics
     * HTML Common Terms
     * Using SSL
     * Web HMI Dashboard
       * Overview – Web HMI Dashboard
       * Getting Started – Web HMI Dashboard
       * Web HMI Dashboard Deployment
       * Web HMI Dashboard Modules
       * Videos – Web HMI Dashboard
     * Videos – Web HMI
     * FAQs – Web HMI
     * How To – Web HMI
   * Web Alarm
     * Overview – Web Alarm
     * Getting Started – Web Alarm
     * Videos – Web Alarm
     * FAQs – Web Alarm
     * How To – Web Alarm
   * Web Trend
     * Overview – Web Trend
     * Getting Started – Web Trend
     * Videos – Web Trend
     * FAQs – Web Trend
     * How To – Web Trend
   * Grafana
     * Grafana Integration
   * Node Red
     * Getting Started
     * Videos – Node Red
   * .NET WPF HMI
     * Overview – WPF HMI
     * Visual Studio
       * Getting Started – WPF Visual Studio
       * Add OPCWPFDashboard to Toolbox
       * FAQs – WPF Visual Studio
       * Troubleshooting – Visual Studio
     * Expression Blend
       * Overview – Expression Blend
       * Getting Started – Expression Blend
       * Element and Data Binding
       * WPF Storyboard
       * FAQs – Expression Blend
       * Troubleshooting – Expression Blend
     * WPF HMI Dashboard
       * Overview – WPF HMI Dashboard
       * Getting Started – WPF HMI Dashboard
     * WPF Page Navigation
     * Videos – WPF HMI
     * How To – WPF HMI
   * .NET WinForm HMI
     * Overview – WinForm HMI
     * Getting Started – WinForm HMI
     * WinForm HMI Controls
       * Overview – WinForm HMI Controls
       * Add OPC Controls to Toolbox
       * OPC Controls.NET Runtime Distribution
       * OPC Controls Label
       * OPC Controls Button
       * OPC Controls TextBox
       * OPC Controls CheckBox
       * OPC Controls RadioButton
       * OPC Controls GroupBox
       * OPC Controls PictureBox
       * OPC Controls Panel
       * OPC Controls ListBox
       * OPC Controls ComboBox
       * OPC Controls HScrollBar
       * OPC Controls VScrollBar
       * OPC Controls TrackBar
       * OPC Controls StatusBar
       * OPC Controls Data
     * .NET WinForm Gauge
       * Overview – WinForm Gauge
       * Videos – WinForm Gauge
       * FAQs – WinForm Gauge
     * Videos – WinForm HMI
     * FAQs – WinForm HMI
     * Troubleshooting – WinForm HMI
   * .NET Alarm
     * Overview – .NET Alarm
     * Getting Started – .NET Alarm
     * Videos – .NET Alarm
     * FAQs – .NET Alarm
   * .NET Trend
     * Overview – .NET Trend
     * Getting Started – .NET Trend
     * .NET Trend Component
       * Overview – .NET Trend Component
       * Visual Studio Reference
       * Trend Properties
       * Runtime Distribution
       * .NET Trend Toolbars
       * Programmatic Methods
     * Videos – .NET Trend
     * FAQs – .NET Trend
   * Smart Client Deployment
     * Overview – Smart Client
     * Getting Started – Smart Client
     * Videos – Smart Client
     * FAQs – Smart Client Deployment
   * Additional Applications
     * Overview – Additional Applications
     * Trends and Alarms Dashboard
       * Getting Started – Trends and Alarms Dashboard
       * Videos – Trends and Alarms Dashboard
       * FAQs – Trends and Alarms Dashboard
     * One- Click HMI
       * Videos – One-Click HMI

 * Database Interfaces
   * Alarm Logging
     * Overview – Alarm Logging
     * Getting Started – Alarm Logging
     * Videos – Alarm Logging
     * FAQs – Alarm Logging
     * How To – Alarm Logging
     * Troubleshooting – Alarm Logging
   * Data Logging
     * Overview – Data Logging
     * Getting Started – Data Logging
     * Data Logging Configuration
       * Logging Group Common Properties
       * Logging Group Tags Properties
       * Logging Group Database Properties
       * Logging Group CSV Logging Properties
     * Save and Load Data Logging
     * CSV Import and Export Data Logging
     * One-Click Data Logging
     * Log High Speed Data from a PLC
     * Log High Speed Data from .NET App
     * Azure SQL Setup
     * Redundant Engines to the Same Table
     * Performance Benchmarks
     * Programmatic Interface
     * Videos – Data Logging
     * FAQs – Data Logging
     * How To – Data Logging
     * Troubleshooting – Data Logging
   * Excel
     * Overview – Excel
     * Getting Started – Excel
     * Videos – Excel
     * FAQs – Excel
   * Recipes
     * Overview – Recipes
     * Getting Started – Recipes
     * Add, Delete, Modify Recipe
     * Recipe Properties
       * Recipe Common Properties
       * Recipe Tags Properties
       * Recipe Database Properties
     * Save & Load Recipes
     * CSV Import & Export – Recipes
     * Programmatic Interface – Recipes
     * Videos – Recipes
     * FAQs – Recipes
     * Troubleshooting – Recipes
   * Reports
     * Overview – Reports
     * Videos – Reports
     * FAQs – Reports

 * Cloud IoT Interfaces
   * AWS IoT Gateway
     * Read Data from AWS IoT
     * Publish Data to AWS IoT
     * Videos – AWS IoT
     * How To – AWS IoT
   * Azure IoT Hub
     * Getting Started – Azure IoT Hub
     * Videos – Azure IoT Hub
   * Azure Event Hubs
     * Getting Started – Azure Event Hubs
     * Videos – Azure Event Hubs
   * Kafka
     * Getting Started – Kafka Consumer
     * Getting Started – Kafka Producer
     * Videos – Kafka
     * How To – Kafka
   * MQTT
     * Getting Started – MQTT Broker
     * Getting Started – MQTT Client
     * Videos – MQTT
     * How To – MQTT
     * Troubleshooting – MQTT

 * Notification
   * Alarm Notification
     * Overview – Alarm Notification
     * Getting Started – Alarm Notification
     * CSV Import & Export – Alarm Notification
     * Programmatic Interface
     * Videos – Alarm Notification
     * FAQs – Alarm Notification
     * How To – Alarm Notification

 * Programmatic Interfaces
   * Overview – Programmatic Interfaces
   * .NET Real Time Data Access
     * Overview – .NET Real Time Data Access
     * Example Service Code
     * Getting Started
     * Read Data Continuously
     * Read Data Synchronously
     * Read OPC Items
     * Write Data
     * Write OPC Items
     * Videos – .NET Data
     * How To – .NET Data
     * Troubleshooting – .NET Data
   * .NET Server Configuration
     * Overview – .NET Server Configuration
     * Example Service Code
     * Get & Set Tag Properties
     * CSV Import and Export
     * Alarm Logging Groups
     * Alarm Notification Groups
     * Data Logging Groups
     * Driver Interfaces
     * General Functions
     * OPC Browsing
     * Options
     * Recipe Groups
     * Report Groups
     * Security Groups
     * System Errors
     * Tags
     * Tag Groups
     * Trend Tags
     * Update Version
     * Automatic Configuration with Dynamic User Interface
   * .NET Universal Driver Interface
     * Overview – UDI
     * Technical Overview
     * Create Driver
     * Create a Hosting App
     * Platform Support
     * Deploy to Linux/Raspberry Pi
     * UDI for Raspberry Pi GPIO
     * Videos – UDI
     * FAQs – UDI
   * .NET Database Data
     * Read Database Data
   * REST API
     * Getting Started – REST API
     * Native iOS – REST API
     * Raspberry Pi – REST API
     * Videos – REST API
     * FAQs – REST API
     * How To – REST API
     * Troubleshooting – REST API
   * Web UI Programming
     * Overview – Web UI Programming
     * Web HMI Reference
       * Overview-Web HMI Reference
       * Installation and Configuration
       * Authentication Overview
       * Authentication Examples
       * Other Configuration Options
       * Marking up HTML Elements
       * Top Level Classes – JSON Type Reference
       * HTML Attribute Reference
       * Client Script Library Reference
     * Web Alarm Reference
       * Web Alarm
     * Web Trend Reference
       * Overview – Web Trend Programming
       * Installation and Configuration
       * Trend Control Description and Options
       * Trend Binding Callback
       * Data Object
       * Historical Data
       * Utility Functions
       * Additional Features of Flot
   * Example Source Code

 * Networking
   * Overview – Networking
   * Getting Started – Networking
   * Basic Networking
   * Live Data Cloud Networking
   * Unidirectional Network Gateway
   * Change Default Network Port Number
   * Videos – Networking
   * FAQs – Networking
   * Troubleshooting – Networking

 * How To

 * Troubleshooting

 * FAQ


ONE CLICK DATABASE

Data Logging Groups can be automatically setup by using the One Click Database
feature that browses Open Automation Software Tags automatically and creates
data logging groups based on the tags in a selected services. You can then
modify or delete data logging groups from the configuration that you do not
want.

View the following video on how to use the One Click Database Feature or follow
the steps in the table below:




STEP 1


Start Configure OAS application from the program group Open Automation Software.

 

 


STEP 2

Select Configure – Data Logging.




STEP 3

Select the Local OAS Service by selecting the Select button or select a remote
network node by entering an IP Address or Network Node Name and click on the
Select button.




STEP 4

Select the One Click button in the upper menu bar.




STEP 5

In Step 1 of the One Click Database Wizard use the Tag Group Browse button to
select a starting Tag Group or leave the Tag Group blank to obtain all Tags of
the OAS Service defined in the Network Node and optional Live Data Node fields.



Also specify a Group Name that will be the base group name of all of the logging
groups.


STEP 6

In Step 2 specify the Logging Type and other Common properties to all Logging
groups.




STEP 7

In Step 3 define the names of the common database field names.




STEP 8

In Step 4 define the Database Provider, Server, Database, and base Table name to
log to if logging to a database engine. You can skip this step if you plan to
log only to CSV files.




STEP 9

In Step 5 define the CSV Logging Path and File Name if you wish to setup all
logging groups to log to a CSV file.




STEP 10

Click the Finish button in the lower right to begin the automated setup.


STEP 11

Select the Save button on the toolbar at the top.



STEP 12

Go to Configure – Options and set the default Data Logging Configuration file to
the file you just saved.


OPEN AUTOMATION SOFTWARE

355 S. Teller St, Suite 200
Lakewood, CO 80226
1-303-679-0898

 * Home
 * Products
   * Universal Data Connector
     * HMI SCADA for .NET
     * HMI SCADA for Web
     * Data Automation
     * Communication Drivers
   * Data Historian
   * Alarm Logging & Notification
   * Device & Data Connectors
   * IoT Connectors
   * Developer Tools & APIs
   * Networking Features
   * Pricing

 * About OAS
   * Use Cases
   * News & Articles
 * Support
   * Knowledge Base
   * Videos
   * Downloads
 * Contact Us
   * Request a Product Demo
   * Request a Price Quotation