---
schema_version: "1"
id: fa9ebc40b1421bde9ca2b2e2e6dce65d4e751374c7a5b614003fbfcd2572a335
title: Configure Incremental Sync for Salesforce Data
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_extract_data_incrementally_in_replication.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_extract_data_incrementally_in_replication.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 9eef05d63f61a2d1be0f717306ef32cb8b18b1d73f35c91dc291874e9f10724b
description: Before you run or schedule data sync, specify whether the sync extracts incremental changes or all records from each Salesforce object. By default, CRM Analytics performs an incremental sync. An incremental sync runs faster because it extracts only the latest changes to the Salesforce object.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Configure Incremental Sync for Salesforce Data

Before you run or schedule data sync, specify whether the sync extracts incremental changes or all records from each Salesforce object. By default, CRM Analytics performs an incremental sync. An incremental sync runs faster because it extracts only the latest changes to the Salesforce object.

During the first sync of an object, CRM Analytics always performs a full sync. Switching the site or migrating the org also triggers the object to undergo a full sync.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note When reviewing the results of an incremental sync job in Job Manager, the Rows in and Rows out values represent the total number of rows across all syncs.

1. In Data Manager, click the **Connections** tab.
2. From a local or external Salesforce connection, such as SFDC\_LOCAL, click ![Action button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_replication_actions_button.png) to the right of the Salesforce object that you want to sync, and then select **Edit Connection Mode**.
    
    Connection mode doesn’t apply to objects with other connection types.
3. Select one of these modes.<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
              <colgroup>
                <col style="width:50%">
                <col style="width:50%">
              </colgroup>
              <thead class="slds-text-title_caps ">
                <tr class="">
                  <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d140981e71">Connection Mode</th>
                  <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d140981e74">Description</th>
                </tr>
              </thead>
              <tbody>
                <tr class="">
                  <td data-label="Connection Mode" class="slds-cell-wrap" style="vertical-align:top;" headers="d140981e71 ">Incremental Sync</td>

                  <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d140981e74 ">
                    <p>Pulls only new, updated, and soft-deleted records to match the changes in
                      the Salesforce object since the previous sync. Use this method to run faster
                      syncs. </p>
                    <p style="margin-bottom:0;">Incremental sync doesn’t update records that are excluded through
                      Data Sync filters, and it doesn't remove hard-deleted records.</p>
                  </td>

                </tr>
                <tr class="">
                  <td data-label="Connection Mode" class="slds-cell-wrap" style="vertical-align:top;" headers="d140981e71 ">Periodic Full Sync</td>

                  <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d140981e74 ">Runs an incremental sync on each scheduled sync. Also runs a full sync on
                    the first sync that happens after Friday 11 PM in your org’s time
                    zone.</td>

                </tr>
                <tr class="">
                  <td data-label="Connection Mode" class="slds-cell-wrap" style="vertical-align:top;" headers="d140981e71 ">Full Sync</td>

                  <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d140981e74 ">Pulls all records from the Salesforce object and overwrites the records
                    from the previous sync.</td>

                </tr>
              </tbody>
            </table>
4. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)
    
    Note
    
    The API Type for the connector must be `BULKV2` for incremental and periodic full sync.
5. Save your changes.

## Considerations When Syncing Data Incrementally

- Incremental sync isn’t supported for Salesforce big objects or these objects.
    - CallCenter
    - CaseTeamMember
    - CategoryNode
    - CollaborationGroup
    - CollaborationGroupMember
    - CollaborationGroupMemberRequest
    - Division
    - Domain
    - DomainSite
    - Group
    - GroupMember
    - ModelFactor
    - Profile
    - Site
    - Territory
    - Topic
    - User
    - UserRole
    - UserTerritory
- Even if incremental sync is enabled, CRM Analytics performs a full sync when.
    - The object performs hard deletes or cascade hard deletes on records.
    - The object is known to fail when queried without a specific filter or where condition.
    - The object doesn’t have a datetime system field.
    - The object has fields or field attributes (such as scale and precision) specified for the sync that don't match the previously synced dataset. If you make field changes in an sfdcDigest dataflow node, such as adding or removing fields, or changing attributes, CRM Analytics triggers a full sync the next time that sync runs.
    - The object is configured for a periodic full sync.
    - The metadata of the object changes, triggering a full sync to update the object structure the next time the sync runs.
- Some objects, such as ContentVersion, delete records without notifying the incremental mechanism, which can result in data drift. Data drift is the potential for records to be included or excluded due to operations that run during a data sync run. For example, adding a record during a sync isn't always included or a hard record delete between incremental runs can be ignored. Selecting periodic full sync performs the reset required to keep the data sync object true to what appears in Salesforce.
- Verify that your org doesn’t have conflicting sync settings for the same object. For example, if incremental sync is turned off in an sfdcDigest node and not turned on in later nodes for the same object in the same dataflow, then a full sync is performed. To enable incremental sync, set the `incremental` parameter to `true` in the dataflow JSON.
- If multiple dataflows have conflicting sync settings for the same object, CRM Analytics uses the object’s sync settings from the last saved dataflow.
- Run full sync for objects containing formula fields. With incremental sync, formula fields can become out of sync with your synced object.
- Run a full sync manually if incremental sync fails for objects that have many updates. If incremental syncs continue to fail, set the object’s connection mode to **Full Sync**.
- To ensure that all updates are included, set the object's connection mode to **Periodic Full Sync**.