MSSQL

Creating MSSQL Connection

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:

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

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

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

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