Hi, I have one query like do we have any possibilities to configure remote site Database instances through ignition views. any functions, any script to update the DB instances like managing tables, delete/update/modified the Queries, Stored procedures and all related stuffs.
You can certainly do this assuming a few things are available.
- The Ignition server your using has a JDBC connection to every database instance.
- The user has sufficient privileges to perform the level of manipulation.
Obviously there isn't a GUI interface similar to SSMS or Workbench, and you'd have to build that yourself.
The below functions would allow you to create/alter tables, create stored procedures, etc. You would have to know how to write the queries yourself.
https://docs.inductiveautomation.com/display/DOC81/system.db.runUpdateQuery
https://docs.inductiveautomation.com/display/DOC81/system.db.runPrepUpdate
2 Likes