Microsoft SQL Server Connector
Query and manage data in a Microsoft SQL Server (MSSQL) Database
Connections
MS SQL Server Connection
Authenticate requests to a Microsoft SQL Server.
| Input | Comments | Default |
|---|---|---|
| Host | Provide a string value for the address that your database server is hosted on. | |
| Port | Provide a string value of the port your database server is exposing. | 1433 |
| Database | Provide a string value for the name of the database. | |
| Connection Timeout | The number of milliseconds before the attempt to connect is considered failed. | 15000 |
| Username | ||
| Password |
Actions
Execute Stored Procedure
Execute a stored procedure on a Microsoft SQL Server Database
| Input | Comments | Default |
|---|---|---|
| Stored Procedure | The name of the stored procedure to execute. | |
| Timeout | The number of milliseconds to wait for a response from the server. If the timeout expires before the server responds, an error will be thrown. | 60000 |
| Connection |
Query
Interact with a Microsoft SQL Server Database
| Input | Comments | Default |
|---|---|---|
| Query | 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. | SELECT * FROM Customers WHERE customerId = @id |
| Parameters | Optional parameters to insert into a query. | |
| Parameters Object | Optional parameters to insert into a query. This should be a key-value object. Values from this object will be merged with Parameters inputs. | |
| Timeout | The number of milliseconds to wait for a response from the server. If the timeout expires before the server responds, an error will be thrown. | 60000 |
| Connection |