OBI Reporting on All Candidate Data in Database

Summary

OBI Reporting on All Candidate Data in Database

Content

We are trying to run a candidate detail report for all candidates that have an application in our system.

Opened an SR and was told:

Query limits 
10 minutes maximum run time / process time per query 
100,000 maximum retrieved rows per query for OBI 
65,000 maximum retrieved rows per query for Embedded Reporting 

Export limits 
100,000 maximum rows per export for OBI 
65,000 maximum rows per export for Embedded Reporting 
2,000,000 maximum cells per export (rows * columns = cells) 

 

Does anyone have a solution to run this data in a more time effective way?

We are trying to capture all data from candidate applications.