Reference Guide
...
External Device Database Integ...
Configurations on the System Config Manager
1 min
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 for external database passwords, the value should be entered as cleartext 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 select ip address as ip address ,hostname as hostname,element type id as element type id ,dg level 1 ,dg level 2 ,dg level 3 ,dg level 4, dg level 5,port,access protocol from device table the query format is important, dg levels can be many, these columns define the tree structure 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