Issue with Aggregating Users from ServiceNow in SailPoint

Which IIQ version are you inquiring about?

8.4p1

Hi ALl,

We are currently facing an issue with the web service connector. The target system (ServiceNow table) has an account aggregation out of the box limit of 10,000 records. but we need to aggregate more than 10,000 user records from this table. Since we cannot make any changes on the ServiceNow Table side, is there any way to achieve this from the SailPoint side? Any help or suggestions would be greatly appreciated.

Thanks,

Ranjith M.

Hi @Ranjith25

Are you using sailpoint out if the box servicenow connector or web service connector if yes are using pagination?

Did you try running aggregation if it’s web service via postman are you seeing any issues

Hi @Ranjith25

If you are facing issue then you can use a staging table approach, write a custom java class to pull the data with pagination and store it into the Staging table.

Once the data is written into staging table, read through the JDBC connector.