Need to Run delta and Full Aggregation

[poison001 (Deepak Kumar)]

I have set up AD Source with delta aggregation and configured the workflow to run disableoptimization. However, I actually need to run a full aggregation with disableoptimization, but it is currently running as a delta aggregation. In the workflow, I used the following API: https://sailpoint.api.identitynow.com/beta/sources/:id/load-accounts. Can someone please assist me with this?

[mohammedfavazhrb (Mohammed Favaz S A)]

Hi @poison001 ,

As per my knowledge, if you have enabled the delta aggregation option in source configuration then full aggregation will not happen.
So in order to achieve this, first you need to disable the delta aggregation using the workflow using update source API, then run the full disabled optimization aggregation and finally enable back the delta aggregation option.

update-source | SailPoint Developer Community

FYI, “deltaAggregationEnabled” setting is inside the “connectorAttributes” path of the source.

Thanks

[mehuljogi (Mehul Jogadia)]

Hi @poison001 ,

try using the import-accounts API endpoint(https://developer.sailpoint.com/docs/api/beta/import-accounts/) for full aggregation with disable optimization.

import-accounts | SailPoint Developer Community

The following posts will help you create workflows for unoptimized aggregation:

Workflow to trigger unoptimized aggregation

Unoptimized Aggregation Workflow.json (2.7 KB) Here is an example that triggers the aggregation. It also sends an email just for testing but that can be removed. Replace the tenant, sourceID(s) and add the client ID and Secret. [image]

Full Source Aggregation

Problem We schedule aggregations to automatically load new data on the source into Identity Now on a regular basis. If the source supports delta aggregation, we prefer using that option to lower the aggregation times and minimize load on the system. But, there are times when the system demands a full source aggregation to be run to pick up certain changes else the account in IDN remains unchanged. Example: OU Moves or Account deletions are only processed during full source aggregations. When de…

-Mehul

[jishnu_suresh]

Hi Deepak,

Another option is to create a powershell script to Run unoptimized aggregation through Rest API invocation and scheduling this to run as per your requirement. Please check the community post below.

POST /api/source/loadAccounts

Could you share the Powershell code you’re using and facing issue ?