Sarnikorpi Posted March 3, 2011 Report Share Posted March 3, 2011 Hello, There are several "remote nodes" and each of them has couple of measurements. We would like to collect measurements to the database server (MS SQL Server) and make some reports etc. I was thinking of Vision PLC with GPRS modem. But how we could transfer data from PLC to database? .Net programming is not problem (if we should use Unitronics .Net driver), but is there any out-of-box solution? Quote Link to comment Share on other sites More sharing options...
External Moderators Nacho Posted April 4, 2011 External Moderators Report Share Posted April 4, 2011 I wonder if Unitronics is working in a FTP client for Vision. This way you could send datas from SD to a FTP Server. Other solution would be if Unitronics will develope a Server of remote datas, maybe only adding datas to My SQL database. This kind of applications is very usual last time. Quote Link to comment Share on other sites More sharing options...
DonM Posted May 23, 2011 Report Share Posted May 23, 2011 Hi Sarnikorpi, I'd suggest using software to log OPC data from the PLC to a Microsoft SQL Server database. I haven't done it myself, but it appears suitable. I googled: +opc +"microsoft sql" One of many relevant search results was: http://www.opcdatalogger.com/ Hope that helps, Don. Quote Link to comment Share on other sites More sharing options...
DonM Posted May 23, 2011 Report Share Posted May 23, 2011 Hello again, I successfully logged data to a Microsoft SQL Server 2008 Express Edition database using the trial edition of OPC Data Logger Pro available from: http://www.opclogger.com Note that I had to change my comptuters regional settings from "English (Australia)" to "English (United States)" to successfully log. Best regards, Don. Hi Sarnikorpi, I'd suggest using software to log OPC data from the PLC to a Microsoft SQL Server database. I haven't done it myself, but it appears suitable. I googled: +opc +"microsoft sql" One of many relevant search results was: http://www.opcdatalogger.com/ Hope that helps, Don. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.