如何将PLC Rockwell Logix控制器连接到SQL数据库 [英] How do I connect a PLC Rockwell Logix Controller into a SQL Database

问题描述

我需要从Rockwell（Allen Bradley）PLC读取一些信息到SQL Server数据库并执行一些报告功能。



有人帮我从PLC读取数据



PLC：Control / Compact Logix

通信：TCP / IP

操作系统：Windows XP SP3

Visual Studio 2010 Ultimate

SQL Server 2008



在此先感谢，

Thiyaga。

Hi,

I need to Read some information from a Rockwell ( Allen Bradley) PLC to the SQL Server Database and perform some reporting functions.

Could someone help me in Reading the Data from the PLC

PLC: Control/ Compact Logix
Communication: TCP/IP
OS: Windows XP SP3
Visual Studio 2010 Ultimate
SQL Server 2008

Thanks in Advance,
Thiyaga.

推荐答案

从AdvancedHMI开始。它可以让您轻松地从PLC获取数据。然后你可以编写一些VB代码将它存储在一个数据库中。

Start with AdvancedHMI. It will let you get the data from the PLC very easily. Then you can write some VB code to store it in a database.

请看我对这个问题的评论：你的需求过于模糊;这里没有什么可讨论的。



也许，首先要学习的是：停止将所有东西混合在一起。你需要一些单独的层或者也可能是一些不同的层（不要混淆它们）：

http://en.wikipedia.org/wiki/Layer_%28object-oriented_design%29 [ ^ ]，

http://en.wikipedia.org/wiki/Data_access_layer [ ^ ]（这是您的数据库所在的位置），

http：// en .wikipedia.org / wiki /多层 [ ^ ]。



您的数据库应位于数据访问层中，这可能会也可能不会在单独的层上实施。同样地，您将需要一个单独的层来进行数据采集或硬件控制，或者您的硬件无论如何。



在您的情况下，根据您的问题判断，它看起来像你真的需要至少能够分析问题和要求以及定义架构的人。或者你应该学到很多东西，成为这样的人。 :-)

-SA

Please see my comment to the question: your needs are formulated too vaguely; there is nothing much to discuss here.

Perhaps, first thing to learn is: stop mixing all things together. You need some separate layers or maybe also some different tiers (don't mix them up):
http://en.wikipedia.org/wiki/Layer_%28object-oriented_design%29[^],
http://en.wikipedia.org/wiki/Data_access_layer[^] (this is where your database could be),
http://en.wikipedia.org/wiki/Multi-tier[^].

Your database should be in a data access layer, which may or may not be implemented on a separate tier. Likewise, you will need a separate layer for data acquisition, or hardware control, or whatever your hardware does.

In your case, judging by your question, it looks like you really need at least person capable of analysis of the problems and requirements and defining of the architecture. Or you should learn a lot and become such a person. :-)

—SA

使用OPCDA / OPCUA服务器自己写一个服务来读取您需要的数据。



还有DataLogger可用 - 但根据您的需要，您可以编写自己的服务器来读取和写入值..

Use OPCDA / OPCUA Server Write yourself a service to Read the data you want when you need it.

There are also DataLoggers available - but depending on your need you can write your own server to read and write values..

这篇关于如何将PLC Rockwell Logix控制器连接到SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！