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.
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 info@inasoft.ch if you need more help. :)
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.
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 ?
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.
Can you send us an email to info@inasoft.ch? It should be possible to upgrade the version you downloaded to V16, when you open it. But we can send it to you.
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.
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.
Hi Kunal, thank you! In the following video you can see an example setup: ruclips.net/video/FUi4iqz3Pn8/видео.html You can also find more information about it on our website: www.sql4automation.com/en/functionality/index.php
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
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?
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.
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
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 info@inasoft.ch
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!
![COM13b. [2/5]V11 Connecting a Siemens PLC(S7-1200/S7-1500) to an SQL Database [PLC Section]](/img/1.gif)
I wonder if it possible to autoconnect everytime the software is opened
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.
@@sql4automation584 Yes i Discovered that lately thanks for the answer it works good
Excuse me! Can i use this program to connect phpmysql?
how to add sql4siment into TIA
Hi Can I get for abb plc also like this method?
Hi, we have libraries for AC500 PLCs. Please write us at info@inasoft.ch if you need more information or do have a different PLC.
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
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 info@inasoft.ch if you need more help. :)
How to connect mysql to scada
Can i any trigger any value from sql database to plc
Kindky help me
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.
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 ?
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.
Can you send the example project with tia V16?
I want it very very important
Can you send us an email to info@inasoft.ch? It should be possible to upgrade the version you downloaded to V16, when you open it. But we can send it to you.
Great video please share link for Rockwell sample project
Hello, to make S71200 and the SQL Database communicate, do you need the S4A Query Tool software?
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.
@@sql4automation584
Ok thanks for restoring me.
Upload video for Rockwell plc
Hello, I want to connect TwinCAT 3 to a SQL server database. Can you help me, please?
Hi, can you please send an email to 'info@inasoft.ch'? Thank you
HI, Great Video!!!
Is possible to try this SQL Connection with PLC SIM?
Thanks!!!
Hi Miguel, thanks!
Yes, as far as I know, it should be possible with PLC SIM Advanced. You can write as at info@inasoft.ch if you run into problems.
Do i need physical plc for checking example???
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.
The video is very interesting
I have a question how do you connect a physical plc to an SQL database
Hi Kunal, thank you! In the following video you can see an example setup: ruclips.net/video/FUi4iqz3Pn8/видео.html You can also find more information about it on our website: www.sql4automation.com/en/functionality/index.php
hi, this video is very useful to us.
is it possible to connect SQL database using S7300 like this way??
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
Hi, Really Nice video !
I'm asking if plc program can also update his variables from this SQL database ?
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
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?
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.
The company is still working?
Yes, just not creating new videos at the moment. If you have questions you can also write as at info@inasoft.ch.
Does this work with TIA simulator?
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.
Can you help me
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
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 info@inasoft.ch
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!
My email is vuduy0129@gmail.com
와우..