External Device Database Integration for Devices

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 in order to add/discover devices from external device databases configurations on the system config manager navigate to administration > system config 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 device inventory export devices with ssh/telnet or mssql access protocols can be exported to be used in other clients ssh/telnet devices are exported in the securecrt client format mssql devices are exported in the sql server management client format to export devices in the supported format navigate to device management > device inventory click the export button at the bottom of the device group list two options are displayed after clicking the export button mssql export and securecrt export to export mssql devices, select mssql export and click ok an xml file is exported in the regsrvr format the exported file is imported to the registered servers field of the sql management studio client for easy usage when the kron pam ip address and the bind port related to the target mssql device are exported into the file, only the username and password are required to log in to export devices with ssh/telnet access protocol, select securecrt expor t select operating system and fill in the username field, then click ok a zip file is exported in the securecrt format to be imported to the sercurecrt client the kron pam ip, ssh proxy port, device ip, and the port are exported into the file during the connection from securecrt, only the username and password will be required