Microsoft SQL Server Component

Query and manage data in a Microsoft SQL Server (MSSQL) Database
Component key: ms-sql-server#
DescriptionMicrosoft SQL Server (MSSQL) is a popular relational database system. This component allows you to query an MSSQL database.
This component returns data as an object that can be used in subsequent steps.
Instead of generating dynamic queries and sanitizing SQL yourself, you can use generic queries with named parameter placeholders like @variableKey
.
For example, you can enter a query that reads INSERT INTO users (name, email) VALUES (@name, @email)
.
Then, you can enter values with keys
of name
and email
, and whatever values you like.
Values provided for name and email are sanitized automatically.
#
Microsoft SQL Server Connections#
MS SQL Server ConnectionThe MS SQL Server username and password can be put directly into a connection, alongside the database host, port, and database name.
Input | Default | Notes | Example |
---|---|---|---|
Input Database string / Required database | Default | Notes Provide a string value for the name of the database. | Example msdb |
Input Host string / Required host | Default | Notes Provide a string value for the address that your database server is hosted on. | Example 192.168.0.1 |
Input Password string password | Default | Notes | Example |
Input Port string / Required port | Default 1433 | Notes Provide a string value of the port your database server is exposing. | Example |
Input Username string username | Default | Notes | Example |
#
Actions#
QueryInteract with a Microsoft SQL Server Database | key: query
Input | Default | Notes | Example |
---|---|---|---|
Input Parameters data Key Value List params | Default | Notes Optional parameters to insert into a query. | Example ["Example item to be used in query"] |
Input Query string / Required queryField | Default SELECT * FROM Customers WHERE customerId = @id | Notes Provide a string containing a query that will be executed by the Microsoft SQL-Server database. You can pass in optional named parameters using the '@variable' operator. | Example |
Input Connection connection / Required sqlConnection | Default | Notes | Example |