The Scripting KM offers new possibilities. It allows to execute scripts.
There are requirements to run queries on databases. Today, the DB queries have to be scripted or KM from third party developers have to be used to execute queries against databases.
In order to run DB queries through a Script, the according library or client has to be installed on the server.
Either extend the Scripting KM for direct query execution against databases or create a similar KM for this purpose. The KM could leverage JDBC and either the JRE installed for the PATROL Agent or any JRE available on the system.