I have a Raspberry Pi that is pulling data from a SMA Solar inverter and storing it in a SQLite database every (1) minute. I want to use Node-Red to copy/sync that data up to a SQL Server I have in Azure.
I have my flow configured and can read the data from SQLite and I also have my connection to Azure SQL working. My issue or lack of knowledge is how do I take that data and insert it into SQL?
If its a Function what do I need in the function? Do I write the insert query in the SQL_Azure node? I am playing around with everything for the past few days and just can't get it. Any help would be so grateful.
Node-Red Version: v0.20.5
SQLite Version: 18.104.22.168
SQL Server Version: 2016