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.
-
1:21:08
Awaken With JP
5 hours agoUnburdening What Has Been - LIES Ep 58
54.1K54 -
1:02:16
In The Litter Box w/ Jewels & Catturd
21 hours agoDems Imploding! | In the Litter Box w/ Jewels & Catturd – Ep. 653 – 9/24/2024
51.6K33 -
1:57:58
Revenge of the Cis
3 hours agoEpisode 1380: Baddie Alert
19.7K4 -
3:19:39
PudgeTV
16 hours ago🟡 Practical Pudge Ep 40 | Public Square CFO - Brad Searle | Building the Parallel Economy
22.9K2 -
2:57:15
Due Dissidence
8 hours agoZelensky Visits US Weapons Plant, Israel HITS Lebanon, 'Rage Against War' Returns -w/Angela McArdle
35K16 -
1:36:58
The Quartering
6 hours ago3rd Assassination Attempt On Trump, Golf Course Assassin Son ARRESTED & SUSPICIOUS Connection Found
70.6K40 -
1:26:45
vivafrei
6 hours agoDid Elon Buckle to Brazil's Judge de Moraes? Democrats Back to Dogwhistling for Violence! Viva Frei
85.4K80 -
2:04:17
The Dilley Show
6 hours ago $8.05 earnedAre Pedos Trying to Stop Trump? w/Author Brenden Dilley 09/24/2024
46.8K25 -
1:09:03
TheMonicaCrowleyPodcast
3 hours agoThe Monica Crowley Podcast: Americans Forgotten No More
22.2K5 -
Mally_Mouse
22 hours agoLet's Play!! -- EPIC MICKEY: REBRUSHED
21.4K