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.
- 	
				 LIVE LIVENerdrotic5 hours ago $5.48 earnedThe WitcHER DOA | Box Office Massacre | Massive Industry Layoffs - Friday Night Tights 3781,362 watching
- 	
				 14:54 14:54IsaacButterfield13 hours ago $0.95 earnedShe Called Out “Creepy Men It Didn’t End Well12.8K33
- 	
				 LIVE LIVELFA TV21 hours agoLIVE & BREAKING NEWS! | FRIDAY 10/31/25683 watching
- 	
				 1:08:42 1:08:42vivafrei4 hours agoEric Swalwell in Trouble Again? RFK Jr. "Reverses Course" on Tylenol & Autism? Arctic Frost & MORE!76K27
- 	
				 1:19:51 1:19:51DeVory Darkins5 hours agoNewsom EXPOSED after latest bombshell and Democrats pulls shocking stunt regarding shutdown75.8K37
- 	
				 25:29 25:29Stephen Gardner4 hours ago💣 Trump White House UNEXPECTED Move + Thune DESTROYS Schumer on Senate Floor!!32.8K30
- 	
				  Drew Hernandez15 hours agoSPOOKY WOKE HAG CALLS FOR DEMS TO EMBRACE CELEBRATING EXECUTION OF CHARLIE KIRK?!19.1K11
- 	
				![MAHA News [10.31] - HHS Coup, Big Food Documentary, SNAP Scams, Microplastic Solutions](https://1a-1791.com/video/fwe2/d9/s8/1/w/q/m/v/wqmvz.0kob-small-MAHA-News-10.31.jpg) 1:28:13 1:28:13Badlands Media17 hours agoMAHA News [10.31] - HHS Coup, Big Food Documentary, SNAP Scams, Microplastic Solutions26.3K10
- 	
				 1:10:12 1:10:12The Quartering5 hours agoFood Wars Begin! Terror Plot Foiled & Much More!90.8K35
- 	
				 1:09:50 1:09:50The Culture War with Tim Pool6 hours agoJamaica Hurricane Predicts POLE SHIFT, The END Is Nigh | The Culture War with Tim Pool145K117