Microsoft Excel features calculations, graphing tools, pivot tables, and a macro programming language that allows users to work with data in many of the ways that suit their needs, whether on a Windows machine or a Macintosh machine.

This article walks through creating a DSN for SQL Analysis Services data in iODBC and accessing SQL Analysis Services data in Microsoft Excel, all on a machine running Mac OS X.

To use Kerberos delegation, set AuthScheme to KERBEROSDELEGATION.

By default, the data provider attempts to communicate with the SPN at the specified Url.

To specify another certificate, see the SSLServerCert property for the available formats.

Instead of retrieving metadata every connection, you can set the CacheLocation property to automatically cache to a simple file-based store.

When you configure the DSN, you may also want to set the Max Rows connection property.

This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations.

Place your connection properties at the beginning of odbc.ini.

To register an ODBC driver, modify the odbcinst.ini file.

Excel Data Analysis Add In Drivers Can Be

With iODBC, drivers can be available to only one user account or drivers can be available system wide.

You can find the correct odbcinst.ini in the following paths.

Excel Data Analysis Add In Driver For SSAS

The driver library is the.dylib file located in the lib subfolder of the installation directory, by default in ApplicationsCData ODBC Driver for SSAS.

Driver ApplicationsCData ODBC Driver for CDataliblibssas.odbc.dylib.

Using the CData ODBC Driver for SQL Analysis Services, you can easily pull your SQL Analysis Services data directly into Excel.

Once there, you can leverage all of the powerful features native to Excel to analyze, report, transform your SQL Analysis Services data, and more.

These cookies are used to collect information about how you interact with our website and allow us to remember you.

We use this information in order to improve and customize your browsing experience and for analytics and metrics about our visitors both on this website and other media.

Excel For Mac Data Analysis Add In