I have the rights to log into a BOXI server and build queries and reports, but can only export 100,000 rows at a time.
I have tools on my desktop that can connect to databases via things like ODBC.
Is there a way to use ODBC or some other connection type to connect to BusinessObjects?
---Edit--- In response to the first two answers:
Thank you for your insight.
In a perfect world, I would be glad to connect directly to the database servers that BOXI is pulling data from, but I can not. The only access I have to the data is through BOXI.
I understand the row limitation is set by the BOXI admins, but they will not adjust it.
---Edit 2--- Answers to two more questions:
- "And you should think of it, what will you do with a query with more than 100k row ?"
I would like to analyze the data with tools on my desktop that are designed to connect directly to data sources.
- "Is there any valuable information in a 100k row answer ?"
I am not look for 100k rows to be my final answer, I am hoping to analyze millions of rows.
A better way to describe my issue:
I have access to data in BOXI, but it is limited in the amount of analysis I can preform, so I want to connect to the data in BOXI and analyze it with tools on my desktop.