Microsoft ® Office 2007 Business Intelligence

4.4. Importing Oracle Data into Excel 2007

Excel 2007 can be connected to a wide variety of non-Microsoft data sources. People often ask if Microsoft Business Intelligence tools work with Oracle or IBM DB2 databases—and the answer is yes! This is important because organizations usually have a wide variety of databases and formats—and yet most of us have Office. So if we realize that Office 2007 applications such as Excel can connect to these data sources, then we can use Office as a common front end to the data sources in our everyday work.

Front-end business intelligence tools—whether they are reporting, analysis, or measurement tools—should ...