I currently have two Ignition gateways: an edge gateway to interface with many remote PLCs, and a cloud gateway with perspective for building views, etc. The edge gateway acts as a remote tag provider to the cloud gateway. I also have some organizational/admin information in a postgres db.
In trying to build out the UDT to describe a piece of equipment, I'm running into the problem that I can access the PLC tags from the remote (edge) tag provider, and can access the database from a separate tag provider on the cloud, but I have no way of accessing both and combining into one UDT. For example, I have pump speed from the edge tag provider, and pump name and location from the database. Is there a way to combine tag providers? Alternatively, I'd be happy to use query tags in the edge tag provider, but it can't 'see' the db.
The workaround I'm currently using is to run a db query on a schedule and save the result to a dataset tag. I then use expression tags in the UDT to look up the equipment name, location, etc from the dataset tag. Can anyone see any major drawbacks from this approach?
Thanks!