---
title: Adding a Database as a Device
slug: kronpam-reference-guide-3-9-0/adding-a-database-as-a-device
docTags: 
createdAt: 2023-12-19T16:27:57.694Z
---

This section shows how to add one database to the Kron PAM.

:::hint{type="info"}
The port number is the identifier of the connection to ORACLE, MSSQL, MySQL and Cassandra, Teradata, Hive, PostgreSQL, and DB2 via a Kron PAM SQL Proxy. The port number must be defined in the Device Properties of the MSSQL, MySQL, Cassandra, Teradata, Hive, PostgreSQL, DB2, SAP Hana, and Couchbase databases.
:::

The following system configuration parameter should be set for the port assignment option:

1. Navigate to **Administration > System Config Manager.**
2. Click the +**Add** button. 
3. Inside the pop-up, select the **Add New System Parameter** button.
4. Set the **sql.proxy.bind.port.range** parameter with the requested port range.

| **Parameter Name**            | **Parameter Value**         |
| ----------------------------- | --------------------------- |
| **sql.proxy.bind.port.range** | Port range (e.g. 1025-2000) |

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/PGzpuFyftfoOib-dnH9IC_image.png "SQL Proxy Bind Port")

The target database is configured as a device:

1. Navigate to **Devices > Inventory.**
2. Click the +**Add **button. 
3. Inside the pop-up, select the **Add Device **button.
4. **Information**: Enter the following required information:
   a.	IP address
   b.	Device Name
   c.	Port (if not set, the default port is used according to the access protocol)
   d.	Access protocol (Oracle TNS, MSSQL, Postgres, etc.). When you select Access protocol, the following inputs will appear:

   e.	Element Type

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/aPxcN7Lj4VClxMspeoTOS_image.png "Database Device Addition / Group Membership Section")

- **Group Membership: **Enter your device group.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/iFPtETTRqrbceQW4JhVrW_image.png "Database Device Addition / Group Membership Section")

- **Properties, **click the Auto Assign (This will use the setup parameter of the system configuration manager guided earlier)
- Click the **Test Connection** button to test the connection information you provided.
- **Save.**

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/NM5JLUw-tpprmlI-SiYp9_image.png "Database Device Addition / SQL PROXY Bind Port in Properties Section")

Once the configurations are complete, to define a database, go to the options button of the device you defined.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/JDxnaPxLDI0XDZ_gweMwJ_image.png)

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/ZYTm4RnjoLnNITAyUqiPt_image.png "Database Device Credentials")

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/2Atk7CBrBZezJFJhCT326_image.png "Database Device Credentials")

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/dtD4Ts5QszNAe8cIFCAED_image.png "Database Device Properties")

When you select Access protocol, the following inputs will appear:

- **Database/Service Name: **This is the name of the database you want to connect to. It’s a unique identifier for the database on the server.
- **Username: **This is the username of the account you’re using to access the database. It must match the username created by the User. 
- **Database Password: **This is the password associated with the database username. It’s used to authenticate the user and grant access to the database.
- **Alias (optional): **This is an optional nickname you can give to the database connection (only in Oracle databases). It’s used to easily identify the database in the future without having to remember the specific database name.

Finally, you can click the **Test Connection** button to check whether the credentials are correct.