Back to integrations
Canvas and Microsoft SQL connection
Save yourself the work of writing custom integrations for Canvas and Microsoft SQL and use n8n instead. Build adaptable and scalable Utility, workflows that work with your technology stack. All within a building experience you will love.
Ways to connect Canvas and Microsoft SQL
Create a new workflow and add the first step
In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Create your own Canvas and Microsoft SQL connection
Create custom Canvas + Microsoft SQL automations by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Supported methods for Canvas
Delete
Get
Head
Options
Patch
Post
Put
To set up Canvas integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Canvas to query the data you need using the API endpoint URLs you provide.
See the example hereRequires additional credentials set up
Use n8n's HTTP Request node with a predefined or generic credential type to make custom API calls.
Microsoft SQL supported actions
Execute Query
Execute an SQL query
Insert
Insert rows in database
Update
Update rows in database
Delete
Delete rows in database
Canvas and Microsoft SQL connection details
Other integrations with Microsoft SQL
FAQs
FAQ
Can Canvas work together with Microsoft SQL in n8n Lab?
Can I use Canvas’s API with n8n Lab?
Can I use Microsoft SQL’s API with n8n Lab?
Is n8n Lab a secure option for connecting Canvas with Microsoft SQL?
How do I start building Canvas + Microsoft SQL automation in n8n Lab?
Need help setting up your Canvas and Microsoft SQL connection?
Discover our latest community's recommendations and join the discussions about Canvas and Microsoft SQL connection.
A widely adopted workflow orchestration workspace trusted by technical teams including
Why use n8n to connect Canvas with Microsoft SQL
Build complex workflows, really fast
