Skip navigation

Extend Scripting KM for DB Queries or create DB Query KM

score 20
You have not voted. Below Review Threshold

Situation

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.

 

Problem/Issue

In order to run DB queries through a Script, the according library or client has to be installed on the server.

 

Possible Solution

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.

Comments

Vote history