> For the complete documentation index, see [llms.txt](https://docs.onum.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.onum.com/data-sinks/data-sink-integrations/send-data-to-your-databases.md).

# Send data to your databases

{% hint style="info" %}
See the changelog of this Data sink type [here](/data-sinks-changelog/relational-databases-data-sink.md).
{% endhint %}

## Overview

Onum supports integration with your relational databases.

A relational database is a type of database that organizes data into tables with predefined relationships between them, making it easier to manage and access information.

## Onum Setup

{% stepper %}
{% step %}
Log in to your Onum tenant and click **Data Sinks> New Data sink**.
{% endstep %}

{% step %}
Double-click the **Relational Databases** Sink.
{% endstep %}

{% step %}
Enter a **Name** for the new Data Sink. Optionally, add a **Description** and some **Tags** to identify the Sink.
{% endstep %}

{% step %}
Decide whether or not to include this Data sink info in the metrics and graphs of the [**Home**](/home.md) area.
{% endstep %}

{% step %}
**Database Type**<mark style="color:red;">**\***</mark>&#x20;

Onum supports four types of databases:

* **MySql**
* **PostgresSql**
* **Oracle**
* **SqlServer**
  {% endstep %}

{% step %}
Specify where in this database to connect to and who to connect.

* **User**<mark style="color:red;">**\***</mark>
* Add the **Password**<mark style="color:red;">**\***</mark> from your list of [Secrets](/settings/organization-settings/secrets-management.md) or create one.
* The **Host**<mark style="color:red;">**\***</mark> URL for the database.
* The **Port**<mark style="color:red;">**\***</mark> to connect to.
* The name of the database you wish to store the results in.
  {% endstep %}

{% step %}
In the [Secrets](/settings/organization-settings/secrets-management.md) area, **New secret** to create a new one:

* Give the secret a **Name**.
* Turn off the **Expiration date** option.
* Click **Add new value** and paste the corresponding value.
* Click **Save**.

<figure><picture><source srcset="/files/NeeWsSQzoChVxRIY76Nt" media="(prefers-color-scheme: dark)"><img src="/files/1oTccyPmgZJ1laY7IhZH" alt=""></picture><figcaption></figcaption></figure>

{% hint style="info" %}
Learn more about secrets in Onum in [this article](/settings/organization-settings/secrets-management.md).
{% endhint %}

You can now select the created secrets in the configuration.
{% endstep %}

{% step %}
Specify the **Maximum requests per second**<mark style="color:red;">**\***</mark>. The minimum value is `1`, and the maximum value is `100`.
{% endstep %}

{% step %}
**Connection Pool Configuration**

* **Max Open Connections -** Enter a maximum for how many connections may be open at once (`0`-unlimited).
* **Max Idle Connections -** Enter a maximum for how many connections may be idle at once (`0`-unlimited).
* **Connection** **Max Idle Time -** Enter how many seconds a connection may be idle for (`0`-unlimited).
* **Connection** **Max Lifetime -** Add a limit to the connection lifetime (`0`-unlimited).
  {% endstep %}
  {% endstepper %}

Click **Finish** when complete. Your new Data sink will appear in the **Data sinks** area list.

## Pipeline configuration <a href="#output-configuration" id="output-configuration"></a>

When it comes to using this Data sink in a [Pipeline](https://docs.onum.com/the-workspace/pipelines), you must configure the following output parameters. To do it, simply click the Data sink on the canvas and select **Configuration**.

### Output configuration

#### SQL sentence to execute

<table><thead><tr><th width="169.94921875">Parameters</th><th>Description</th></tr></thead><tbody><tr><td><strong>Table</strong><mark style="color:red;"><strong>*</strong></mark></td><td>Enter the name of the table you'll use to build the SQL sentence to be executed.</td></tr></tbody></table>

#### **Column/Value pairs**

Define the table to be sent to your database. Click **Add Element** to add as many pairs as needed.

<table><thead><tr><th width="170.41796875">Parameters</th><th>Description</th></tr></thead><tbody><tr><td><strong>Column</strong><mark style="color:red;"><strong>*</strong></mark></td><td>Enter a name for the column that will appear in your database.</td></tr><tr><td><strong>Value</strong><mark style="color:red;"><strong>*</strong></mark></td><td>Select the incoming field that contains the value to sent.</td></tr></tbody></table>

Click **Save** to save your configuration.