Looking for some practical advice. I'd like to download about 10 million rows of data from a SAP BusinessObjects data warehouse. I don't have direct access to the underlying database(s). The problem is that when I build queries, the result usually times out before I can download any data. It seems that it chokes at about a million rows, so I'd like to divide the data into manageable chunks. I DO have the capability of writing queries in SQL directly, but I don' t think I am allowed to make temporary tables, So....
How do I write a query that downloads a fraction (say 5%) of the database each time I run it? Is there any way to automate this process and then cause it to download the results automatically? For that matter, is there any way to determine the underlying database?