---
title: External Device Database Integration for Devices
slug: kronpam-reference-guide-3-5-0/external-device-database-integration-for-devices
description: Learn how to configure Kron PAM for effortless device detection from external databases. This document offers detailed instructions for the necessary configurations. Discover how to export devices with SSH/Telnet or MSSQL access protocols into various for
docTags: 
createdAt: 2022-07-26T14:31:32.000Z
---

 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.

### Configurations on the System Configuration Manager

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. <br />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.&#xD; Ex.: device.database.sql\_0 =&#xD;<br />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. &#xD;<br />E.g: device.database.url\_0 = jdbc\:postgresql://10.10.10.10:5432/databasename&#xD;                                                                                                                                                                                    |                        |
| **device.database.user\_n**     | External database username.                                                                                                                                                                                                                                                                                                 |                        |