Loading
Salesforce now sends email only from verified domains. Read More
Extend Salesforce with Clicks, Not Code
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Validate and Sync an External Data Source

            You are here:

            1. Salesforce Help
            2. Docs
            3. Extend Salesforce with Clicks, Not Code

            Validate and Sync an External Data Source

            After you configure an external data source, synchronize it to map its tables with external objects in your Salesforce org. The content and data of external objects appear in federated search, together with your Salesforce content and data.

            Required Editions

            Available in: both Salesforce Classic and Lightning Experience

            Salesforce Connect is available in: Developer Edition and for an extra cost in: Enterprise, Performance, and Unlimited Editions

            Files Connect for cloud-based external data sources is available in: Professional, Enterprise, Performance, Unlimited, and Developer Editions

            Federated Search is available in: Enterprise, Professional, Unlimited, and Developer Editions
            User Permissions Needed
            To create an external object from an external data source: Customize Application

            When you sync a large number of tables, you can select to execute the sync operation asynchronously as a background job and avoid connection timeout. You can view the list of sync operations performed as background jobs in the corresponding External Data Source page.

            Note
            Note
            • Syncing creates or overwrites Salesforce external objects that map to the external system’s schema. Syncing doesn’t copy any data into your Salesforce org or write data from your org to the external system.
            • Syncing is a one-time process. If the external system’s schema changes, the modifications aren’t automatically synced to your Salesforce org. To reflect the changes in the external system, resync the objects. After resyncing, full field-level security to the external objects is granted to all users who have the same profile as the user who initiated the resync.
            • Each org can have up to 200 external objects. External objects don’t count toward the amount for custom objects. Syncing fails if it causes your org to exceed 200 external objects.
            • For Salesforce Connect external data sources, make sure that you read and understand the sync considerations. See Sync an External Data Source for Salesforce Connect.
            1. From Setup, enter External Data Sources in the Quick Find box, then select External Data Sources.
            2. Click the name of the external data source.
            3. Click Validate and Sync, and confirm that the connection is successful.
            4. Select tables and click Sync to do the following for each selected table.
              • Automatically create a Salesforce external object.
              • Automatically create a custom field for each table column that’s compatible with a Salesforce metadata field type.
            Example
            Example The resulting external data source detail page includes a list of related external objects like this.
            external object screen after syncing

            See Also

             
            Loading
            Salesforce Help | Article