Posted on

How to Log Data to an Azure IoT Hub

This guide shows how to log data to an Azure IoT hub in three easy steps. 

 

STEPS

Follow the links to the OAS Help articles:

Make sure Open Automation Software is installed and the OAS Service is running

Configure your data source

Configure Azure data logging – this consists of three sub-steps covered in the article:

  • Create an Azure IoT Hub (Windows Azure website)
  • Create an IoT Driver
  • Route Live Data to your Azure IoT Hub

 

SEE ALSO:

  • Alarm Logging
  • Alarm Notification
  • Other Data Sources
    • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
    • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
    • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
    • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
    • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
    • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
    • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
    • Excel – Use the Excel Connector to use Microsoft Excel as data source
    • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, mySQL and  SQL Azure databases
    • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
    • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
    • OPC Servers – Connect to OPC DA 2.x, 3.0, OPC UA, OPC A&E, and OPC UA Alarm and Conditions. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Servers
    • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
    • REST – With the REST API Connector you can connect to data sources via the REST API
    • iOS and Android Apps – Use PCL for Android and iOS to connect to data on iOS and Android devices.
  • Other Data Destinations
    • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
    • .NET WPF HMI Applications – Use WPF HMI .NET to create HMI visualizations for WPF Smart Clients
    • .NET WinForm HMI Applications – Use WinForm HMI .NET to create HMI visualizations for WinForm Smart Clients
    • .NET Trending Application – Use Trend .NET for real-time trending for WinForm and WPF applications and historical trending when combined with OAS Data Historian.
    • .NET Alarming Applications – Use Alarm .NET for real-time alarming for WinForm and WPF applications and historical alarming with alarm notification via email, SMS text, and voicemail.
    • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
    • REST – With the REST API Connector you can connect to data sources via the REST API
    • Web-based HMI Applications – Use Web HMI to create cross-platform HMI apps
    • Web-based Trending Aplicatons – Use Web Trend to create cross-platform trending apps
    • Web-based Alarming Applications – Use Web Alarm to create cross-platform alarm apps
    • iOS and Android HMI Apps – Use PCL for Android and iOS to create iOS and Android applications for live data.
    • Data Historian – With OAS Data HIstorian you can log data to SQL Server, Oracle, Access, mySQL, SQL Azure and CSV files.
    • Reports – With OAS Reports you can create reports from OAS data logging products or other databases. Generate reports as Word, Excel, PDF, HTML or Email.
    • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
    • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
    • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
    • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
    • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
    • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
    • Excel – Use the Excel Connector to use Microsoft Excel as data source
    • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, and mySQL databases
    • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
    • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
    • OPC Servers – Connect to OPC UA and Classic OPC DA 2.0 and 3.0 OPC Servers. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Server or OAS IoT Driver.
    • Microsoft Azure – Use the SQL Azure Data Logging and SQL Azure Alarm Logging products to connect to Microsoft Azure SQL Databases
    • Microsoft Azure IoT Data Hub – Transfer any Data Source to Azure IoT Data Hub using the OPC Tunnel Connector
Posted on

How to Log Data From an AWS IoT Hub to a Database

How to Log Data From an AWS IoT Hub to a Database

Open Automation Software Tags can be defined to interface with AWS IoT Gateway with the built in AWS IoT Gateway Driver Interface. This tutorial walks you though downloading and installing OAS, configuring an AWS IoT Gateway driver, configuring tags and logging them to a database. Supported databases include SQL Server, Oracle, Access, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, InfluxDB, MySQL, SQL Azure, Amazon Aurora, Amazon RDS, Amazon Redshift, Google Firebase, and CSV files.

Step 1. Download and Install the Open Automation Software and Start the OAS Service

If you have not already done so, you will need to download and install the OAS platform.  Fully functional trial versions of the software are available for Windows, Windows IoT Core, Linux, Raspberry Pi and Docker on our downloads page.

On Windows run the downloaded Setup.exe file to install one or more of the Open Automation Software features. Select the default Typical installation if you are not sure what features to use or the Custom installation if you want to save disk space on the target system.  When prompted agree to the End User License Agreement to continue the installation.

For more detailed instructions and video tutorials, visit the installation guide for your system:
Windows Installation | Linux Installation | Raspberry Pi Installation | Dockers Installation

When the installation is finished the OAS Service Control application will appear.  Use this application to start the 4 Services. If this is the first time installing the software it will automatically enter Runtime with an example Tag Configuration.

Step 2. Configure Your AWS IoT Gateway Data Source

  1. First, you will need to open the Configure OAS application from the program group Open Automation Software.

  2. Select Configure >> License from the top menu and verify that AWS IoT is one of the available Drivers in the lower left of the form. The demo license will have this by default. If you do not see AWS IoT available, contact support@openautomationsoftware.com to update your license.

  3. Select Configure >> Drivers from the top menu.


  4. Select localhost or the remote service you wish to modify with the Select button to the right of the Network Node list.


  5. The Configure Drivers Screen will appear. Select AWS IoT Gateway from the Driver dropdown box.


  6. Enter a meaningful Driver Interface Name that you will refer to this physical connection when defining Tags with an AWS IoT Data Source.

  7. Define the properties for the desired physical connection.

  8. Click the Add Driver button above the Driver list in the left pane to add the Driver Interface as an available selection when defining Tags in the next step.

For more detailed instructions on configuring your AWS IoT Gateway data source, click here to see our Getting Started AWS IoT Gateway tutorial.

Step 3. Configure Your Tags

OAS provides multiple ways to add and define tags:

To add a Tag manually:

  1. In the OAS Configure Application, select Configure >> Tags from the top menu.


  2. Select localhost or the remote service you wish to modify with the Select button to the right of the Network Node list.


  3. Click on the Add Tag button located at the top of the Tag browser on the left portion of the screen.


  4. A dialog box will appear. Enter a name for your new tag and click ok.

  5. A configuration screen will appear for your new tag. Select your data source type in in the Data Source dropdown box.


  6. Specify the correct data type in the Data Type dropdown box.

  7. Click Apply Changes at the bottom right of the window.

For more detailed instructions on configuring your tags, click here to see our Getting Started Tags tutorial.

Step 4. Configure Data Logging

  1. In the OAS Configure Application, select Configure >> Data Logging from the top menu.


  2. Select localhost or the remote service you wish to log data from with the Select button to the right of the Network Node list.


  3. A Logging Group screen will appear.


  4. In the Common Tab, you will determine your table format and type of logging you wish to implement.

  5. In the Tags Tab, you will select the tags you wish to log.

  6. In the Database Tab, you will select what type of database you will be logging to and enter the connection parameters. OAS can log to SQL Server, Oracle, Access, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, InfluxDB, and MySQL.

  7. If you wish to log to CSV, you would configure that in the CVS Logging tab.

For more detailed instructions on Configuring Data Logging, visit our Getting Started Data Logging tutorial or watch the video tutorial below:

  • 00:00 – Introduction
  • 01:30 – Getting Started
  • 03:00 – Continuous Logging
  • 04:15 – SQL Server
  • 06:25 – Save Changes
  • 07:00 – Continuous Narrow Logging
  • 09:30 – Event Driven
  • 11:20 – Handshake Confirmation
  • 12:45 – High Speed Logging
  • 15:00 – Log to Stored Procedure
  • 15:25 – Triggers
  • 16:30 – Event Narrow Logging
  • 18:00 – Timestamps
  • 20:30 – Snapshot Logging
  • 21:45 – Specific Time of Day Logging
  • 22:50 – Data Change Row Logging
  • 25:15 – Data Change Narrow Logging
  • 26:45 – Networking
  • 31:55 – Store and Forward
  • 37:30 – Disable Store and Forward
  • 40:15 – Update Records
  • 40:50 – Dynamic Server, Database, and Table
  • 41:10 – Automatic Deletion
  • 41:40 – CSV File Logging
  • 45:30 – Programmatic Interface
  • 46:45 – CSV Export / Import
  • 48:20 – One Click Automation
  • 52:20 – Transaction Logging
  • 54:25 – System Errors
  • 56:00 – Contact Us
  • 56:50 – Read Database Data
Posted on

How to Create Visualizations/HMIs Using .NET WPF

This guide shows how to create .NET visualizations/HMIs in three easy steps. 

 

STEPS

Follow the links to the OAS Help articles:

Make sure Open Automation Software is installed and the OAS Service is running

Configure your data source

Create WPF HMI Application using Visual Studio

 

SEE ALSO:

  • Other Data Sources
    • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
    • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
    • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
    • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
    • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
    • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
    • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
    • Excel – Use the Excel Connector to use Microsoft Excel as data source
    • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, mySQL and  SQL Azure databases
    • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
    • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
    • OPC Servers – Connect to OPC DA 2.x, 3.0, OPC UA, OPC A&E, and OPC UA Alarm and Conditions. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Servers
    • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
    • REST – With the REST API Connector you can connect to data sources via the REST API
    • iOS and Android Apps – Use PCL for Android and iOS to connect to data on iOS and Android devices.
  • Other Data Destinations
    • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
    • .NET WPF HMI Applications – Use WPF HMI .NET to create HMI visualizations for WPF Smart Clients
    • .NET WinForm HMI Applications – Use WinForm HMI .NET to create HMI visualizations for WinForm Smart Clients
    • .NET Trending Application – Use Trend .NET for real-time trending for WinForm and WPF applications and historical trending when combined with OAS Data Historian.
    • .NET Alarming Applications – Use Alarm .NET for real-time alarming for WinForm and WPF applications and historical alarming with alarm notification via email, SMS text, and voicemail.
    • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
    • REST – With the REST API Connector you can connect to data sources via the REST API
    • Web-based HMI Applications – Use Web HMI to create cross-platform HMI apps
    • Web-based Trending Aplicatons – Use Web Trend to create cross-platform trending apps
    • Web-based Alarming Applications – Use Web Alarm to create cross-platform alarm apps
    • iOS and Android HMI Apps – Use PCL for Android and iOS to create iOS and Android applications for live data.
    • Data Historian – With OAS Data HIstorian you can log data to SQL Server, Oracle, Access, mySQL, SQL Azure and CSV files.
    • Reports – With OAS Reports you can create reports from OAS data logging products or other databases. Generate reports as Word, Excel, PDF, HTML or Email.
    • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
    • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
    • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
    • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
    • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
    • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
    • Excel – Use the Excel Connector to use Microsoft Excel as data source
    • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, and mySQL databases
    • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
    • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
    • OPC Servers – Connect to OPC UA and Classic OPC DA 2.0 and 3.0 OPC Servers. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Server or OAS IoT Driver.
    • Microsoft Azure – Use the SQL Azure Data Logging and SQL Azure Alarm Logging products to connect to Microsoft Azure SQL Databases
    • Microsoft Azure IoT Data Hub – Transfer any Data Source to Azure IoT Data Hub using the OPC Tunnel Connector
Posted on

How to Send Email Alarm Notifications for IoT

This guide shows how to send email alarm notifications for IoT events in three easy steps. 

 

STEPS

Follow the links to the OAS Help articles:

Make sure Open Automation Software is installed and the OAS Service is running

Configure your data source

Configure alarm email notifications

 

SEE ALSO:

  • Overview – Alarm Notification
  • Getting Started – Alarm Notification
  • Alarm Notification CSV Export and Import
  • Alarm Notification Programmatic Interface
  • Videos – Alarm Notification
  • Frequently Asked Questions – Alarm Notification
  • Alarm Logging
  • Other Data Sources
    • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
    • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
    • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
    • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
    • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
    • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
    • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
    • Excel – Use the Excel Connector to use Microsoft Excel as data source
    • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, mySQL and  SQL Azure databases
    • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
    • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
    • OPC Servers – Connect to OPC DA 2.x, 3.0, OPC UA, OPC A&E, and OPC UA Alarm and Conditions. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Servers
    • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
    • REST – With the REST API Connector you can connect to data sources via the REST API
    • iOS and Android Apps – Use PCL for Android and iOS to connect to data on iOS and Android devices.
  • Other Data Destinations
    • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
    • .NET WPF HMI Applications – Use WPF HMI .NET to create HMI visualizations for WPF Smart Clients
    • .NET WinForm HMI Applications – Use WinForm HMI .NET to create HMI visualizations for WinForm Smart Clients
    • .NET Trending Application – Use Trend .NET for real-time trending for WinForm and WPF applications and historical trending when combined with OAS Data Historian.
    • .NET Alarming Applications – Use Alarm .NET for real-time alarming for WinForm and WPF applications and historical alarming with alarm notification via email, SMS text, and voicemail.
    • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
    • REST – With the REST API Connector you can connect to data sources via the REST API
    • Web-based HMI Applications – Use Web HMI to create cross-platform HMI apps
    • Web-based Trending Aplicatons – Use Web Trend to create cross-platform trending apps
    • Web-based Alarming Applications – Use Web Alarm to create cross-platform alarm apps
    • iOS and Android HMI Apps – Use PCL for Android and iOS to create iOS and Android applications for live data.
    • Data Historian – With OAS Data HIstorian you can log data to SQL Server, Oracle, Access, mySQL, SQL Azure and CSV files.
    • Reports – With OAS Reports you can create reports from OAS data logging products or other databases. Generate reports as Word, Excel, PDF, HTML or Email.
    • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
    • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
    • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
    • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
    • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
    • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
    • Excel – Use the Excel Connector to use Microsoft Excel as data source
    • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, and mySQL databases
    • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
    • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
    • OPC Servers – Connect to OPC UA and Classic OPC DA 2.0 and 3.0 OPC Servers. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Server or OAS IoT Driver.
    • Microsoft Azure – Use the SQL Azure Data Logging and SQL Azure Alarm Logging products to connect to Microsoft Azure SQL Databases
    • Microsoft Azure IoT Data Hub – Transfer any Data Source to Azure IoT Data Hub using the OPC Tunnel Connector
Posted on

How to Create Web-Based Visualizations/HMIs

This guide shows how to create web based visualizations/HMIs using the OAS Web HMI product. 

 

STEPS

Follow the links to the OAS Help articles:

Make sure Open Automation Software is installed and the OAS Service is running

Configure your data source

Create web pages to display HMI. Use the Web HMI Wizard to quickly generate HTML code.

 

SEE ALSO:

Posted on

How to Automatically Import OPC Tags

Open Automation Software One-Click OPC feature let’s you quickly and easily create tags by browsing an OPC Server 

STEPS

Follow the links to the OAS Help articles:

Make sure Open Automation Software is installed and the OAS Service is running

Tags can be automatically setup by using the One Click OPC feature that browses OPC Servers automatically and creates tags based on the OPC Items defined in the OPC Server. You can then delete tags from the configuration that you do not want.

 

SEE ALSO:

  • Overview – Tags
  • Alarm Logging
  • Alarm Notification
  • Other Data Sources
    • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
    • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
    • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
    • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
    • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
    • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
    • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
    • Excel – Use the Excel Connector to use Microsoft Excel as data source
    • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, mySQL and  SQL Azure databases
    • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
    • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
    • OPC Servers – Connect to OPC DA 2.x, 3.0, OPC UA, OPC A&E, and OPC UA Alarm and Conditions. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Servers
    • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
    • REST – With the REST API Connector you can connect to data sources via the REST API
    • iOS and Android Apps – Use PCL for Android and iOS to connect to data on iOS and Android devices.
  • Other Data Destinations
    • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
    • .NET WPF HMI Applications – Use WPF HMI .NET to create HMI visualizations for WPF Smart Clients
    • .NET WinForm HMI Applications – Use WinForm HMI .NET to create HMI visualizations for WinForm Smart Clients
    • .NET Trending Application – Use Trend .NET for real-time trending for WinForm and WPF applications and historical trending when combined with OAS Data Historian.
    • .NET Alarming Applications – Use Alarm .NET for real-time alarming for WinForm and WPF applications and historical alarming with alarm notification via email, SMS text, and voicemail.
    • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
    • REST – With the REST API Connector you can connect to data sources via the REST API
    • Web-based HMI Applications – Use Web HMI to create cross-platform HMI apps
    • Web-based Trending Aplicatons – Use Web Trend to create cross-platform trending apps
    • Web-based Alarming Applications – Use Web Alarm to create cross-platform alarm apps
    • iOS and Android HMI Apps – Use PCL for Android and iOS to create iOS and Android applications for live data.
    • Data Historian – With OAS Data HIstorian you can log data to SQL Server, Oracle, Access, mySQL, SQL Azure and CSV files.
    • Reports – With OAS Reports you can create reports from OAS data logging products or other databases. Generate reports as Word, Excel, PDF, HTML or Email.
    • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
    • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
    • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
    • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
    • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
    • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
    • Excel – Use the Excel Connector to use Microsoft Excel as data source
    • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, and mySQL databases
    • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
    • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
    • OPC Servers – Connect to OPC UA and Classic OPC DA 2.0 and 3.0 OPC Servers. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Server or OAS IoT Driver.
    • Microsoft Azure – Use the SQL Azure Data Logging and SQL Azure Alarm Logging products to connect to Microsoft Azure SQL Databases
    • Microsoft Azure IoT Data Hub – Transfer any Data Source to Azure IoT Data Hub using the Data Route
Posted on

How to Log OPC Server Data to a Database

How to Log OPC Server Data to a Database

Open Automation Software Tags can be defined to connect to Classic OPC Data Access 2.xx and 3.0 Servers with the built in OPC Interface. This tutorial walks you though downloading and installing OAS, configuring tags from your OPC Server and logging them to a database. Supported databases include SQL Server, Oracle, Access, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, InfluxDB, MySQL, SQL Azure, Amazon Aurora, Amazon RDS, Amazon Redshift, Google Firebase, and CSV files.

Step 1. Download and Install the Open Automation Software and Start the OAS Service

If you have not already done so, you will need to download and install the OAS platform.  Fully functional trial versions of the software are available for Windows, Windows IoT Core, Linux, Raspberry Pi and Docker on our downloads page.

On Windows run the downloaded Setup.exe file to install one or more of the Open Automation Software features. Select the default Typical installation if you are not sure what features to use or the Custom installation if you want to save disk space on the target system.  When prompted agree to the End User License Agreement to continue the installation.

For more detailed instructions and video tutorials, visit the installation guide for your system:
Windows Installation | Linux Installation | Raspberry Pi Installation | Dockers Installation

When the installation is finished the OAS Service Control application will appear.  Use this application to start the 4 Services. If this is the first time installing the software it will automatically enter Runtime with an example Tag Configuration.

Step 2. Configure OPC Server Tags

OAS provides multiple ways to add and define tags:

To add a Tag manually:

  1. In the OAS Configure Application, select Configure >> Tags from the top menu.

  2. Select localhost or the remote service you wish to modify with the Select button to the right of the Network Node list.

  3. Click on the Add Tag button located at the top of the Tag browser on the left portion of the screen.

  4. A dialog box will appear. Enter a name for your new tag and click ok.

  5. A configuration screen will appear for your new tag. Select OPC in the Data Source dropdown box.

  6. Use the Browse button to the right of the OPC Item to browse OPC Servers for the desired OPC Item.

  7. Select Local, the desired OPC Server, branch within the OPC Server, and OPC Item and click OK.

  8. Specify the desired OPC Update Rate for the Tag.

  9. Click Apply Changes at the bottom right of the window.

To add Tags with One Click OPC:

  1. In the OAS Configure Application, select Configure >> Tags from the top menu.

  2. Select localhost or the remote service you wish to modify with the Select button to the right of the Network Node list.

  3. To begin the One Click OPC process select the Group you would like to import to in the Tag configuration. If you want to import to the Root Level, select the Tags Group at the top of the tree.
    Then select the One Click Import button on the top menu bar.

  4. Click on the Import OPC DA 2.XX or 3.0 Items Button in the pop up window.

  5. Use the One Click OPC Wizard to browse for a branch as a starting position within an OPC Server or just select the OPC Server name itself to add all items from the selected OPC Server. For the best networking design select OPC Servers from Local even if you are configuring a remote OAS Service.

  6. Select to enable the options to Get Data Type from OPC Server and optionally the Descriptions.
    Additionally if you want to specify to Trend all of the points select Trend Points.

  7. Click Add Tags and it will automatically add all of the OPC Items from the OPC Server Branch you have selected and all of the sub Branches beneath it.

  8. Select the Save button on the toolbar at the top.

For more detailed instructions on Configuring OPC Server Tags, visit our Getting Started OPC tutorial or the One Click OPC tutorial or watch the video tutorial below:

Step 3. Configure Data Logging

  1. In the OAS Configure Application, select Configure >> Data Logging from the top menu.

  2. Select localhost or the remote service you wish to log data from with the Select button to the right of the Network Node list.

  3. A Logging Group screen will appear.

  4. In the Common Tab, you will determine your table format and type of logging you wish to implement.

  5. In the Tags Tab, you will select the tags you wish to log.

  6. In the Database Tab, you will select what type of database you will be logging to and enter the connection parameters. OAS can log to SQL Server, Oracle, Access, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, InfluxDB, and MySQL.

  7. If you wish to log to CSV, you would configure that in the CVS Logging tab.

For more detailed instructions on Configuring Data Logging, visit our Getting Started Data Logging tutorial or watch the video tutorial below:

  • 00:00 – Introduction
  • 01:30 – Getting Started
  • 03:00 – Continuous Logging
  • 04:15 – SQL Server
  • 06:25 – Save Changes
  • 07:00 – Continuous Narrow Logging
  • 09:30 – Event Driven
  • 11:20 – Handshake Confirmation
  • 12:45 – High Speed Logging
  • 15:00 – Log to Stored Procedure
  • 15:25 – Triggers
  • 16:30 – Event Narrow Logging
  • 18:00 – Timestamps
  • 20:30 – Snapshot Logging
  • 21:45 – Specific Time of Day Logging
  • 22:50 – Data Change Row Logging
  • 25:15 – Data Change Narrow Logging
  • 26:45 – Networking
  • 31:55 – Store and Forward
  • 37:30 – Disable Store and Forward
  • 40:15 – Update Records
  • 40:50 – Dynamic Server, Database, and Table
  • 41:10 – Automatic Deletion
  • 41:40 – CSV File Logging
  • 45:30 – Programmatic Interface
  • 46:45 – CSV Export / Import
  • 48:20 – One Click Automation
  • 52:20 – Transaction Logging
  • 54:25 – System Errors
  • 56:00 – Contact Us
  • 56:50 – Read Database Data

Posted on

How to Write Data to Excel

This guide shows how to write data to Excel in two easy steps. 

 

STEPS

Follow the links to the OAS Help articles:

Make sure Open Automation Software is installed and the OAS Service is running

Configure your Excel data source

 

SEE ALSO:

  • Excel FAQ
  • Alarm Logging
  • Alarm Notification
  • Other Data Sources

    • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
    • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
    • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
    • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
    • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
    • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
    • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
    • Excel – Use the Excel Connector to use Microsoft Excel as data source
    • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, mySQL and  SQL Azure databases
    • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
    • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
    • OPC Servers – Connect to OPC DA 2.x, 3.0, OPC UA, OPC A&E, and OPC UA Alarm and Conditions. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Servers
    • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
    • REST – With the REST API Connector you can connect to data sources via the REST API
    • iOS and Android Apps – Use PCL for Android and iOS to connect to data on iOS and Android devices.
  • Other Data Destinations
    • .NET Applications – The .NET Data Connector provides read and write access to data programmatically via C# or VB code in a .NET application.
    • .NET WPF HMI Applications – Use WPF HMI .NET to create HMI visualizations for WPF Smart Clients
    • .NET WinForm HMI Applications – Use WinForm HMI .NET to create HMI visualizations for WinForm Smart Clients
    • .NET Trending Application – Use Trend .NET for real-time trending for WinForm and WPF applications and historical trending when combined with OAS Data Historian.
    • .NET Alarming Applications – Use Alarm .NET for real-time alarming for WinForm and WPF applications and historical alarming with alarm notification via email, SMS text, and voicemail.
    • Javascript – With the HTTP API Connector you can connect to jQuery and JSON data sources
    • REST – With the REST API Connector you can connect to data sources via the REST API
    • Web-based HMI Applications – Use Web HMI to create cross-platform HMI apps
    • Web-based Trending Aplicatons – Use Web Trend to create cross-platform trending apps
    • Web-based Alarming Applications – Use Web Alarm to create cross-platform alarm apps
    • iOS and Android HMI Apps – Use PCL for Android and iOS to create iOS and Android applications for live data.
    • Data Historian – With OAS Data HIstorian you can log data to SQL Server, Oracle, Access, mySQL, SQL Azure and CSV files.
    • Reports – With OAS Reports you can create reports from OAS data logging products or other databases. Generate reports as Word, Excel, PDF, HTML or Email.
    • Universal Driver Interface – Use C# or VB.NET to integrate your own data model into OAS for realtime data access.
    • Allen Bradley – Use the Allen Bradley IoT Driver to connect to ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5. Add Allen Bradley Data Historian to log data to industry standard databases.
    • Siemens – Use the Siemens IoT Driver to connect to S7-200, S7-300, S7-400, S7-1200, and S7-1500. Add Siemens Data Historian to log data to industry standard databases.
    • Modbus – Use the Modbus IoT Driver to connect to Modbus TCP, Modbus RTU, and Modbus ASCII all supported on Ethernet, RS-232 Serial, and RS-485 Serial. Add Modbus Data Historian to log data to industry standard databases.
    • MQTT – With the MQTT IoT Connector you can subscribe to MQTT Brokers.
    • Amazon Web Services – With the AWS IoT Gateway driver you can subscribe to AWS for live data updates.
    • Excel – Use the Excel Connector to use Microsoft Excel as data source
    • Industry Standard Databases – Use the Recipe Connector to connect to SQL Server, Oracle, Access, and mySQL databases
    • Industry Standard SCADA Systems – Use the Universal Data Connector to connect to Wonderware, WinCC, RSView and Cimplicty
    • OPC Client – Use the OPC Client Connector to connect to third party OPC Clients
    • OPC Servers – Connect to OPC UA and Classic OPC DA 2.0 and 3.0 OPC Servers. Use the OPC Tunnel Connector to automatically transfer data from any Data Source to third party OPC Server or OAS IoT Driver.
    • Microsoft Azure – Use the SQL Azure Data Logging and SQL Azure Alarm Logging products to connect to Microsoft Azure SQL Databases
    • Microsoft Azure IoT Data Hub – Transfer any Data Source to Azure IoT Data Hub using the OPC Tunnel Connector
Posted on

How to Use a Database as a Data Source

This guide shows how to use a database as a data source in two easy steps. 

Transfer data from these
industry standard Databases:

  • SQL Server
  • SQL Server Desktop (MSDE)
  • Oracle
  • Access
  • mySQL
  • SQL ODBC

STEPS

Follow the links to the OAS Help articles:

Make sure Open Automation Software is installed and the OAS Service is running

Configure Database as data source and define target tags (Recipe)

SEE ALSO:

Posted on

How to Log OPTO Data to a Database

How to Log OPTO Data to a Database

Open Automation Software Tags can be defined to connect directly to OPTO controllers with the built in OPTO Driver Interfaces which support communications over Ethernet. This tutorial walks you though downloading and installing OAS, configuring an OPTO driver, configuring tags and logging them to a database. Supported databases include SQL Server, Oracle, Access, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, InfluxDB, MySQL and CSV files.

Step 1. Download and Install the Open Automation Software and Start the OAS Service

If you have not already done so, you will need to download and install the OAS platform.  Fully functional trial versions of the software are available for Windows, Windows IoT Core, Linux, Raspberry Pi and Docker on our downloads page.

On Windows run the downloaded Setup.exe file to install one or more of the Open Automation Software features. Select the default Typical installation if you are not sure what features to use or the Custom installation if you want to save disk space on the target system.  When prompted agree to the End User License Agreement to continue the installation.

For more detailed instructions and video tutorials, visit the installation guide for your system:
Windows Installation | Linux Installation | Raspberry Pi Installation | Dockers Installation

When the installation is finished the OAS Service Control application will appear.  Use this application to start the 4 Services. If this is the first time installing the software it will automatically enter Runtime with an example Tag Configuration.

Step 2. Configure Your OPTO Data Source

  1. First, you will need to open the Configure OAS application from the program group Open Automation Software.

  2. Select Configure >> License from the top menu and verify that OPTO is one of the available Drivers in the lower left of the form. The demo license will have this by default. If you do not see OPTO available, contact support@openautomationsoftware.com to update your license.

  3. Select Configure >> Drivers from the top menu.

  4. Select localhost or the remote service you wish to modify with the Select button to the right of the Network Node list.

  5. The Configure Drivers Screen will appear. Select OPTO from the Driver dropdown box.

  6. Enter a meaningful Driver Interface Name that you will refer to this physical connection when defining Tags with a OPTO Data Source.

  7. Define the properties for the desired physical connection.

  8. Click Add Driver at the the top of the left portion of the window.

For more detailed instructions on configuring your OPTO data source, click here to see our Getting Started OPTO tutorial.

Step 3. Configure Your Tags

OAS provides multiple ways to add and define tags:

To add a Tag manually:

  1. In the OAS Configure Application, select Configure >> Tags from the top menu.

  2. Select localhost or the remote service you wish to modify with the Select button to the right of the Network Node list.

  3. Click on the Add Tag button located at the top of the Tag browser on the left portion of the screen.

  4. A dialog box will appear. Enter a name for your new tag and click ok.

  5. A configuration screen will appear for your new tag. Select your data source type in in the Data Source dropdown box.

  6. Specify the correct data type in the Data Type dropdown box.

  7. Click Apply Changes at the bottom right of the window.

For more detailed instructions on configuring your tags, click here to see our Getting Started Tags tutorial.

Step 4. Configure Data Logging

  1. In the OAS Configure Application, select Configure >> Data Logging from the top menu.

  2. Select localhost or the remote service you wish to log data from with the Select button to the right of the Network Node list.

  3. A Logging Group screen will appear.

  4. In the Common Tab, you will determine your table format and type of logging you wish to implement.

  5. In the Tags Tab, you will select the tags you wish to log.

  6. In the Database Tab, you will select what type of database you will be logging to and enter the connection parameters. OAS can log to SQL Server, Oracle, Access, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, InfluxDB, and MySQL.

  7. If you wish to log to CSV, you would configure that in the CVS Logging tab.

For more detailed instructions on Configuring Data Logging, visit our Getting Started Data Logging tutorial or watch the video tutorial below:

  • 00:00 – Introduction
  • 01:30 – Getting Started
  • 03:00 – Continuous Logging
  • 04:15 – SQL Server
  • 06:25 – Save Changes
  • 07:00 – Continuous Narrow Logging
  • 09:30 – Event Driven
  • 11:20 – Handshake Confirmation
  • 12:45 – High Speed Logging
  • 15:00 – Log to Stored Procedure
  • 15:25 – Triggers
  • 16:30 – Event Narrow Logging
  • 18:00 – Timestamps
  • 20:30 – Snapshot Logging
  • 21:45 – Specific Time of Day Logging
  • 22:50 – Data Change Row Logging
  • 25:15 – Data Change Narrow Logging
  • 26:45 – Networking
  • 31:55 – Store and Forward
  • 37:30 – Disable Store and Forward
  • 40:15 – Update Records
  • 40:50 – Dynamic Server, Database, and Table
  • 41:10 – Automatic Deletion
  • 41:40 – CSV File Logging
  • 45:30 – Programmatic Interface
  • 46:45 – CSV Export / Import
  • 48:20 – One Click Automation
  • 52:20 – Transaction Logging
  • 54:25 – System Errors
  • 56:00 – Contact Us
  • 56:50 – Read Database Data