Skip to main content

How to Connect Salesforce as a Data Source in Alta (Connectors)

Connect Salesforce through the Connectors library so Alta syncs your accounts, contacts, opportunities, and leads — the training data that powers metrics, dashboards, and Luna.

Written by Katie Supporté

Salesforce is where most revenue teams keep the system of record for accounts, pipeline, and closed business. Connecting it as a data source through the Connectors library syncs those tables into your Alta workspace, where they become training data for Alta and a foundation for your metrics, dashboards, and Luna analysis. Once it's flowing, you can measure pipeline and win rates, segment by any Salesforce field, and let Luna answer questions in plain English.

Who this is for: RevOps, sales leadership, and analytics teams who want Salesforce data measured and queried across Alta.

Not the same as the CRM integration. Connecting Salesforce here (under Connectors) brings its data in for analytics and training. If you instead want Alta to sync contacts and write activity back for outreach, use the CRM integration under Settings → Integrations (see Related). Many teams run both.


Before you start

  • You'll sign in to Salesforce in a popup — use a Salesforce user with read access (via profile or permission set) to every object you want to sync.

  • For the cleanest, most auditable setup, use a dedicated integration user with a read-only profile.

  • Know whether you're connecting Production or a Sandbox org so you sync the right data.

  • You only connect a source once per workspace. If Salesforce already shows Connected, edit the existing connection instead of adding a new one.

Connect Salesforce

  1. Open Connectors from the sidebar.

  2. Find Salesforce — use the CRM category tab or the Search data sources box.

  3. Click the Salesforce card to open the Create connector screen.

  4. You'll see "Connect your Salesforce account using OAuth." Click Connect, sign in to Salesforce in the window that opens, and wait for Authentication succeeded!

  5. Back in the library, the card shows Connected with a spinner and Data is syncing until the first sync finishes.

Choose which tables sync

  1. Open the connection from the library. Salesforce defaults to syncing the account table, alongside standard objects like contacts, opportunities, and leads.

  2. In the Salesforce tables section, the Synced toggle and Table name columns control what's pulled in.

  3. Turn off Show only synced tables to see every available object — including custom objects (typically ending in __c) — and enable more.

Key tables and fields synced

  • account — the company record: Id, Name, Industry, Type, AnnualRevenue, NumberOfEmployees, BillingCountry, OwnerId, CreatedDate

  • contact — people at an account: Id, AccountId, Email, Title, LeadSource, CreatedDate

  • opportunity — the deal/pipeline record: Id, AccountId, Amount, StageName, Probability, CloseDate, IsWon, IsClosed, Type, OwnerId

  • lead — top-of-funnel: Id, Status, LeadSource, Company, ConvertedDate, IsConverted

  • opportunitylinehistory / opportunityhistory — stage and amount changes over time, for velocity and stage-conversion analysis

  • task / event — activity records (calls, emails, meetings) linked to accounts, contacts, and opportunities

  • user — rep/owner lookup: Id, Name, Email, IsActive

What you can ask this data

Once it's syncing, build it into metrics and dashboards or just ask Luna / Ask AI. For example:

  • "What's our total open pipeline by stage this quarter?" — sums opportunity.Amount grouped by StageName.

  • "Which industries have the highest win rate?" — joins opportunity to account.Industry using IsWon.

  • "How many opportunities did each owner close last month?" — counts won opps by OwnerId and CloseDate.

  • "What's average deal size by lead source?" — averages Amount grouped by LeadSource.

  • "What's our average sales cycle from creation to close?" — measures CreatedDate to CloseDate on won opps.

  • "Which deals slipped close date this quarter?" — uses opportunityhistory to find pushed CloseDate values.

Example use cases

  • Pipeline & forecast dashboard. Track open pipeline, weighted forecast (Amount × Probability), and coverage vs. quota, sliced by team, segment, or region.

  • Win/loss analysis. Combine opportunity stages with account attributes to see which segments, sources, or reps convert best — and where deals stall.

  • Rep performance & activity. Join task/event activity to closed deals to connect outreach effort with outcomes.

  • Train Alta on your real customers. With accounts, won opportunities, and industries synced, Alta learns what your best-fit customers look like to sharpen targeting.

Keep it in sync

  • The Sync status section shows Last sync (with Succeeded or Failed) and the Sync frequency.

  • Click Sync now to pull fresh data immediately (Sync triggered successfully). It's greyed out while a sync is running.

  • Use the overflow menu () to Disable, Enable, or Delete the connection.

Tips and common pitfalls

  • Sync only what you need. Salesforce orgs have hundreds of objects — enabling everything slows syncs and clutters your data. Start with accounts, contacts, opportunities, and leads, then add custom objects deliberately.

  • Permission errors come from Salesforce. If a table or field won't sync, the connecting user likely lacks read access (object- or field-level) to it.

  • Production vs Sandbox. Connecting a sandbox by mistake is a common reason numbers look wrong — confirm the org you authenticated.

  • Custom fields are included for synced objects, so your bespoke pipeline fields come along too.

  • Deleting is permanent — it removes all synced Salesforce data and config. Disable instead if you only want to pause.


Related

Did this answer your question?