# OCS Inventory DB Adapter

## Connection Requirements

{% stepper %}
{% step %}

### IP

OCS Inventory DB located machines IP Address.
{% endstep %}

{% step %}

### Port

Port number (optional, default: 3306).
{% endstep %}

{% step %}

### Domain

Domain FQDN.
{% endstep %}

{% step %}

### Database

Base database.
{% endstep %}

{% step %}

### Username

Value provided username in MySQL server.

To create a User:

* Open MySQL Server Management Studio.
* Go to Management > Users and Privileges. Select the user you want to grant permissions
* Click Schema Privileges.
* Click Add Entry, select the database and click OK
* Check SELECT, under the Object Rights and click Apply and confirm.
* Login to the database with this user once to avoid an error.

> 🔵 **"Select"**\
> The user must have privilege.
> {% endstep %}

{% step %}

### Password

The Password of the provided username.
{% endstep %}

{% step %}

### View Name

The view name of OCS Inventory DB. (required).
{% endstep %}

{% step %}

### Custom Query

The custom query field for OCS Inventory DB. (optional).
{% endstep %}
{% endstepper %}

{% hint style="warning" %}
⚠️ **Attention**\
Please perform a **connection test** to ensure there is a valid connection to the host.\
When the discovery operation is finalized, you will be able to see the details on the **Assets** page.
{% endhint %}