A customer has several machines in his plant, with several PLC's.
The initial idea was to insert production data for each machine into a database table respectively.
For example:
Machine 1: You will insert data in the respective table, such as the average speed of the machine, quantity produced, downtime, among other data at each change of production order, this data is easily available from the machine's PLC.
Doubts:
How many PLC's can I connect with the same SQL Bridge license?
Is SQL Bridge really the best fit?
Transaction groups, do they need to be turned on every time I restart the computer they are installed on?
With the SQL Bridge license, can I create an application from the ignition designer, so that every time I lose connection or power outages, it automatically starts inserting data?
Initially, there are few values, I believe that approximately 200 int type tags, there is no need to be quick to insert, usually the production order changes that would be the trigger for insertion occur every 2~3 hours.
Fault codes are not needed now.
The Ignition Gateway runs as a service. Transaction groups run as part of this service. You do not need a Vision Client or Perspective session running in order for the TGs to execute.
Check with your IT on automatic service start. There are differences between Windows and Linux, but both are possible.
without the SQL Bridge Module ? the manual references transaction groups and a few other tools, but does not explicitly say anything about the system.db class
I currently a using various scripts to pull down data from 65 machines (eventually will be 100+) and insert the data in a DB via named queries without using the SQL Bridge module, even though I have it.
I have a two main types of queries. One is triggered via a GW timer event running a script, and inserts data into a database of real time values. The other is triggered from a tag change event and logs data to an archival DB at the finish of an instruction. This latter script is encapsulated in a UDT so that I only have to maintain one copy of it.
The only tricky part is that you have to have the correct context name in order to successfully call the named queries from some of the events (I think tag change, but I can't remember). This context name is simply the name of the project you are running under. I ended up hard coding it.
In my case, the sales guy sold us the SQL Bridge module because at the time we knew nothing about Ignition and we had no idea about the actual architecture we were going to implement. But in hindsight it was not needed.