ctrlX CORE connection with Microsoft Azure, SQL database and display with the App IoT Dashboard

This video explains how to pass data to Microsoft Azure cloud services from the ctrlX CORE. Store the data in a cloud-based SQL database, query data from a SQL database and display the data in a web-based dashboard. The ctrlX App IoT Dashboard is used in this example. Software and Apps Used: - Node-RED app - IoT Dashboard app - Azure IoT Explorer - Microsoft SQL Server Management Studio • Video topics 00:09 Introduction 00:24 Overview and topology 01:16 Requirements: ctrlX hardware, Apps, cloud software 02:20 Microsoft Azure account and services - create a resource group 03:28 add service IoT Hub 04:43 add a device that corresponds to the ctrlX CORE 05:29 App Node Red - connecting to the in the ctrlX CORE - data layer subscription node, CPU utilization percent - setup Palette @ttrichar/node-red-contrib-azure-iot-hub - setup node Azure IoT Hub with protocol MQTT, connection string, etc. 12:20 verify data connection in Azure IoT Explorer preview 12:47 configure SQL Server database - create database - configure in Microsoft SQL Server Management Studio 19:20 add service Stream Analytics Job - add input from IoT Hub - add output - load existing tables - adjust the query for desired SQL database output - start the job - in SQL management software, verify the running job recording data CPU utilization percent 24:00 create a Web dashboard using the ctrlX App IoT Dashboard (Grafana) - chose data source in the configuration interface - build a dashboard - connect to the data table - explore IoT Dashboard functions 27:50 ctrlX Automation Community Visit ctrlX AUTOMATION at https://community.boschrexroth.com The online site to - become a member of the ctrlX AUTOMATION COMMUNITY - get quickly up to speed with online e-learning material - explore the many Apps in the ctrlX STORE - quickly find under How-To information (FAQs, Examples, Technotes and How-To) - use the Forum to post, interact and find solutions - access the product documentation download area - configure components and systems - go to the ctrlX AUTOMATION in GitHub Product documentation, go to https://bit.ly/39Kgx64 and search for “en ctrlX” Full playlist at: https://www.youtube.com/playlist?list=PLYFUPeujnKJVpft2-dvQzf9ZDTUA-exk- Follow @boschrexroth Bosch Rexroth Facebook: https://www.facebook.com/BoschRexrothUS Bosch Rexroth X: https://x.com/BoschRexrothUS Bosch Rexroth LinkedIn: https://www.linkedin.com/company/boschrexroth