About installing OLAP providers
To connect to third-party database products that provide OLAP data and services, you must install additional data source drivers and client software.
For information about installing and using a third-party OLAP provider, see your system administrator or contact the vendor for your OLAP product. After you install the provider, you can set up data sources in Microsoft Query to access the provider's databases. For more information about setting up data sources in Microsoft Query, see Microsoft Query Help.
To use the Microsoft Office features for working with OLAP data, the third-party product must be Microsoft Office-compatible. If you want to work with offline cube files, check if the third-party product supports this by creating a Microsoft Excel PivotTable report that displays source data from the third-party database. In the PivotTable report, the Offline OLAP command on the PivotTable menu (PivotTable toolbar) is unavailable if the provider does not support offline cube files.