# Difference between Delta aggregation and Unoptimized aggregation

**URL:** <https://developer.sailpoint.com/discuss/t/difference-between-delta-aggregation-and-unoptimized-aggregation/83675>\
**Category:** IIQ Discussion and Questions\
**Tags:** identityiq, aggregation, connectors\
**Created:** [October 3, 2024, 6:17am UTC](https://developer.sailpoint.com/discuss/t/difference-between-delta-aggregation-and-unoptimized-aggregation/83675 "2024-10-03T06:17:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![aseelvn07](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/aseelvn07/32/30068_2.png) [@aseelvn07](https://developer.sailpoint.com/discuss/u/aseelvn07)\
**Post date:** [October 3, 2024, 6:17am UTC](https://developer.sailpoint.com/discuss/t/difference-between-delta-aggregation-and-unoptimized-aggregation/83675/1 "2024-10-03T06:17:10Z")

</div>

## Which IIQ version are you inquiring about?

8.3

## Please share any images or screenshots, if relevant.

_[Please insert images here, otherwise delete this section]_

## Please share any other relevant files that may be required (for example, logs).

Below are two of the many options available in an account aggregation task.  
**Enable Delta Aggregation** - Enable the connector to aggregate only those accounts that have changed since the last aggregation. This requires support by the connector.  
**Disable Optimization of unchanged account** - Use this option to force all accounts to be aggregated, even if unchanged since the last aggregation.

## Share all details about your problem, including any error messages you may have received.

What is the difference between ‘Enable Delta Aggregation’ and ‘Disable Optimization of unchanged account’ options in the in Aggregation task?  
They both sound similar. If we enable both, then what is the result of the aggregation? As in only changed accounts will be aggregated or force all accounts to be aggregated?

---

<div class="post-metadata">

**Author:** ![enistriminsait](https://avatars.discourse-cdn.com/v4/letter/e/58f4c7/32.png) [@enistriminsait](https://developer.sailpoint.com/discuss/u/enistriminsait)\
**Post date:** [October 3, 2024, 6:23am UTC](https://developer.sailpoint.com/discuss/t/difference-between-delta-aggregation-and-unoptimized-aggregation/83675/2 "2024-10-03T06:23:47Z")

</div>

Hi @aseelvn07,

yes they sound similar, but are different.

we can say that Delta work on target side, Optimization on Sailpoint side.

With the Delta, IIQ request only changed object to the target system.  
With Optimization, IIQ recive all the data but work only on changed object.

For example, if you 50k account on AD but only 5k are changed, with delta IIQ receives the only 5k; with Optimization, IIQ receives 50k but will work on 5k.

You can use both for improve the performace.

PS Delta is not avaible for all target system or you must work on target system before the activation(ex. JDBC)

---

<div class="post-metadata">

**Author:** ![officialamitguptaa](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/officialamitguptaa/32/6624_2.png) [@officialamitguptaa](https://developer.sailpoint.com/discuss/u/officialamitguptaa)\
**Post date:** [October 3, 2024, 9:59am UTC](https://developer.sailpoint.com/discuss/t/difference-between-delta-aggregation-and-unoptimized-aggregation/83675/3 "2024-10-03T09:59:20Z")

</div>

### **Understanding Aggregation in SailPoint**

Before diving into the options, it’s helpful to understand what **aggregation** means in SailPoint:

- **Aggregation** is the process by which SailPoint connects to external systems (like HR systems, directories, or applications) to collect and import user account information into its identity warehouse.
- This process keeps SailPoint updated about who has access to what across all connected systems.

* * *

### **1. Enable Delta Aggregation**

**What It Means in SailPoint:**

- **Delta Aggregation** tells SailPoint to **only fetch and update accounts that have changed** since the last time it checked.
- When you **enable** this option, the connector (the bridge between SailPoint and external systems) will look for accounts that are new, modified, or deleted and only bring in those changes.

**Why It’s Useful:**

- **Efficiency** : Saves time and system resources because SailPoint doesn’t have to process every single account every time.
- **Performance** : Reduces the load on both SailPoint and the connected system, making the aggregation process faster.
- **Timeliness** : Quickly reflects recent changes in user accounts within SailPoint.

**Requirements:**

- The **connector must support delta aggregation**. Not all connectors have this capability, so you need to ensure that the one you’re using does.

**Analogy:**

- It’s like checking for new mail in your inbox. Instead of reading all your old emails every time, you only look at the new ones that have arrived since you last checked.

**Example in SailPoint:**

- Suppose you have an HR system connected to SailPoint. When a new employee is hired or an existing employee updates their information, enabling delta aggregation means SailPoint will import just those changes, updating its records accordingly.

* * *

### **2. Disable Optimization of Unchanged Accounts**

**What It Means in SailPoint:**

- By default, SailPoint might skip over accounts that haven’t changed to make aggregations faster—this is called **optimization**.
- **Disabling this optimization** means you’re telling SailPoint to **process every account** , regardless of whether it has changed since the last aggregation.

**Why You Might Use This:**

- **Data Accuracy** : Ensures that SailPoint’s records are fully synchronized with the connected system.
- **Detecting Missed Changes** : Captures any updates that might have been overlooked or not properly flagged in previous aggregations.
- **Compliance and Auditing** : Important when you need to verify that all account data is up-to-date for security audits or compliance requirements.

**Analogy:**

- Similar to doing a full inventory check in a store—you count every item to make sure your records match what’s actually on the shelves, even if you believe nothing has changed.

**Example in SailPoint:**

- After a system upgrade or data correction in your source system, you might disable optimization so SailPoint re-imports all account data, ensuring that no discrepancies exist between the systems.

* * *

### **Putting It All Together in SailPoint**

**When to Use Each Option:**

- **Enable Delta Aggregation** :

- **Disable Optimization of Unchanged Accounts** :

**Considerations:**

- **Performance Impact** :

- **Data Integrity** :

* * *

### **Scenarios in SailPoint**

**Scenario 1: Routine Daily Operations**

- **Situation** : Your organization has daily changes like new hires or role updates.
- **Action** : Enable delta aggregation.
- **Result** : SailPoint quickly imports only the changes, keeping data current without unnecessary processing.

**Scenario 2: Post-Maintenance or Data Correction**

- **Situation** : You’ve performed significant updates to user data or corrected issues in the source system.
- **Action** : Disable optimization of unchanged accounts.
- **Result** : SailPoint reprocesses all accounts to ensure its data matches the source system exactly.

**Scenario 3: Compliance Audit**

- **Situation** : An upcoming audit requires absolute certainty that all user access information is accurate.
- **Action** : Disable optimization to force a full aggregation.
- **Result** : Provides assurance that SailPoint’s data is fully up-to-date, supporting compliance efforts.

* * *

### **Key Takeaways for SailPoint Users**

- **Enable Delta Aggregation** :

- **Disable Optimization of Unchanged Accounts** :

- **Connector Compatibility** :

* * *

### **Practical Tips**

- **Before Enabling Delta Aggregation** :

- **Before Disabling Optimization** :

* * *

### **Conclusion**

In SailPoint, managing how you aggregate account data is crucial for balancing performance and data accuracy:

- **Use Delta Aggregation** when you need efficient, incremental updates.
- **Disable Optimization** when you need to ensure complete data synchronization, such as after major changes or for compliance reasons.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [December 2, 2024, 10:00am UTC](https://developer.sailpoint.com/discuss/t/difference-between-delta-aggregation-and-unoptimized-aggregation/83675/4 "2024-12-02T10:00:08Z")

</div>

Closed on December 2, 2024, 10:00am UTC

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.