Microsoft SQL Server

Microsoft SQL Server (MSSQL for short) is a relational database management system developed by Microsoft.

Integration with LogicHub

Connecting with MSSQL

To connect to MSSQL following details are required:

  • Server Name or Hostname of Database: Example: or
  • Username: Username for connecting to the database.
  • Password: Password for connecting to the database.
  • Port (Optional): Specify the port on which database server is listening, default is 1433.
  • Schema/Database Name (Optional): Specify default database to connect.

Actions with MSSQL


Query Microsoft SQL Server database.

Inputs to this Action

  • Connection: Choose connection that you have created
  • Query Template: Jinja2 Template following are some examples:
    Select ID, name from customers where city_id = {{city_id_column_name}}
    Select ID, date, and amount from orders
    Update customers set name = ‘new name’ where id = 3
    Here variables inside curly braces {{}} refer to the column of the parent node’s results table.

Output of Action
If the query returns results, for example, select * from orders, the following will be one row of the output.

In case the query does not return results, for example, update customers set name = ‘new name’ where id = 3. The output will be as follows:

Did this page help you?