I’m new to ignition.
Our automation system runs by pulling “recipes” from a MySQL database hosted through HostGator. The recipes are created through our website. Each recipe will only be used once by the system. After the recipe is run by the PLC we need ignition to execute a script to determine and pull new data from the database updating the tags so the next recipe can be run. We only need the back-end functionality of Ignition.
1.) I need to add the proper permissions in HostGator so that the Ignition server may always access the database. Where do I find the dedicated IP address of my Ignition server so that the connection is always valid and does not fault each time my PC’s dynamic IP address changes?
2.) It seems that the transaction groups in the SQL bridge are the best solution. But I’m not sure. Would Gateway Scripts be better, or is there another better option?