---
title: "Salesforce integration for HyperDB in Airtable"
slug: "salesforce-integration-for-hyperdb-in-airtable"
updated: 2026-04-24T21:56:50Z
published: 2026-04-24T21:56:50Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.airtable.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Salesforce integration for HyperDB in Airtable

| **Plan availability** | Enterprise Scale |
| --- | --- |
| **Permissions** | - Enterprise Admin - Integration Admin |
| **Platform(s)** | Web/Browser |
| **Related reading** | [Salesforce integration for bases](/docs/airtable-sync-integration-salesforce) |

## Salesforce integration for HyperDB in Airtable overview

The Salesforce HyperDB integration allows you to sync objects from Salesforce into Airtable. Because HyperDB is the destination for this integration, you can now sync much larger datasets than our standard Salesforce sync. One HyperDB table can contain up to 100M records.

The Salesforce integration is a one-way sync into HyperDB, so changes made in Airtable or HyperDB cannot currently be synced back into Salesforce—although you can use automations within bases to write back to Salesforce.

## Understanding the Salesforce integration for HyperDB

- The HyperDB integration is configured to run once every 24 hours—nightly, at 9PM Pacific time. Admins can also manually trigger data imports via the admin panel.
- The integration uses either OAuth authentication or Key Pair Authentication to access data in Salesforce. Configuring this for a Salesforce account/instance requires a one-time setup with account admin access to Salesforce and organization admin access in Airtable.

## Connecting Salesforce and Airtable

To connect Salesforce and Airtable:

1. Open your [admin panel.](https://airtable.com/admin)
2. Click **HyperDB**.
3. Click **Add table**.
4. Click **Salesforce**, then **Next**.
5. Select an account.

## Salesforce scopes

You can use your connected Salesforce external account across HyperDB, table sync, and automation integrations. Still, your connected external accounts are only visible to you. The following scopes are requested:

| Scope name | Scope purpose |
| --- | --- |
| id | Basic user info |
| refresh_token | To get a refreshed token |
| api | To access Salesforce object data through the rest api. |
| chatter api | Messaging capabilities: messaging peers and customers |

## Choosing Salesforce data to sync

After authenticating, you're asked to select the object types to sync from Salesforce. The following Salesforce object types are supported:

- Account
- Asset
- Campaign
- Case
- Contact
- Event
- Lead
- Opportunity
- Payment
- Task
- User

## Finalizing the Salesforce data connection

> [!CAUTION]
> NOTE
> 
> Unlike other integrations, the Salesforce integration auto-selects the “Id” column as the primary column. This Salesforce-generated field is guaranteed to have unique values for each row.

To finalize your Salesforce connection:

1. Choose a unique primary ID for the data set (text type required).
2. Make schema modifications to the import, like converting fields to single selects.
3. Choose a secondary search column for human-readable searches.
4. Optionally customize data types (though we recommend doing most type definitions within Salesforce)
5. Name your HyperDB table and provide a description.

![](https://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/unnamed-16(3).png)

![](https://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/unnamed-17(1).png)

## Supported Salesforce field types in Airtable HyperDB

- boolean
- date
- datetime
- double
- int
- string
- time
- currency
- email
- id
- percent
- phone
- picklist
- multipicklist*****
- reference
- textarea
- url
- address******
- location******

***** To properly integrate Salesforce multi-picklist fields into HyperDB and in-base syncs, importing multi-picklist cell values that contain double quotes (e.g., “) is unsupported. Please remove double-quote characters from your data to avoid errors.

****** Salesforce "Address" and "location" fields are imported as multiple fields, one for each component of the compound field. For example, the data in the "Account" object type's "BillingAddress" field will be imported as the "BillingStreet," "BillingState," "BillingCity," "BillingCountry," etc. fields.

## FAQs

**What immediately happens after creating a HyperDB table:**

After creating a HyperDB table, you should:

- Your data preview is available.
- Your initial data import may take some time to complete based on its size.
- Your data will automatically refresh nightly

**Why are some fields missing in the HyperDB table preview?**

If some fields are missing, confirm that these missing fields are included in the supported field types when using Salesforce integration for HyperDB in Airtable.

**What are the limitations of importing Salesforce multipicklist fields into HyperDB?**

To properly integrate Salesforce multi-picklist fields into HyperDB and in-base syncs, importing multi-picklist cell values that contain double quotes (e.g., “) is unsupported. Please remove double-quote characters from your data to avoid errors.