# Automatic IOT data collection by FTP **URL:** \ **Category:** General Discussion\ **Created:** [February 2, 2018, 7:04am UTC](https://forum.inductiveautomation.com/t/automatic-iot-data-collection-by-ftp/16845 "2018-02-02T07:04:50Z")\ **Posts on this page:** 1\ **Showing post:** 19
**Author:** ![R.Alamsha](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\ **Post date:** [May 24, 2018, 12:00pm UTC](https://forum.inductiveautomation.com/t/automatic-iot-data-collection-by-ftp/16845/19 "2018-05-24T12:00:39Z")
> [@craigb](#): > > So for example I use MQTT for live data of a machine. As we dont have a guaranteed connection due to using a cell service all data for Audit and Data logs is stored to a local SQL instance, then synced once a connection is available. 1. Where's the local SQL instance at the remote RTU?. 2. How the RTU csv datalogs will be transferred to the local SQL?. 3. RTU can be configured to retry, say every 3 minutes, in the event of FTP delivery failure. This feature is available by default in any RTU which is designed to deliver data by FTP. 4. In the CCC. the FTP files are automatically imported into the SCADA SQL historian database. > [@Ignition Edge Store and Forward](http://forum.inductiveautomation.com/t/ignition-edge-store-and-forward/15645/27): > > I have forgotten to mention this point. The main reason for avoiding internet based automation for remote sites is, every site needs an IP address. VPN routers can help but again automating this process for 1000’s of sites from CCC needs a very reliable VPN service provider which is very expensive. Where as, a private mobile network data channel gives private IP by default, deployment is very fast, 100% secured and connectivity is instantaneous. No need for any VPN router or Dynamic DNS. Downsi… --- _[View the full topic](https://forum.inductiveautomation.com/t/automatic-iot-data-collection-by-ftp/16845)._