powwer

plc to mysql

12 posts in this topic

hi everybody, i want to build the system includes plc and mysql database. do you know any solution to send datas from plc to mysql without using any container program like visual basic,delphi.... thanks...

Share this post


Link to post
Share on other sites
Depending upon the device you are using Kepwares OPC server may be able to talk to it and you could then use the Kepware DataLogger to log data to MySQL. Fred Loveless Support Manager Kepware Technologies

Share this post


Link to post
Share on other sites
Check out FactorySQL. It does require an OPC Server. The full blown version will also do "transaction-y" things like RSSQL does, alarming, and a whole lot more. They're working on a free, strictly data logging version. You can download a resettable 2 hour trial here: http://forums.mrplc.com/index.php?autocom=downloads&showfile=758

Share this post


Link to post
Share on other sites
If you are using a Mitsubishi system Q there is a module called the QJ71MES96. It will connect to serveral databases and is very easy to program. It also has a FLASH card which will buffer the data when to connection to the database is lost. you can connecto it to ACESS MSDE oracle MS SQL servers etc. Also If you're not using a Mitusbishi PLC they've also included this feauture in there ethernetcard for there HMI panels which can connect to most PLC's.
1 person likes this

Share this post


Link to post
Share on other sites
Did you use MES module in a project? What do you think about it if you did?

Share this post


Link to post
Share on other sites
Actually I work for the Distributer of Mitsubishi in the netherlands. The module is fairly new so we haven't done many projects yet. The biggest project we have supplied has about 40 MES modules and is growing. so far everything is running fine wihtout any problems. Our customer is very happy wiht the module and was able to implement the MES in record time. You can't do stored procesures with them yet. Hopefully this will be improved in future versions. The best thing is it's so easy anyone can do it even if you do not have any SQL experience. Why not ask your distibuter for a Demo. Edited by Gambit

Share this post


Link to post
Share on other sites
The idea behind MES module is great. But i have working code that does the same thing on PC installed on sites. The lack of stored procedures is a con but it can be solved using triggers in the database i guess. Maybe i will use these modules in the future, we will see. I will play with them when i have some extra time, and one in my hand. By the way, i work for the Turkish distributer GTS ;)

Share this post


Link to post
Share on other sites
WAGO Ethernet PLC's can communicate directly with a MySQL database. It does not require any middleware like an OPC server or modbus driver. Here's a video tutorial showing how it's done. WAGO PLC's use a development software called CodeSys. I have many tutorials on this powerful IEC 61131 software on my youtube channel if you'de like to learn more.

Share this post


Link to post
Share on other sites
As an update, going the software route, the Ignition "SQL Bridge Limited" can log from pretty much any PLC to pretty much any SQL database. It runs $950 (current price list). The free OPC-UA server is responsible for the connection - it currently supports: Allen Bradley, Siemens, and Modbus. For other vendors you would have to get a 3rd party OPC server. You can try it out with a free trial version to make sure it works first. Edited by Nathan

Share this post


Link to post
Share on other sites

@Gambit, will you send me some examples about connection QJ71MES96 to MySQL

regards

Freddy

Share this post


Link to post
Share on other sites

@Gambit, will you send me some examples about connection QJ71MES96 to MySQL

regards

Freddy

Share this post


Link to post
Share on other sites

Red Lion speak directly to a SQL database

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now