Delta aggregation for JDBC connector

[Reshma_sonawane]

Which IIQ version are you inquiring about?

8.3

Hi Team,

We don’t have any separate table in database which stores delta changes. In this scenario, Is there any way to run delta aggregation for JDBC application which will just bring changes from database?

Thanks,

Reshma

[Arun-Kumar]

Hi @Reshma_sonawane,

You must configure a delta aggregation table in database to run the delta aggregation in JDBC application.

Regards,
Arun

[enistri_devo (Emanuele Nistri)]

Hi @Reshma_sonawane,

the delta aggrergation needs of those tables:

[vishal_kejriwal1 (Vishal Kejriwal)]

Db aggregation run based on the query added in SQL Statement , if you database has some information which can give you last modified / when updated then when you run the aggregation task and you can try adding another sequential task which can get you when you last ran aggregation and then modify the application configuration to add that in query .

[bhanuprakashkuruva]

@Reshma_sonawane ,

Just sharing one useful link for this. You can go through it if you need.

https://community.sailpoint.com/t5/IdentityIQ-Forum/Delta-Aggregation-on-JDBC/m-p/87224