Premium Only Content

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:43:56
Tundra Tactical
14 hours ago $46.85 earned🛑LIVE NOW!! FBI Gets Caught LYING About Good Guys With Guns For 10 YEARS!!!!
77K15 -
LIVE
LethalPnda
2 hours agoK-Pop Demon Hunters x Fortnite | Use code LETHALPNDA in the Item Shop!
53 watching -
2:12:01
BlackDiamondGunsandGear
2 days agoAFTER HOURS ARMORY / Antifa / Lies/ Prison time
45.4K4 -
2:12:00
DLDAfterDark
14 hours ago $20.18 earnedThe After Hours Armory! Tonight is The Chat's Chat! God, Guns, and Gear!
59.4K8 -
3:32:18
Mally_Mouse
17 hours ago🌶️ 🥵Spicy BITE Saturday!! 🥵🌶️- Let's Play: Phasmophobia
63.1K6 -
1:13:19
iCkEdMeL
13 hours ago $28.92 earnedChaos Explodes in Chicago & Portland | Feds Clash with Protesters!
67.4K45 -
21:54
Exploring With Nug
1 day ago $11.50 earnedScuba Diving Missing Person Search Leads to Discovery of Classic Cars!
77K20 -
1:19:51
World2Briggs
16 hours ago $2.88 earnedThe US This Week
40.5K8 -
2:31:13
Joker Effect
13 hours ago"MAKE STREAMING GREAT AGAIN" - Brands Step Up Finally. Birth of Rumble Community. Taking Leadership
25.6K5 -
5:02:17
Illyes Jr Gaming
16 hours ago"Machine Gun" Takes On BLACK OPS 7 Beta DAY 3!!!
16.4K