Database – How to connect to BusinessObjects

databaseodbc

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:

  1. "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.

  1. "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.

Best Answer

You want to look at the question a different way: what you want to do is capture the query that BusinessObjects is executing on the database server, and then run that same query yourself on the database server.

For example, if it's accessing data stored in Microsoft SQL Server, you can ask the database administrator to run Profiler to capture your queries while you're executing the report in BO. He can then give you the queries you ran, and you can execute those same queries in your own tools to get the results directly.

Update: I saw your edits, and what you're asking for just isn't possible. BOXI isn't a middleware tier for accessing millions of rows of data via ODBC. You either need to get the admins to allow you to export more data, or you need to connect to the underlying database.

Related Topic