PLC to SQL

wmorgan

Member
W
Join Date
Mar 2018
Location
Monterrey
Posts
2
Hello.

Is anyone familiar with open source projects of PLC data logging?

Basically what I'm looking for is to register/migrate all PLC data to a sql database for analysis and reporting using python, c# or what other progamming language is available.

Thank you so much in advance.
 
If you are planning on doing the reporting yourself in Python/C#, it is perhaps less of a stretch for you to start off from a comms driver and write the code to log the data to SQL.
 
Python already has an example of how to store MQTT data into an SQL database. There is all kinds of "Report Writers" available for sql databases.

You would probably just need the MQTT driver for the type of PLC your using.

Kepware or OpenAutomation, either one I believe have these drivers.
 
Is there a specific database engine you're required to work with? Depending on the database as well as the system it runs on you might run into limitations, and certain databases might run better with different platforms and languages...
 
What component/components do you require to be open source. The entire thing?

1. Does "sql" mean MS SQL Server?
2. Do you have existing SQL instances in place?
3. Do you require open source comms drivers?
4. What collection of PLCs do you have?
5. Do you require open source middleware? Open source C#?
 

Similar Topics

J
Allen Bradley Micro820 PLC data logging to sql server
Hi everyone, I have a small project where I need to use plc to get sensor data and log them to an sql server locally or remote. I have found...
Replies
7
Views
2,804
drbitboy
drbitboy
D
WAGO PLC e!****pit - Connect to multiple MySQL databases
Hi all, I'm trying to connect my WAGO PLC to multiple databases. It is currently connected to a single MySQL database using the library...
Replies
0
Views
921
Dobby33
D
U
SQL Query to get 1 value to a C# application for forwarding to the PLC
Hi, I have a question about SQL. This question is a little to much on the IT side I suppose, but I will give it a try anyway as I do not have an...
Replies
6
Views
2,512
BachPhi
BachPhi
W
How to Query/Store Compact/Control Logix PLC Data to a SQL Database
Hello, For my general information and knowledge, how is querying and storing data from a AB PLC (Compact or Control Logix) typically...
2
Replies
15
Views
7,362
rudl
R
T
Getting Data from SQL Database to the PLC
Hello Eveyone, I need your advice on one problem.I am using CompactLogix PLC.I am looking for some ways.So, that a PLC program can read data from...
2
Replies
26
Views
13,247
igorf
I
Back
Top Bottom