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:

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.

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

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.

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.