How to connect a Siemens S7 1200 PLC to a SQL Server Database

[@99199678]

hi i want to ask you, in 4:35 the 10 milliseconds means the transmission speed of importing data from server ? if yes, do you know the speed of respberry card ?

[@BratPit]

It only means that PLC recalls cyclic interrupt every 10ms and executes instances (function blocks, functions) which are contained in this instance. Speed of data transmission is another concern here. Data after cyclic interrupt execution are being held in buffer and transmitted when communication processor is free to transmission. So, it's matter of amount of data which are being exchanged with other devices on the net. You can try to check using WireShark or other programs to analyze web traffic. Normally it's quite fast -> milliseconds.

[@MiguelGomez-rc7ou]

HI, Great Video!!! Is possible to try this SQL Connection with PLC SIM? Thanks!!!

[@sql4automation584]

Hi Miguel, thanks! Yes, as far as I know, it should be possible with PLC SIM Advanced. You can write as at [e-mail] if you run into problems.

[@JazlyHadhi]

Hi, Connector IP should be my laptop IP right? but its not showing my IP on the drop down list. i can see only the localhost

[@sql4automation584]

Hi, yes if you want to connect a PLC to the connector you would need the IP of the interface which is in the same network as the PLC. Maybe you could check your network adapter settings. Please write us at [e-mail] if you need more help. :)

[@yassinexm-n9r]

I wonder if it possible to autoconnect everytime the software is opened

[@sql4automation584]

Hi! You mean that the config tool automatically connects to the last known connector service? The service runs on its own automatically, so you only need the config tool to initially set up the connections or change settings.

[@yassinexm-n9r]

@@sql4automation584 Yes i Discovered that lately thanks for the answer it works good

[@michelepaiardi5983]

Hello, to make S71200 and the SQL Database communicate, do you need the S4A Query Tool software?

[@sql4automation584]

Hi, when using our software, the S4A Connector and S4A Config Tool are enough. The S4A Query Tool and S4A Debugger are just usefool tools when developing the application.

[@michelepaiardi5983]

@@sql4automation584 Ok thanks for restoring me.

[@mathankumard378]

hi, this video is very useful to us. is it possible to connect SQL database using S7300 like this way??

[@sql4automation584]

Hi, that's nice to hear! :) Yes that should be possible. You can download all the required files from our website and test it out: www.sql4automation.com/en/compatibility/supported-controllers/detail/sql-database-connector-plc-siemens-s7.php

[@minhhieunguyen3484]

Excuse me! Can i use this program to connect phpmysql?

[@praveenajai9588]

Hi Can I get for abb plc also like this method?

[@sql4automation584]

Hi, we have libraries for AC500 PLCs. Please write us at [e-mail] if you need more information or do have a different PLC.

[@waqaryousaf3207]

Can i any trigger any value from sql database to plc Kindky help me

[@sql4automation584]

Yes you need to write a program in the PLC which continuously reads out / "SELECT"s values from the database. So when the value in the database changes, the PLC will read that new value. If you're using Siemens you'll find examples on how to do that in our example project. It comes included with the SQL4automation download on our website.

[@MightyAutomation]

Great video please share link for Rockwell sample project

[@leakersshakh9317]

Can you send the example project with tia V16? I want it very very important

[@sql4automation584]

Can you send us an email to [e-mail]? It should be possible to upgrade the version you downloaded to V16, when you open it. But we can send it to you.

[@kunalparihar8665]

The video is very interesting I have a question how do you connect a physical plc to an SQL database

[@sql4automation584]

Hi Kunal, thank you! In the following video you can see an example setup: kzbin.info/www/bejne/fIbMZZynr5iDpJo You can also find more information about it on our website: www.sql4automation.com/en/functionality/index.php

[@DungLe-wy5xk]

Hello, I want to connect TwinCAT 3 to a SQL server database. Can you help me, please?

[@sql4automation584]

Hi, can you please send an email to '[e-mail]'? Thank you

[@tranvandao1998]

how to add sql4siment into TIA

[@lexobsm]

Hi, Really Nice video ! I'm asking if plc program can also update his variables from this SQL database ?

[@sql4automation584]

Hi, thank you! Yes that's definitely possible. You can see how it works in the "Select"-Example also shown in this video around 7:00

[@storyofdivine9970]

How to connect mysql to scada

[@jorgematassanz5169]

Hi I have downloaded the example project, however when I try to open it up from TIA Portal V11 it doesn´t show up (SQL4S7-1200-TIA.ap13) Is it because there are different versions? What can I do?

[@sql4automation584]

Hi Jorge Yes the project is written for the TIA Portal Version 13. So you would need at least that version or something more recent. I would recommend you upgrade your TIA-Portal to a newer version. I'm afraid we don't support older versions than 13.

[@DP0190]

Hello, your S4A Config, SQL Server Management studio and TIA Portal are all inside Virtual Machine???. Can you provide an Email, I have some questions. Thanks

[@sql4automation584]

Hi Dino, yes in this example I had them running in a VM. But you could easily install the programs on different devices in the same network. You can write us at [e-mail]

[@guruchordiya3416]

Do i need physical plc for checking example???

[@sql4automation584]

Hi GURU, if you want to test with Siemens you'll need a physical PLC or a SoftPLC from Siemens, as far as I know. But we also support many other PLCs if the type doesn't matter to you. You could for example use Codesys.

[@frankchristiansen2585]

Does this work with TIA simulator?

[@sql4automation584]

Hi Frank, you would need the PLCSIM Advanced. But I think you can download a trial version of it and test it for 21 days.

[@MightyAutomation]

Upload video for Rockwell plc

[@anomanderrake3778]

The company is still working?

[@sql4automation584]

Yes, just not creating new videos at the moment. If you have questions you can also write as at [e-mail].

[@storyofdivine9970]

Can you help me

[@vuduyphuong2327]

Hello, I try to setup wHardwareID but when I open obCyclicInterrupt DB it don't have wHardwareID, so I see Example Project different video project. Can you send project that You used in this video to me? Thank you very much!

[@vuduyphuong2327]

My email is [e-mail]

[@byoel]

와우..