Skip to main content

Microsoft SQL Server (MSSQL)

Use the MSSQL connector to perform various operations such as executing custom queries, managing databases, and more. This connector allows you to interact with your Microsoft SQL Server instance directly from Boltic. You will need a valid MSSQL connection to get started.

Requirements​

To use the MSSQL connector, you need:

  • Access to a Microsoft SQL Server instance.
  • MSSQL credentials (username and password).
  • The MSSQL server must be accessible over the internet or via a secure network.

Supported Authentication Methods​

  • Username and Password
  • Windows Authentication (Optional)

Basic Operations​

MSSQL Connection​

  • Set up an MSSQL connection to execute queries and manage your database resources.

Database Operations​

  • Execute Query: Run custom MSSQL queries directly on your database server.

Query​

  • Enter your Query: Specify the SQL query you want to execute. This can include operations like selecting, inserting, updating, or deleting data within your database.

Example Operations​

Database​

  • Execute a Query: Run SQL commands (e.g., SELECT, INSERT, UPDATE, DELETE) on your MSSQL database.

Support​

For more detailed instructions on setting up your MSSQL connection, refer to the Boltic documentation or contact Boltic support.