Jump to content

Collect data from remote PLC to database server


Recommended Posts

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?

Link to comment
Share on other sites

  • 1 month later...
  • External Moderators

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.

Link to comment
Share on other sites

  • 1 month later...

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.

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...