Hi, I want to automatically insert data into a database I have during certain times. Is this possible? For example, at 9am everyday, I want it to insert a new row with certain values into my power table.
That is exactly what the SQL Bridge module and Transaction Groups are for. Or alternatively scripting the data into the database from a gateway event.
You would use them to insert the data, and then have the PowerTable refresh on a schedule, or have a tag that triggers a refresh on the table.
2 Likes