the Nano 33 IOT is to me the simpler and more affordable board with wifi and cloud connection.
I tested it on Arduino cloud with examples provided with IDE and it works perfectly.
this a functionnality from Arduino Cloud. But I dont tested yet.
For waht I remember, a dedicated sketch (like a library) is uploaded along with your code and allow uplodaing on the air.
I propose you to ask the Arduino Cloud wich will have good (better than mine) explanations
EDIT: and the internet access is driven through wifi only. Maybe I read your needs too quickly? You need a cable for internet in your config?
My first Arduino was an EtherTen by Freetronics. It is a Uno with Ethernet and SD built in. They also make an EtherMega. Both are expensive but the former gave me a good start. I think you are best off with a Mega and a W5100 Ethernet shield. This shield has an excellent SD slot included.
No comment on uploading new programmes. I think it is possible.
If the Arduino Cloud could do the upload to a board with an Ethernet port it would take the cake and I would buy right now.
However, as @Juraj mentioned, this functionality does not exist, currently, except for the Portenta board.
The Portenta is really cool. But also $350+ here in USA, so it starts to be come just as expensive as some of the industrial automation solutions I am looking to disrupt by using a less expensive Arduino.
Ultimately what I think I will do is use a Raspberry Pi 3 or 4 to be based right next to an Arduino board with Sensors. That way I can remote into the Pi, over LAN based Ethernet, and change the code, etc. I might even use the Pi for the whole project.
As Arduino starts to bump into more "Pro" worlds with the PLC options, Portenta, Opta, etc, I hope they will add the ability to upload code via an Ethernet port.
an idea. the IoT Cloud supports esp8266. and the esp8266 Arduino can use w5500 as network interface for the WiFi library. (well known network interfaces for the WiFi library are WiFi and SoftAP)
Do you think it would be better to store the data on the RPi SD card or store it on the Arduino?
I think it might be easier to have it on the RPi though this is my first data logging project so I may be missing some good design principles on a project like this.
I agree. But, since the Arduino Cloud does not play with Ethernet for some reason, it has therefore been established that using an RPi is the only way to remote upload new code so I am going with it.
Unless you meant it is overkill to read and store data to an SD card on the PI vs the Arduino?
Either way I have what I need to proceed and thank you for your input.
I must have missed something here - like what the "cloud" is. I don't see how Arduino's cloud can be hardware specific but, if it is, that is a compelling reason to use somebody else's that isn't.