Node-RED SQL Database Spreadsheet Connection
We will now look at the connection to our SQL database using a spreadsheet application. Previously we used Node-RED to communicate Modbus TCP and RTU to our Click PLC and Solo Temperature Controller. The information collected from the controllers was then put into an SQLite SQL database.
Spreadsheets like Excel are great for analysis of the data. We will be connecting to our SQLite SQL database with W spreadsheets. This will be accomplished by using an ODBC driver as the translator between the database and spreadsheet. Let’s get started.
More information can be obtained at our website. This includes all of the links mentioned in this video.
https://accautomation.ca/node-red-sql-database-spreadsheet-connection/
There are several reasons why we are using Node-RED. Here are just a few.
- Built on top of the most dependable programming language JavaScript.
- JavaScript is flexible and easy to work with on web browsers, server-side, IoT, IIoT projects, and more.
- Visual flow type interface making programming easy.
- Node will allow JavaScript code to run directly on a computer.
- Node-RED is a free, open-source logic engine.
- Connect to PLC, PAC, Temperature Controllers, Process Controllers using standard protocols.
- Save and read from databases
- Easily make the Internet of Things (IoT, IIoT) industrial solutions.
Node-RED provides the ability for you to quickly create custom control solutions.
-
2:28:50
WeAreChange
8 hours agoDiddy Foreknowledge Surfaces! All UNRAVELING Now In Hollywood?!
87.4K31 -
1:20:48
Michael Franzese
1 day agoDemocrat's Message: "Who will rid us of Trump?" | Michael Franzese LIVE! Ep. 20
64.9K193 -
1:06:31
Josh Pate's College Football Show
7 hours agoWeek 5 Predictions: UGA vs Alabama | OU vs Auburn | Big JP Poll Moves | Surprises & Disappointments
47.9K4 -
1:10:38
The Anthony Rogers Show
11 hours agoEpisode 241
18.9K2 -
54:45
LFA TV
1 day agoTargeting Donald Trump | Trumpet Daily 9.24.24 9PM EST
24.2K13 -
59:23
The StoneZONE with Roger Stone
7 hours agoFmr. FBI Agent Questions West Palm Attack On Trump | The StoneZONE w/ Roger Stone
35.1K14 -
1:10:30
Edge of Wonder
6 hours agoDiddy’s Downfall: How the Power of Music Can Be Weaponized
34.4K11 -
21:09
Breaking Points
12 hours ago100% DROP In Afghan Opium: How CIA Propped Up Drug Trade For Years
42.5K18 -
10:02
Tundra Tactical
10 hours agoIs Hollywood Behind The 2nd Trump Assassination Attempt?
30.9K7 -
1:32:56
The Big Mig™
8 hours agoUnite Don’t Divide w/ Rage Against The War Machine
50.9K12