---
title: Microsoft SQL
description: Learn how to connect Microsoft SQL Server in Infoveave to query enterprise relational data for dashboards, reports, and data pipelines.
---

import { Aside, Steps } from '@astrojs/starlight/components';

# Microsoft SQL

Microsoft SQL connection helps you connect to a **Microsoft SQL Server database** and run queries directly from Infoveave.


## Adding a Microsoft SQL Connection

To create a new Microsoft SQL connection:
<Steps>
1. Go to the **Database** section.
2. Select **Microsoft SQL** from the available connectors.
3. Fill in the required connection details in the **New Microsoft SQL Connection** form.
</Steps>


## Connection Parameters

When setting up a Microsoft SQL connection, you need to provide the following details:

| Field      | Description |
|------------|-------------|
| **Name**   | A unique name to identify your connection. |
| **Port**   | Port number for Microsoft SQL (default is `1433`). |
| **Server** | The Microsoft SQL Server endpoint. |
| **Username** | Your Microsoft SQL username. |
| **Password** | The corresponding password for the username. |
| **Database** | The Microsoft SQL Server database you want to connect to. |
| **Schema** | The schema inside the database to be used (optional). |


## Steps to Validate and Save
<Steps>
1. After filling in the details, click **Validate** to verify the connection.
2. If validation succeeds, click **Save** to store the connection.
3. You can now use Microsoft SQL as a datasource in your Infoveave workspace.
</Steps>


## Example Use Case

With a Microsoft SQL connection configured, you can:

- Query and manage relational data stored in Microsoft SQL Server.  
- Use T-SQL for advanced data processing and analysis.  
- Integrate Microsoft SQL Server data into Infoveave Infoboards for dashboards, reports, and insights.