---
title: "AzureSQL"
slug: "azuresql"
updated: 2026-04-15T15:46:15Z
published: 2026-04-15T15:46:15Z
canonical: "docs.databee.buzz/azuresql"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.databee.buzz/llms.txt
> Use this file to discover all available pages before exploring further.

# AzureSQL

With Azure SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure. For more information on Azure SQL, click [here.](https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql)

**Integration Method:** API

**Tables**: Account Change (3001), Authentication (3002), Entity Management (3004), User Access Management (3005), Datastore Activity (6005)

This integration supports the following events.

| **Event** | **Description** |
| --- | --- |
| Audit Logs | Provides all the audit level details like authentication information, changes in account/administration, queries that are being executed. |

This integration supports the following versions.

| Azure SQL API Version | V1 |
| --- | --- |

> [!NOTE]
> **Note:**
> 
> Azure SQL is a continuously updated service. As for this document preparation, the latest release was in November 2025. More information can be found [here](https://learn.microsoft.com/en-us/azure/azure-sql/database/doc-changes-updates-release-notes-whats-new?view=azuresql).

## Prerequisites

- The user should have access to the [Azure portal](https://portal.azure.com/) with an account that has the Global Administrator privileges.
- The user should have access to the DataBee console.

## Configuration Overview

1. Configure an [application](/docs/azuresql#application_heading).
2. Configure [Log analytics](/docs/azuresql#log_analytics_config) with the required permissions.
3. Configure the Azure SQL [database](/docs/azuresql#database_config) to send logs to log analytics workspace.
4. Configure [Azure SQL feed](/user-manual/docs/azuresql#databee-configuration) in DataBee Console with the required client credentials.

| **DataBee Parameter** | **Azure Parameter** |
| --- | --- |
| Client Key | Application (client ID) |
| Client Secret | Client [secret](/docs/azuresql#client_secret) Value |
| Token URL(<tenant_id>) | [Directory (Tenant) ID](/docs/azuresql#Client_tenant_id) |
| Workspace ID (workspaceId) | [Workspace ID](/docs/azuresql#workspace_id) |

## Azure Configuration

### Create an application

1. Log on to [Azure portal](https://portal.azure.com/) with an account that has the Global Administrator privileges. In the search bar, search for **App registrations** and select it. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-p9r1mqxu.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
2. In the “App registrations” page, click **New registration**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-u5k0mvuv.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
3. Enter a name for the application and click **Register**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-g6r54mbi.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
4. In the **Overview** page, copy the **Application (client) ID** and **Directory (tenant) ID** for later use. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-v3ccc26i.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
5. Click **Manage** and click **Certificates & secrets** then click **New client secret**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-qxoc82n3.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
6. Enter a ‘Description’ for this client secret and select the desired expiry period from the ‘Expires’ drop-list. Click **Add**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-1yfrgev7.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)

> [!NOTE]
> **Note**:
> 
> The user needs to re-create the client secret when it expires.
7. Copy the **Value** fields for later use. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-0sz198a9.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)

### Log Analytics Configuration

1. In the search bar, check for **Log Analytics workspaces** and select it. ![A screenshot of a computer AI-generated content may be incorrect.](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-roffynq6.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
2. In the “Log Analytics workspaces” page, click on **Create**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-oqmqvhln.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
3. In the “Create Log Analytics workspace” page:
  1. Select the preferred **Subscription** from the dropdown list.
  2. Select the preferred **Resource group** from the dropdown list.
  3. Give a **Name** for the workspace.
  4. Select the preferred **Region** from the dropdown list.
4. Click on **Review + Create**.

![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-vod4xuff.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
5. In the **Overview** page, copy the **Workspace ID** and save it for future use. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-ubhcws6b.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
6. Click on **Access control (IAM)** then click **Add** and click **Add role assignment**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-lubjuo8b.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
7. In the “Add role assignment” page, in the **Role** tab, search for the **Reader** role, select and click **Next**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-7ly0se6n.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
8. In the **Members** page,
  1. For **Assign access to**, click on **User, group or service principal** radio button.
  2. Click **Select members**.
  3. Search for the application we created earlier and click **Select**.
9. Click **Next**.

![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-7xd6s6j0.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
10. Click on **Review + assign**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-myk568db.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)

### Database Configuration

1. In the search bar, check for **Azure SQL Database** and select it. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-26c66f2b.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
2. Select the required database for which log analytics needs to be configured. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-f43awq3o.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
3. In the left navigation pane, click **Monitoring** then click **Diagnostic settings**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-vwvwfb0c.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
4. In the “Diagnostic settings” page, click **Add diagnostic setting**. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-ku7do5bb.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
5. Click on the check box of **SQL Security Audit Event**.
6. Click on the check box of **Send to Log Analytics workspace**.
7. Select the Subscription, Log Analytics workspace from the dropdown and click **Save**.

![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-5ssck0g5.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)

## DataBee Configuration

1. Login to the DataBee UI, navigate to **Data** > **Data Feeds** and click the **Add New Data Feed** button. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-6gl7vy5h.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
2. Search for the **Azure SQL** and click it as shown below. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-aeebon25.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
3. Click on the **API Ingest** for collection method. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-c6de2256.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
4. Enter feed contact information then scroll down. ![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-s8ilnwa0.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
5. In the configuration page, confirm the following:

![](https://cdn.document360.io/04e48772-4346-44a4-aa69-043eca42257c/Images/Documentation/azuresql-image-cozbeb01.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A30%3A36Z&se=2026-10-30T12%3A30%3A36Z&sr=c&sp=r&sig=oetGecl8kSCw67djc35bJfb47fGwQCqJfzIFmt99L1Y%3D)
  - **Authorization Method:** OAuth2
  - **Client Key:** Paste the Application (Client) ID generated previously
  - **Client Secret:** Paste the [Client Secret](/docs/azuresql#client_secret) generated previously
  - **Token URL**: Replace <tenant_id> placeholder with your Directory (Tenant) ID.
  - **Workspace ID:** Paste the [Workspace ID](/docs/azuresql#workspace_id) noted earlier
  - **Event Types**: Preselected for all the event types that integration pulls.
6. Click **Submit**.

## Troubleshooting Tips

- If you encounter any issues regarding log forwarding, refer to the [DataBee troubleshooting article](https://docs.databee.buzz/docs/troubleshooting) for detailed guidance.