Back to integrations
Microsoft SQL and Salesforce connection
Save yourself the work of writing custom integrations for Microsoft SQL and Salesforce and use n8n instead. Build adaptable and scalable Development, Data & Storage, workflows that work with your technology stack. All within a building experience you will love.
Ways to connect Microsoft SQL and Salesforce
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 Microsoft SQL and Salesforce connection
Create custom Microsoft SQL + Salesforce 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.
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
Salesforce supported actions
Add Note
Add note to an account
Create
Create an account
Create or Update
Create a new account, or update the current one if it already exists (upsert)
Delete
Delete an account
Get
Get an account
Get Many
Get many accounts
Get Summary
Returns an overview of account's metadata
Update
Update an account
Create
Create a attachment
Delete
Delete a attachment
Get
Get a attachment
Get Many
Get many attachments
Get Summary
Returns an overview of attachment's metadata
Update
Update a attachment
Add Comment
Add a comment to a case
Create
Create a case
Delete
Delete a case
Get
Get a case
Get Many
Get many cases
Get Summary
Returns an overview of case's metadata
Update
Update a case
Add Contact To Campaign
Add contact to a campaign
Add Note
Add note to a contact
Create
Create a contact
Create or Update
Create a new contact, or update the current one if it already exists (upsert)
Delete
Delete a contact
Get
Get a contact
Get Many
Get many contacts
Get Summary
Returns an overview of contact's metadata
Update
Update a contact
Create
Create a custom object record
Create or Update
Create a new record, or update the current one if it already exists (upsert)
Delete
Delete a custom object record
Get
Get a custom object record
Get Many
Get many custom object records
Update
Update a custom object record
Upload
Upload a document
Get Many
Get many flows
Invoke
Invoke a flow
Add Lead To Campaign
Add lead to a campaign
Add Note
Add note to a lead
Create
Create a lead
Create or Update
Create a new lead, or update the current one if it already exists (upsert)
Delete
Delete a lead
Get
Get a lead
Get Many
Get many leads
Get Summary
Returns an overview of Lead's metadata
Update
Update a lead
Add Note
Add note to an opportunity
Create
Create an opportunity
Create or Update
Create a new opportunity, or update the current one if it already exists (upsert)
Delete
Delete an opportunity
Get
Get an opportunity
Get Many
Get many opportunities
Get Summary
Returns an overview of opportunity's metadata
Update
Update an opportunity
Query
Execute a SOQL query that returns all the results in a single response
Create
Create a task
Delete
Delete a task
Get
Get a task
Get Many
Get many tasks
Get Summary
Returns an overview of task's metadata
Update
Update a task
Get
Get a user
Get Many
Get many users
Microsoft SQL and Salesforce connection details
Other integrations with Microsoft SQL
Other integrations with Salesforce
Supercharge your CRM
Need a more powerful connection with your CRM? n8n lets you go beyond standard integrations offered by popular CRMs!
Save engineering resources
Reduce time spent on customer integrations, engineer faster POCs, keep your customer-specific functionality separate from product all without having to code.
Microsoft SQL and Salesforce connection guides
Export data from SQL database to CSV: 3 nifty techniques
Export your SQL data into CSV with 3 nifty techniques: using SQL Server Management Studio, sqlcmd command line utility and n8n automation tool.
How to easily automate your Salesforce data import
Salesforce and other CRMs are built around the data they are being fed. This begs the question, where do we get this data from?
Before switching to a CRM, it is common for organizations to have data pipelines of leads and customers stored in extant sources like spreadsheets and ERPs.
These sources could store data that range from hundreds to billions. Thus, it is imperative that we explore some of the most efficient and effective ways to import data into Salesforce. And this is the crux of thi
FAQs
FAQ
Can Microsoft SQL work together with Salesforce in n8n Lab?
Can I use Microsoft SQL’s API with n8n Lab?
Can I use Salesforce’s API with n8n Lab?
Is n8n Lab a secure option for connecting Microsoft SQL with Salesforce?
How do I start building Microsoft SQL + Salesforce automation in n8n Lab?
Need help setting up your Microsoft SQL and Salesforce connection?
Discover our latest community's recommendations and join the discussions about Microsoft SQL and Salesforce connection.
Syntax error when inserting multiple rows using Microsoft SQL node with Azure Dedicated SQL pool
Cathryn17
Describe the problem/error/question When inserting multiple rows (items) into an Azure Dedicated SQL pool (on a regular Azure SQL Server), we receive a syntax error from the DB (“Parse error at line: 1, column: 73: Incor…
Help getting the MCP trigger to pass a variable into an http request tool
trijste
I’m trying to build an MCP server that has access to my Salesforce org, but only at the schema and describe object level, ideally to provide more information for building out SOQL queries using custom fields from custom …
Salesforce platform events capture - to trigger N8n flow
DV
I could not find node of trigger type, which will start workflow when “platform event is publishjed from salesforce”. I am looking for support in n8n to listen to platform event as soon as published by SalesForce.
Ways to connect credentials to Salesforce Custom Domain?
Graeme Smith
Describe the problem/error/question Unable to create credentials (oauth) for salesforce sandbox with custom domain What is the error message (if any)? error=redirect_uri_mismatch redirect_url_must_match_configuration I…
A widely adopted workflow orchestration workspace trusted by technical teams including
Why use n8n to connect Microsoft SQL with Salesforce
Build complex workflows, really fast
