---
title: Configurations on the System Config Manager
slug: reference-guide-3-0-0/configurations-on-the-system-config-manager
description: Learn how to configure essential parameters in the "System Config Man" section of the Administration page. Set up the database driver, password, IP addresses, SQL query format, JDBC URL address, and username for seamless connection to an external database
docTags:
createdAt: 2022-08-03T09:32:34.000Z
---
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, 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. | |