---
title: MSSQL
description: Learn how to connect and configure MSSQL in Infoveave to query relational data from Microsoft SQL Server for dashboards and reports.
---

import { MediaPlayerComponent } from "../../../../../components/video-player";
import RunScript from "../../../../../components/RunScript.astro";
import { Steps } from '@astrojs/starlight/components';

# MSSQL

<MediaPlayerComponent
  video="MssqlConnection.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 4,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 4,
    "end": 6,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 6,
    "end": 7,
    "text": "Select Microsoft SQL Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on 'Microsoft SQL' to establish a connection to a Microsoft SQL Server database."
  },
  {
    "start": 7,
    "end": 17,
    "text": "Configure MSSQL Details",
    "description": "In the 'New MicrosoftSql Connection' dialog box, enter the connection name. Keep the 'Port' as '1433' and the 'Server' as 'localhost.' Provide the 'Username,' enter the corresponding 'Password,' and set the 'Database'."
  },
  {
    "start": 17,
    "end": 21,
    "text": "Validate MSSQL Connection",
    "description": "Click the 'Validate' button to confirm that the provided MSSQL server details and credentials are correct and that Infoveave can successfully connect to the database."
  },
  {
    "start": 21,
    "end": 25,
    "text": "Save MSSQL Connection",
    "description": "After the connection validates successfully, click the 'Save' button to finalize and add the 'MSSQL Connection' to your list of available connections."
  }
]


}
  poster="/images/introduction-poster.png"
  posterText="Creating MSSQL Connection"
  client:load
/>

Microsoft SQL connection helps to connect a Microsoft SQL Server database for accessing and managing your relational data directly from Infoveave.

## Adding a Microsoft SQL Connection

To create a new Microsoft SQL connection:

<Steps>
1. Go to **Administration** > **Connections**
2. Click **New Connection** and select **Microsoft SQL** from the available connectors
3. In the **New Microsoft SQL Connection** form, provide the required configuration details
</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 Microsoft SQL connection |
| **Server** | The Microsoft SQL Server host address or instance name |
| **Port** | The SQL Server port (default: 1433) |
| **Username** | Your SQL Server authentication username |
| **Password** | Your SQL Server authentication password |
| **Database** | The specific database name to connect to |
| **Schema** | The database schema (optional) |

## Steps to Validate and Save

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

## Example Use Cases

With a Microsoft SQL connection configured, you can:

- Query and analyze relational data directly from SQL Server databases
- Create real-time dashboards with data from multiple SQL tables
- Build automated workflows that trigger on database changes
- Perform complex data joins and transformations using SQL queries
- Schedule regular data extracts from SQL Server for reporting
- Integrate SQL Server data with other data sources in Infoveave
- Monitor database performance metrics and query optimization
- Set up data synchronization between SQL Server and other systems
- Create advanced analytics using stored procedures and functions
- Generate business intelligence reports from enterprise SQL data