---
title: Adding a Database as a Device
slug: singleconnect-reference-guide-3-3-0/adding-a-database-as-a-device
description: Learn how to configure and add a database device to your target database with this step-by-step guide. Discover how to navigate to the Device Inventory menu, enter essential details such as IP address and access protocol, and easily add the device. Find o
docTags: 
createdAt: 2022-08-01T16:22:51.000Z
---

The target database is configured as a device:

1. Navigate to **Device Management** **> Device Inventory** menu.
2. Click the **New Device Discovery** button.
3. Enter the IP address, port (if not set, the default port is used according to the access protocol), and the access protocol, and select the Device Group for the assigned device should be in.
4. Click the **Discover** and **Add **button.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/TMGnlnI0ut7-flSkJC-q__image.png "Adding Database")

The port number is the identifier of the connection to ORACLE, MSSQL, MySQL and Cassandra, Teradata, Hive, PostgreSQL, and DB2 via a Single Connect SQL Proxy. The port number must be defined in the Device Properties of the MSSQL, MySQL and 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 Man**.
2. 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. 6000-7000) |

1. Navigate to** Device Management** > **Device Inventory**.
2. Right-click the defined database device and select **Show properties**.
3. Set the **sql.proxy.bind.port** property.
4. Click the **Auto Assign** button.

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/GJapTejkECAAonedwGpSW_image.png" size="68" width="576" height="194" caption="SQL Proxy Bind Port" position="center" showCaption="true"}

:::hint{type="info"}
Multiple bind ports can be added using a comma “,” without a space to separate them.
Ex: 4042,4141,1313
:::