I’m using Provisioning Requisitions to define Oracle and Sql Server database nodes in opennms, and I need to set the category of the node based on the type of database eg, oracle, MSSQL, etc (potentially postgresql at a later date).
Currently the DBA’s are manually configuring the node category when they define the node, but I was wondering if it is possible to define a Foreign Source Requisition Policy to set a node category based on the class-name of the jdbc-data-source required to connect to that database node?
The service to use to monitor a particular database is selected when the node is defined. The applicable service will always be one that has a data-source defined, and that jdbc-data-source will always have a class-name of one of “oracle.jdbc.driver.OracleDriver” or “com.microsoft.sqlserver.jdbc.SQLServerDriver”. Is it possible to define a policy that can extract that info in order to automatically assign the correct Category?