Does Oracle Analytics DV 7.6 Support Pagination for REST API Data Sources?

Question

I am trying to connect Oracle Analytics DV to ServiceNow data using a REST API connection. However, the data volume is too large to retrieve in a single load. Does Oracle Analytics DV support pagination for REST API data sources? If so, how can I configure it to handle paginated responses from the API?

Any guidance or documentation references would be greatly appreciated.

Dhaval Parikh Stantec · Answer

True! :-( Till then, I can use some other workaround of using an Oracle Database (or another staging area) to fetch paginated API data before loading it into DV

Gianni Ceresa · Answer

The timing is maybe going to play against you: the OAS 2025 release is probably being packaged right now, therefore even if they do implement the feature, you will not have it in OAS before 2026. But at least it's there.

I imagine support for pagination can be handled by some attributes of each end point, because every REST API could have decided to handle it slightly differently. Therefore, technically possible, all a matter of priorities…

Dhaval Parikh Stantec · Answer

Thanks @Gianni Ceresa. I just posted an idea on the Idea lab

Add Native Support for REST API Pagination in Oracle Analytics DV (OAS/OAC) — Oracle Analytics