A customer of ours has the following configuration:
Around 20 PLC's connected on the company network. Each installation has a Siemens HMI. Most of them have MP277 and MP377.
At the moment we are doing basic (step-)logging in these panels with datalogs to csv files on the MMC cards. The recipes are written by the WinCC Flex recipes and in some PLC's it's done by fixed DB's.
Regarding logging:
When they had a problem, they have to go to the HMI of that machine, take the MMC out, see what's in the CSV,... it's difficult te trace to the problem.
Regarding Recipes: Some use DB's some use the recipetool in WinCC Flex.
What they asked was a central place where everything is gathered together.
I did some tests with WinCC Flexible Scripting for reading and writing from and to a SQL database. This works.
I did some tests for reading and updating data from the same sql database in VB.net. This works. (PC RUNTIME !!!!!!!!)
What I'm thinking todo is:
1.
HMI's take their recipes from the SQL database, from the server. Donno if WinCE kan be connected thrue an ODBC source ??
So what I'm asking is, can an MP277 for example communicate with an SQL server ?
2.
PLC makes step transistions, what we do is mainly steplogging. Every step we write a record away. Same should happen to an SQL database, every stepchange the record is written to an SQL table. This can be done on a PC Runtime that will be used for trending and logging. This works, no worries here.
3.
The logged data from the step transistions is written in the SQL database.
There is query software on the web (Flyspeed SQL Query for example), but they asked if they can read the SQL tables in an Acces DB, because they know Acces very well. They can make their own querys like this.
Are there some of you that have done something similar ?
Regards,
Gerry
Around 20 PLC's connected on the company network. Each installation has a Siemens HMI. Most of them have MP277 and MP377.
At the moment we are doing basic (step-)logging in these panels with datalogs to csv files on the MMC cards. The recipes are written by the WinCC Flex recipes and in some PLC's it's done by fixed DB's.
Regarding logging:
When they had a problem, they have to go to the HMI of that machine, take the MMC out, see what's in the CSV,... it's difficult te trace to the problem.
Regarding Recipes: Some use DB's some use the recipetool in WinCC Flex.
What they asked was a central place where everything is gathered together.
I did some tests with WinCC Flexible Scripting for reading and writing from and to a SQL database. This works.
I did some tests for reading and updating data from the same sql database in VB.net. This works. (PC RUNTIME !!!!!!!!)
What I'm thinking todo is:
1.
HMI's take their recipes from the SQL database, from the server. Donno if WinCE kan be connected thrue an ODBC source ??
So what I'm asking is, can an MP277 for example communicate with an SQL server ?
2.
PLC makes step transistions, what we do is mainly steplogging. Every step we write a record away. Same should happen to an SQL database, every stepchange the record is written to an SQL table. This can be done on a PC Runtime that will be used for trending and logging. This works, no worries here.
3.
The logged data from the step transistions is written in the SQL database.
There is query software on the web (Flyspeed SQL Query for example), but they asked if they can read the SQL tables in an Acces DB, because they know Acces very well. They can make their own querys like this.
Are there some of you that have done something similar ?
Regards,
Gerry
Last edited: