Business Objects  

With BUSINESSQUERY, you can access corporate databases from Excel spreadsheets using familiar business terms. All BUSINESSQUERY commands are available through extended Excel menus and toolbars. There is no need to switch to another product to access corporate data.

With BUSINESSQUERY for Excel, you can create reports and analyze data directly in Excel. The information you need is immediately retrieved from the database and copied into your spreadsheet where you can format and analyze it. The result is easy and intuitive access to information, all from within Excel.

To define a query, simply drag and drop the objects that represent your key business indicators within an intuitive, one-step query panel. When you run a query, BUSINESSQUERY automatically places the results into spreadsheet cells, so you don’t need to copy or export the results to Excel.

                source http://www.BusinessObjects.com