Microsoft SQL Server
+
Konnectify
Microsoft SQL Server Integration with Konnectify
Connect to Microsoft SQL Server and automate data workflows by polling for new records and running queries or stored procedures in your database.
Queries
Stored Procedures
2 Triggers
3 Actions
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) used to store, query, and manage structured data for business applications. With
Konnectify, you can connect securely to your SQL Server database to detect new rows on a schedule and run custom queries or stored procedures as part of
end-to-end automations.
This integration is especially useful for syncing operational data to other systems, generating downstream actions from new database records, and
standardizing database operations inside repeatable workflows.
New to Konnectify?
Create your Konnectify account to start building database-powered workflows.
Sign up for Konnectify →
What you can automate
• Detect new rows in a table and fan out into downstream steps
• Run parameterized SELECT queries using dynamic placeholders
• Retrieve one matching row for lookups and enrichment
• Retrieve all matching rows for reporting and exports
• Execute stored procedures with defined input/output parameters
• Implement cursor-based polling to process records incrementally
API & Authentication
Authentication method: Database credentials
This connector uses credentials-based authentication (SQL Server host, port, database name, username, and password). Konnectify uses
these details to establish a connection to your SQL Server instance.
What this integration can do
- Poll for new rows using cursor-based incremental reads
- Run custom SELECT queries with dynamic placeholders (e.g.,
{{customer_id}})
- Execute stored procedures with defined input and output parameters
- Return a single matching row or all matching rows depending on the action used
Important notes (limits & safety)
- Database performance depends on your schema, indexes, and query complexity.
- Polling frequency and large result sets can increase load—use filters and indexing.
- Follow your organization’s security policy for credential storage and network access.
Reference docs:
Microsoft SQL Server documentation
&
SQL Server connectivity & drivers.
How to connect Microsoft SQL Server to Konnectify
Prerequisites
- SQL Server host (DNS or IP) reachable from Konnectify (network/firewall rules allow access)
- Port (typically 1433)
- Database name
- A SQL user with required permissions to read data and/or execute procedures
Add Microsoft SQL Server to a Workflow
- Open your Konnectify Workflow builder.
- Click Add step and choose Microsoft SQL Server.
- Select a Trigger or Action to start configuring.
Authorize via database credentials
- Enter SQL Server Host, Port, and Database Name.
- Provide Username and Password.
- Save the connection (Konnectify will validate the connection when possible).
Configure the Trigger or Action
- Choose the table/query/stored procedure required for your use case.
- Use placeholders like
{{placeholder}} to pass dynamic inputs from previous steps.
- For polling triggers, ensure your query/table has a reliable incremental column (e.g., identity or created timestamp).
Warning
Avoid using non-deterministic sorting or missing filters in polling queries. For best results, include an indexed cursor column and keep result
sets small to reduce database load.
Test the Workflow
- Run a test to verify the connector can reach SQL Server.
- Confirm the query/procedure returns the expected data (one row vs multiple rows).
- Validate downstream mapping using real sample output.
Activate the Workflow
- Turn on the workflow.
- Monitor initial runs and adjust polling interval and query filters as needed.
Triggers
2
This integration includes 2 polling triggers. Polling triggers run on a schedule and use a cursor-based approach to process new data
incrementally.
Queries
2 triggers
New Row
Polls Microsoft SQL Server using a cursor-based for rows in a table.
Custom Query
Polls Microsoft SQL Server using a cursor-based custom SELECT query.
Actions
3
Use actions to query your database and execute stored procedures. For dynamic inputs, you can pass fields from previous steps into SQL using placeholders
like {{placeholder}}.
Queries
2 actions
Execute Query (Returns one matching row)
Executes a custom SELECT query. Use {{placeholder}} for dynamic inputs.
Execute Query (returns all matching rows)
Executes a custom SELECT query. Use {{placeholder}} for dynamic inputs.
Stored Procedures
1 actions
Execute Stored Procedure
Execute a stored procedure in MSSQL Server,The stored procedure need to properly defined with the Input and output parameters
Add another action to chain stored procedure results into downstream steps.
Popular automations
Examples of common SQL Server workflows you can build with the triggers and actions available in this connector.
Enrich new table rows with a lookup query
When a new row lands in a table, fetch a related record (for example, customer or account details) using a parameterized SELECT.
New Row
→
Execute Query (Returns one matching row)
Generate a scheduled report from a custom query
Poll using a custom SELECT that filters for newly-added/updated records, then pull all matching rows for export or downstream processing.
Custom Query
→
Execute Query (returns all matching rows)
Run a stored procedure when new data arrives
When a new row is detected, execute a stored procedure to apply business rules (validation, aggregation, status changes) with input/output parameters.
New Row
→
Execute Stored Procedure
Two-step “find & fetch” using dynamic placeholders
Poll for records meeting a condition, then use a second query (with placeholders) to fetch related rows or computed fields.
Custom Query
→
Execute Query (Returns one matching row)
→
Execute Query (returns all matching rows)
FAQ
How does authentication work for SQL Server in Konnectify?
The connector uses credentials-based authentication: SQL Server Host, Port, Database Name, Username, and Password. Ensure the user has the required permissions for the tables/queries you run and any stored procedures you execute.
Which SQL Server editions / hosting options are supported?
Most SQL Server deployments work as long as Konnectify can reach the instance over the network and the credentials are valid (self-hosted, VM, or cloud-hosted). Your environment may require firewall allowlisting, VPN/VPC routing, or other network configuration.
How do the triggers work—are they webhooks?
No—both triggers are polling triggers. Konnectify runs the trigger on a schedule and uses a cursor-based approach to fetch new data incrementally. For best results, use a stable incremental field (e.g., identity column or created timestamp) and proper indexing.
How does Konnectify prevent duplicates?
This connector’s triggers use cursor-based polling to continue from the last processed position. To minimize duplicates, ensure your query/table sort and cursor field are deterministic and monotonically increasing. If you re-run a workflow or change the query, consider adding additional filters (e.g., “created_at > last_run_time”) and/or idempotency checks in downstream systems.
How are rate limits handled for SQL Server?
SQL Server doesn’t typically enforce “API rate limits” like SaaS apps, but it does have resource constraints (CPU, IO, locks, connection limits). If workflows run too frequently or return large datasets, you may see timeouts or performance issues. Use indexes, limit result sets, and tune polling intervals to match your database capacity.
Can I connect multiple SQL Server databases or environments?
Yes. You can create multiple Konnectify connections (for example, dev/stage/prod, or separate databases/servers) and select the appropriate connection per workflow step.
How should I format stored procedure inputs and outputs?
Define your stored procedure with explicit input and (when needed) output parameters. In Konnectify, map workflow data into the input parameters and use returned output fields in later steps. If your procedure returns result sets, ensure it is designed to return predictable schemas for reliable mapping.
Ready to automate your Microsoft SQL Server workflows?
Connect your database to Konnectify and start building reliable, query-driven automations in minutes.
Get started free →
