Reference Guide
...
Device Management
Device Inventory
External Device Database Integration for Devices
1min
The external device database import configurations allow Kron PAM to automatically detect and discover instances for the relevant Device Groups, based on their custom tags.
The following configuration is required to add/discover devices from external device databases.
Navigate to Administration > System Configuration Man. and set the following parameters:
Parameter Name | Parameter Value | Encryption |
|---|---|---|
device.database.driver_n | Database driver for external database connection. Ex.: device.database.driver_0 = org.postgresql.Driverdev | |
device.database.password_n | External database password. | must be set as yes |
device.database.source | Database IP addresses. Multiple values must be separated by “;”. Ex.: 10.10.10.10;20.20.20.20 | |
device.database.sql_n | SQL Query to import devices. IP address, hostname, element type specifier, and one of the tag values are mandatory. Ex.: device.database.sql_0 = SELECT dynName AS IP_ADDRESS, server AS HOSTNAME, os AS ELEMENT_TYPE_SPECIFIER , id AS PORT, os as TAG_OS, site as TAG_SITE FROM device database. | |
device.database.url_n | JDBC URL address for database connection. E.g: device.database.url_0 = jdbc:postgresql://10.10.10.10:5432/databasename | |
device.database.user_n | External database username. | |