Denodo Consumers - Connecting to Excel

This article provides step-by-step instructions on how consumers can connect to Denodo using Excel.

In order to connect to Denodo using Microsoft Excel, you will first need to install the Denodo ODBC driver and set up a DSN on your computer. See this KB article for instructions on completing these preliminary steps.

  1. Open Excel, navigate to Data in the navigation ribbon and select Get Data > From Other Sources > From ODBC.
  2. In the Data source name (DSN) box, find the name of your 32-bit DSN (from the preliminary step above).
  3. Click OK.
  4. When the authentication window pops up, select Database, enter your NetID and AD password, and click Connect.
  5. Expand the folders to see the base views and integrated views from Denodo.
  6. Select which views to load and click Load.


Keywords:
DSN ODBS 
Doc ID:
138068
Owned by:
Learning Systems Support in UI Training and Development Resources
Created:
2024-06-24
Updated:
2024-07-02
Sites:
University of Illinois Training and Development Resources