Data to AI™ / Copilot/Salesforce

How to connect Salesforce to Microsoft Copilot

Let sales leaders and finance ask a Teams agent about pipeline coverage, slipped deals and won revenue, answered from Salesforce objects Dataddo keeps in sync.

Better answers, fewer tokens.

  • Lower AI costs for the same work
  • More accurate, reliable answers
  • Read-only
  • Uses the Salesforce data you already sync
  • SOC 2 Type II certified
Microsoft 365 Copilot
Connected to Dataddo

Which open opportunities closing in September have not been touched for two weeks?

Copilot Answer · Salesforce

29 of the 85 open opportunities with a September CloseDate have not been modified in over 14 days. Qualification holds the most, with 17 stale deals.

StageNameOpportunitiesLastModifiedDate 14d+Stale share
Qualification Opportunities 421740%
Proposal Opportunities 28932%
Negotiation Opportunities 15320%

Read from the replicated Opportunities object; stale means LastModifiedDate, the default replication date field, is over 14 days old.

source
Salesforce · as of Mon 06:40 UTC
covers
CloseDate 1-30 Sep 2026
Example answer · fictional account and figures
Salesforce in Copilot

Questions Copilot can answer from your Salesforce data

Salesforce is a cloud CRM. Dataddo replicates the objects you choose, standard or custom, with the fields your org defines, or runs your own SOQL query.

Forecast answers in the sales channel

Ask Copilot

@Pipeline desk How many open Opportunities with a CloseDate this quarter sit in each StageName right now?

During the Monday forecast meeting, anyone in the sales leadership channel in Teams mentions the agent instead of waiting for sales ops to refresh a report.

Bookings check before revenue close

Ask Copilot

@Pipeline desk List Opportunities won last month with Name, Account and CloseDate so I can check them against the ledger.

A controller asks in Microsoft 365 Copilot before closing the month, then lines the list up with issued invoices to spot deals that were signed but never billed.

Dashboard types from real fields

Ask Copilot

Use the dataddo tools to describe Opportunity Line Items and generate a TypeScript type for the revenue dashboard from its fields.

A developer in VS Code builds the revenue dashboard on the org's real field names, custom ones included, instead of guessing them from an old export.

Salesforce datasets and the questions they answer in Copilot →
Pricing

Priced per seat.

Data to AI™ is priced per seat, like the AI assistants your team already uses, with ~25% off on annual billing. Need tailored contracts or volume pricing? Talk to us about Enterprise.

Data to AITM

Serve governed business data to Claude, ChatGPT and other AI tools over MCP.

$10.49/month

per seat

3 seats minimum

Enterprise

Flexibly deploy Dataddo in any cloud or hybrid environment.

Custom

We have a payment model that works for you

See all plans and features →
Setup

Connect Salesforce to Copilot step by step

  1. 1
    Connect Copilot to Dataddo Add Dataddo as an MCP tool to a Copilot Studio agent and sign in, or add it to mcp.json for GitHub Copilot in VS Code.
  2. 2
    Connect Salesforce to Dataddo Sign in with your Salesforce account in Dataddo and choose the datasets to sync, such as Opportunities and Opportunity Line Items.
  3. 3
    Choose what Copilot can see Select the Salesforce data Copilot may query. Access is read-only, and data you don't select stays out of reach.
Copilot setup guide →
With vs. without

Salesforce in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Where the team asks Sales leaders message sales ops in Teams and wait for someone to run a report and post a screenshot back. A Copilot Studio agent published to Teams and Microsoft 365 Copilot answers from the replicated Opportunities and Accounts objects directly. Answers inside Teams
When the agent calls Dataddo A general assistant cannot tell that pipeline questions need CRM data, so it answers from documents and email threads. The server description in Copilot Studio names Salesforce pipeline, opportunities and bookings, which tells the agent when to call Dataddo. CRM questions go to CRM data
What a channel can see A shared export in a Teams channel shows everyone every column, including contact phones and emails. Untick contact fields such as email and phone when you create the source, so the agent has no contact details to repeat in a channel. No contact data in Teams
Developers in VS Code Developers copy field names from an old export into dashboard code and miss the custom fields the admin added later. GitHub Copilot in Agent mode reads the same Salesforce entities through .vscode/mcp.json and describe_entity. Real field names in code
Token consumption Copilot spends tokens exploring raw Salesforce columns, sampling rows and retrying until it understands the data. Field definitions and relations are supplied up front, so the model skips the exploration and goes straight to the answer. Fewer tokens per answer
Answer quality Prone to wrong joins, invented fields and numbers that are hard to check. Answers built on agreed definitions. In the Dataddo benchmark, Opus 5.5 reached 95.2% good outcomes, against 81% over raw SQL. Better answers
Datasets

Salesforce datasets and the questions they answer in Copilot

The Salesforce datasets finance and RevOps teams use most, with their real field names. Copilot queries them by name through the Dataddo semantic layer.

Dataset Metrics and attributes Ask Copilot
Opportunities
  • LastModifiedDate
  • Id
  • Name
  • StageName
  • CloseDate
  • + others
Which opportunities have not had their LastModifiedDate change in the last two weeks?
Opportunity Line Items How has the number of line item edits per month trended this year, by LastModifiedDate?
Accounts How many accounts were modified each month this year, based on LastModifiedDate?
Leads Which leads with the same Name have different Id values in our Salesforce org?
Custom Objects How do values in our Custom Fields differ between Record Types?
See all Salesforce datasets, metrics and attributes on the connector page →
Benchmark

Fewer confident mistakes. No leaked personal data.

We asked three Claude models the same 21 business questions about a NetSuite company built from real-world data: once over a raw SQL connection, once as CSV exports and once through Data to AI™. Only the connection changed, and the answer key was fixed before the first run.

95.2%

good outcomes with Opus 5.5 on Data to AI™, against 81% on a raw SQL connection

58%

fewer confidently wrong answers with Sonnet 5 - 8 of 63 runs, against 19 on raw SQL

24x

cheaper per question: Haiku 5.5 on Data to AI™ (87.3%) beat Opus 5.5 on raw SQL (81%)

0 of 9

attempts disclosed a sales rep's email address, against 9 of 9 on raw SQL

Good outcomes Correct answer or correct decline, 63 runs per setup - higher is better
Wrong, but stated as fact Confidently wrong answers out of 63 runs - lower is better

21 questions, 3 runs each. 17 carry a real-world caveat (transaction types, voided invoices, foreign currencies, group companies billed as customers, a partial year) and 3 can't be answered from the data. Ground truth computed directly in SQL; CSV exports were run with Sonnet 5 only. Run date: 26 October 2026.

Read the benchmark →
FAQ

Salesforce and Copilot: FAQ

How do I connect Salesforce to Copilot?

Replicate Salesforce objects such as Opportunities and Accounts in Dataddo and attach the flow to a Copilot destination or AI Model. In Copilot Studio, add a Model Context Protocol tool with https://headless.dataddo.com/mcp-data and OAuth 2.0 dynamic discovery, then publish the agent to Teams and Microsoft 365 Copilot. GitHub Copilot uses .vscode/mcp.json.

Can a Teams agent answer Salesforce forecast questions?

Yes. Build an agent in Copilot Studio, add Dataddo Data Access as a Model Context Protocol tool and publish it under Channels > Teams and Microsoft Copilot.

How do I make the agent use Dataddo only for CRM questions?

Write the server description in Copilot Studio around Salesforce pipeline, opportunities and bookings. The description tells the agent when to call Dataddo, so unrelated questions stay with Copilot.

Which Salesforce objects should I attach for the agent?

Only what the audience needs. After sign-in, the client reaches every flow or Context attached to an AI destination or AI Model in your account.

Can GitHub Copilot read the same Salesforce data?

Yes. Add the server to .vscode/mcp.json, start it, sign in and use Copilot Chat in Agent mode. On Copilot Business and Enterprise an org admin must first enable the MCP servers in Copilot policy.

Can the agent change Salesforce records?

No. The agent only reads Salesforce data Dataddo has already replicated, asking for entities and fields by name. Opportunities are updated in Salesforce by your team as before.

Why do some Salesforce characters look odd in Copilot answers?

Some characters, such as apostrophes, and emoticons cannot be displayed because of Salesforce's encoding policy. This is a Salesforce restriction, and you can change how they display on your side.

New from Dataddo · Data to AI™

Ask Claude or ChatGPT about your ads, analytics and CRM

“What did a new lead cost us last week, by paid channel?”

Connect 400+ sources once and get the answer right in your AI chat, without building a report. Better answers: your metrics are defined once, so the AI doesn't have to guess.