Run your own SQL query directly from Rockwell PLC

[@alexnelson1687]

Thanks for this video! Do you have to use a transaction manager for this, or does the library you're using directly communicate to a SQL database due to some robust AOIs you have installed? I'm trying to communicate direct from a PLC to a DB. So far, Omron N series can do it, Keyence KV8000s can do it, but AB appears to require a transaction manager - which means I might as well just use an edge PC w/ a transaction manager built-in. For my scenario, we're trying to eliminate the edge PC by using direct PLC to DB comms, so this will knock out AB as a contender.

[@arcautomationconsultingltd6951]

Thank you Alex for your watching this video. Using the SQL Library for AB PLC I developed will eliminate the need of the middleware/software between your AB PLC and DB, its that simple. And from your brief description and if your PLC is AB then this library will do the trick. Here is my email if you would like to discuss further [e-mail]

[@ebiukulath5891]

Hey Younes, these are great tips to transact data directly to/from Logix PLC and MSSQL. Would you also share the logic in at least one Add-On Instruction? Excellent work!

[@arcautomationconsultingltd6951]

Ebiuku, thank you for watching. Unfortunately this library is not free. If you are interested in an AOI you can purchase it.

[@ebiukulath5891]

@@arcautomationconsultingltd6951 Thanks Younes. How much do you charge and do you accept credit or debit card payments?

[@arcautomationconsultingltd6951]

@@ebiukulath5891 you’re welcome. Please send email to [e-mail] and I will send you all the details. Thanks

[@deepkhanderia5270]

Hi I want these Logic Libraries, how can i get this? I can pay but whats the method for getting this?

[@arcautomationconsultingltd6951]

To get the library pricing email [e-mail]

[@krlosdeath666]

Hello ARC, good video and in fact I am interested in this type of solution, my only question is if it is necessary to use the AOIs that you developed or do I need something else (I have a controllogix L72s and EN2T card in my rack), if I only need the AOIs; How I can contact you?

[@arcautomationconsultingltd6951]

Hello, you just need the AOIs. You can send email to [e-mail]

[@utsavtrivedi9107]

Studio 5000 string has 82 characters limit so sql query should be with in 82 characters. Thanks for sharing this kind of video series. May we can get in future as well.👍

[@arcautomationconsultingltd6951]

Thank you for watching. 82 is only the default ..you can have more characters if you would like.

[@imrichmorvay2227]

Is very nice i already know that just i dont know how to set up PLC logic? any help?

[@arcautomationconsultingltd6951]

Thank you for watching. You can buy the library if you would like.

[@bhanuprakash6630]

What is the mail ID?

[@arcautomationconsultingltd6951]

[e-mail]

[@SCADAExperts]

Read write from SQL possible?

[@arcautomationconsultingltd6951]

Yes, read and write from the PLC to MS-SQL is possible.

[@petertiagunov5666]

Stored procedures support?

[@arcautomationconsultingltd6951]

I didn’t test to run stored procedures but I believe it could be done.

[@arcautomationconsultingltd6951]

Peter, stored procedures are also supported yes. Thanks

[@shuaimr1538]

Hello, can you post the source code, can you learn it?

[@arcautomationconsultingltd6951]

This library is not free unfortunately.

[@jatindersingh1229]

hello,please share sample plc logic

[@arcautomationconsultingltd6951]

Unfortunately this library isn’t free.

[@OvershotTV]

Hello ARC, how can I contact you by email? Im very interested on it.

[@arcautomationconsultingltd6951]

Hello, you can send to
[e-mail]