Posted 17 Jan 2008 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
Posted 17 Jan 2008 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
Posted 17 Jan 2008 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
Posted 18 Jan 2008 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
Posted 23 Jan 2008 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
Posted 23 Jan 2008 (edited) 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 23 Jan 2008 by Gambit Share this post Link to post Share on other sites
Posted 23 Jan 2008 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
Posted 9 Sep 2011 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
Posted 21 Sep 2011 (edited) 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 21 Sep 2011 by Nathan Share this post Link to post Share on other sites
Posted 13 Mar 2018 @Gambit, will you send me some examples about connection QJ71MES96 to MySQL regards Freddy Share this post Link to post Share on other sites
Posted 13 Mar 2018 @Gambit, will you send me some examples about connection QJ71MES96 to MySQL regards Freddy Share this post Link to post Share on other sites
Posted 3 Jul 2018 Red Lion speak directly to a SQL database Share this post Link to post Share on other sites