Mazaal AI Logo
Get Extension
AppsPricingBlogTry it
Salesforce logo
Microsoft SQL Server logo

Connect Salesforce to Microsoft SQL Server

Use 10 documented Salesforce triggers to run 5 documented Microsoft SQL Server actions.

10 source triggers
5 target actions
Reverse direction supported
Start Free TrialBrowse Salesforce integrations

Why Connect Salesforce & Microsoft SQL Server?

Start with a Salesforce event

Choose from 10 documented triggers, including Case Updated (Instant, of Selectable Type), Email Template Updated (Instant, of Selectable Type), Knowledge Article Updated (Instant, of Selectable Type).

Run a Microsoft SQL Server action

Send the event into one of 5 documented actions, such as Execute Query, Execute SQL Query, Insert Row.

Map and review the workflow

Choose the fields and conditions for the workflow, then test the result before activation.

Available Triggers & Actions

Salesforce logo

Salesforce

Triggers (10)

Case Updated (Instant, of Selectable Type)

Emit new event when a case is updated. See the documentation

webhook
Email Template Updated (Instant, of Selectable Type)

Emit new event when an email template is updated. See the documentation

webhook
Knowledge Article Updated (Instant, of Selectable Type)

Emit new event when a knowledge article is updated. See the documentation

webhook
New Case (Instant, of Selectable Type)

Emit new event when a case is created. See the documentation

webhook
New Deleted Record (Instant, of Selectable Type)

Emit new event when a record of the selected object type is deleted. See the documentation

webhook
New Email Template (Instant, of Selectable Type)

Emit new event when an email template is created. See the documentation

webhook
New Knowledge Article (Instant, of Selectable Type)

Emit new event when a knowledge article is created. See the documentation

webhook
New Outbound Message (Instant)

Emit new event when a new outbound message is received in Salesforce.

webhook
New Record (Instant, of Selectable Type)

Emit new event when a record of the selected object type is created. See the documentation

webhook
New Updated Record (Instant, of Selectable Type)

Emit new event when a record of the selected type is updated. See the documentation

webhook

Actions (24)

Add Contact to Campaign

Adds an existing contact to an existing campaign. See the documentation

Add Lead to Campaign

Adds an existing lead to an existing campaign. See the documentation

Convert SOAP XML Object to JSON

Converts a SOAP XML Object received from Salesforce to JSON

Create Account

Creates a Salesforce account. See the documentation

Create Accounts (Batch)

Create multiple Accounts in Salesforce using Bulk API 2.0. See the documentation

Create Attachment

Creates an Attachment on a parent object. See the documentation

Create Campaign

Creates a marketing campaign. See the documentation

Create Case

Creates a Case, which represents a customer issue or problem. See the documentation

Create Case Comment

Creates a Case Comment on a selected Case. See the documentation

Create Contact

Creates a contact. See the documentation

Create Content Note

Creates a content note. See the documentation and Set Up Notes.

Create Event

Creates an event. See the documentation

Create Lead

Creates a lead. See the documentation

Create Note

Creates a note. See the documentation

Create Opportunities (Batch)

Create multiple Opportunities in Salesforce using Bulk API 2.0. See the documentation

Create Opportunity

Creates an opportunity. See the documentation

Create Record

Create a record of a given object. See the documentation

Create Record

Create a new Salesforce record of any object type. Use **Describe Object** first if you're unsure what fields are available or required. For picklist fields, use the API value from **Describe Object**, not the display label. **Common required fields:** - Account: Name - Contact: LastName - Lead: LastName, Company - Opportunity: Name, StageName, CloseDate - Case: Subject - Task: Subject - Event: Subject, StartDateTime, EndDateTime To add a Contact/Lead to a Campaign, create a CampaignMember: {"CampaignId": "701xxx", "ContactId": "003xxx"} or {"CampaignId": "701xxx", "LeadId": "00Qxxx"}.

Create Task

Creates a task. See the documentation

Create User

Creates a Salesforce user. See the documentation

Delete Note Or Content Note

Delete a note or content note from a Salesforce record. See the documentation

Delete Opportunity

Deletes an opportunity. See the documentation

Delete Record

Permanently deletes a Salesforce record (moves to Recycle Bin for 15 days). Use **SOQL Query** to find the record ID if you only have the record name.

Delete Record

Deletes an existing record in an object. See the documentation

Microsoft SQL Server logo

Microsoft SQL Server

Triggers (2)

New Column

Triggers when a new column is added to a table. See the documentation

polling
New Or Updated Row

Triggers when a new row is added or an existing row is updated. See the documentation

polling

Actions (5)

Execute Query

Executes a SQL query and returns the results. See the documentation

Execute SQL Query

Execute a custom SQL query. See our docs to learn more about working with SQL in Mazaal AI.

Insert Row

Inserts a new row in a table. See the documentation

List Table Options

Retrieves available options for the Table field.

Query SQL Database

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

Integration Features

10 documented Salesforce triggers
5 documented Microsoft SQL Server actions
Configurable field mapping
Conditional workflow steps
Execution monitoring
A supported Microsoft SQL Server to Salesforce direction

Capability Examples

Salesforce trigger → Microsoft SQL Server action

Catalog example
SalesforceSalesforce

Case Updated (Instant, of Selectable Type)

Microsoft SQL ServerMicrosoft SQL Server

Execute Query

Microsoft SQL Server trigger → Salesforce action

Reverse direction
Microsoft SQL ServerMicrosoft SQL Server

New Column

SalesforceSalesforce

Add Contact to Campaign

How It Works

1

Connect Apps

Authenticate your Salesforce and Microsoft SQL Server accounts

2

Choose a Trigger

Select a documented Salesforce event

3

Choose an Action

Select the documented Microsoft SQL Server operation to run

Test and Review

Verify field mapping and provider responses before activation

Frequently Asked Questions

Integration Benefits

Trigger-driven Workflows

Start the supported direction from one of 10 documented Salesforce triggers.

Automated Actions

Run one of 5 documented Microsoft SQL Server actions after the selected trigger fires.

Provider Authentication

Review the authentication requirements published by each provider before activating the workflow.

Guided Configuration

Select a documented trigger, choose a target action, and map the fields required by the workflow.

Field Mapping

Map the fields exposed by the selected trigger and action, then review the required provider inputs.

Execution Review

Test the workflow and review provider responses before relying on it in production.

Microsoft SQL Server logoSalesforce logo

Reverse Integration Available

Also connect Microsoft SQL Server to Salesforce for bidirectional automation

View Integration
Salesforce logo

All Salesforce Integrations

Explore all available Salesforce connections

View All Integrations
Microsoft SQL Server logo

All Microsoft SQL Server Integrations

Explore all available Microsoft SQL Server connections

View All Integrations

Popular Integrations

HubSpot logoHubSpot
Pipedrive logoPipedrive
Notion logoNotion
OpenAI (ChatGPT) logoOpenAI (ChatGPT)
Google Sheets logoGoogle Sheets
Slack logoSlack
Telegram logoTelegram
Google Drive logoGoogle Drive
View all integrations →

More Microsoft SQL Server Integrations

HubSpot logoHubSpot
Pipedrive logoPipedrive
Notion logoNotion
OpenAI (ChatGPT) logoOpenAI (ChatGPT)
Google Sheets logoGoogle Sheets
Slack logoSlack
Telegram logoTelegram
Google Drive logoGoogle Drive
View all Microsoft SQL Server integrations →

Ready to Connect Salesforce & Microsoft SQL Server?

Build this supported workflow in Mazaal AI and test it with your own provider accounts.

Get Started Free