Problem
We're looking for a mechanism that allows us to automate rotation of JDBC credentials across many gateways
Background
We have a large fleet of Ignition gateways. We're working on adding JDBC connections from each of these gateways to ClickHouse databases. The ClickHouse JDBC connections require username/password credentials for a windows AD service account. Those service account creds expire every year and must be rotated. Without automation, this requires manually logging into many gateways and pasting in the updated creds
Progress Made
We spoke about this issue with the IA sales engineering team, who suggested we may be able to explore using gateway scripting to access the SDK and gateway context. In turn that may be able to expose an ability to rotate the JDBC creds
Question
Has anyone automated rotation of their JDBC creds before? Are there any good examples of using the gateway context in python scripting?
Thanks for taking a look!