Total noob incoming. I stumbled upon this reddit and I guess it wouldn't hurt to ask...

Context: We have a business partner that does electrical and automation on the machinery we deliver. For customers that want PLC installed he uses SCADA to program the machinery. I have very little knowledge about PLCs at the moment.

​

I want to develop a web/mobile app that:

• Allows the customer to check machine data ( hours used, running or not .. and other data based on installed sensors ). Not real time view.
• Remote access to the interface.
• Other stuff like sending notifications when certain parameters are met (but this is not related to the question).

I can deal with the app development, the only thing I need to solve is getting the data from the PLC into a format that I can use ( i.e SQL Database ).

​

I will have this conversation with our partner but I'd like to do some research before so I can present my plan clearly. What should I need to know about this? Can SCADA export to SQL? Is there a lot of programming to be done in the PLC before it can send to SQL ?