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

Dhaval Parikh Stantec

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.

Gianni Ceresa

As far as I know there isn't any setting for pagination of REST calls, and I doubt it does magically handle it (if it was the case, you wouldn't be asking).

The REST connector is still defined as "preview", therefore it's possible that support for pagination could be added in the future.

The best you can do for now is to search in https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server to see if an idea to support pagination already exists and upvote it. If none exists, then post the idea.

Dhaval Parikh Stantec

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

Gianni Ceresa

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

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