> For the complete documentation index, see [llms.txt](https://docs.erathos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.erathos.com/destinations/what-is-a-destination/postgresql/azure.md).

# Azure

To connect to your PostgreSQL instance (hosted on Azure Cloud), in addition to the access credentials, there are specific configurations that need to be made.

## Setup

### Install extension

The initial requirement to use PostgreSQL on Azure as a destination is to enable the extension that allows reading files from Blob Storage.

In the Azure portal, locate your database. On the database's main page, expand **Settings** in the sidebar, and select **Server Parameters**.

Once the configuration screen loads, filter by **"azure.extension"**. In the **VALUE** column for the **azure.extension** row, click to view the list of values. Find and select **AZURE\_STORAGE** from the available options, then click **Save** at the top of the page to add this to the list of allowed extensions.

![](https://help.erathos.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaE1CIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--9f5000c83abbdf730440ea74fe500487258f04d1/Screenshot%20from%202024-09-20%2011-11-31.png)

After adding the extension to the allowed list, execute the following query to install the additional functionalities related to Storage:

```sql
 CREATE EXTENSION azure_storage;
```

To finalize, grant admin permission for the extension to the user of the credential that will be used on the platform with the following query:

```sql
GRANT azure_storage_admin TO <CREDENTIAL_USER>;
```

{% hint style="info" %}
Replace `<CREDENTIAL_USER>` with the username of the credential that will be used on the Erathos platform.
{% endhint %}

### Firewall

{% hint style="success" %}
Our **IP address** is **35.212.87.86.**
{% endhint %}

You’ll need to add Erathos IP addresses to your firewall’s whitelist. Navigate to the main page of the chosen database and select the **Networking** option within **Settings**. Scroll to the **Firewall rule name** table and choose a name of your preference to identify our platform. Then, add the platform's IP as the **Firewall rule name** and **End IP address**. Apply the new rule by clicking **Save** at the top of the page.

![](https://help.erathos.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaFVCIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--e99ac88b0696d9fd5ad028b22bebff1fb4658673/Screenshot%20from%202024-09-20%2011-34-30.png)

## Connect to Erathos

To connect Erathos to your PostgreSQL (Azure):

1. **Create a New Destination**
   * Go to **Settings** > **Data Warehouse**.
   * Select **PostgreSQL (Azure)**.
2. **Fill Out the Form**
   * Input your credentials, such as **Host**, **Database name**, **User**, **Password** and **Port**.
3. **Advanced Options (Optional)**
   * Define if the connection should be made through a Static IP or SSH. For more information, plese referer to [Databases connection types](/connectors/databases.md#connection-types).

{% hint style="info" %}
If you need help connecting to your PostgreSQL, reach out to our team at <support@erathos.com>.
{% endhint %}