Denodo - Connecting to an Excel file

This article provides step-by-step instructions on how to connect to an Excel file in Denodo.
  1. Log into Design Studio for the appropriate environment.
  2. Open your VDB (virtual database).
  3. Navigate to Connectivity then Data Sources.
  4. Select the vertical ellipses next to the 01 - Data Sources folder.
  5. Select New.
  6. Select Data source.
  7. Select Excel file.

Data Source Configuration

  1. Enter a descriptive Name with no spaces.
    NOTE: Names will automatically be converted to lowercase.
  2. For Data route, select HTTP Client if the data can be access from a website, or SFTP / FTP / FTPS if the data is on an ftp/sftp website.
  3. If using HTTP Client, keep the HTTP method set to GET.
  4. Enter the URL for the file.
    1. NOTE: If using a data source from a Box or SharePoint folder, you will need to complete some preliminary steps to set up those environments to interact with Denodo, as well as create the Base URL.
      1. Instructions to generate the Base URL for a file in Box.
      2. Instructions to generate the Base URL for a file in SharePoint.
  5. For Authentication, select the method you'd like Denodo to use to authenticate you as a user of that data.
    1. Leave Off if the file is open to the public.
    2. Select Basic if using a simple username/password.
    3. Select OAuth 2.0 if the data source is coming from a Box or SharePoint folder.
  6. In the Worksheets section, select whether you want Denodo to extract data from all sheets.
  7. You can specify a Start cell and End cell to the data.
  8. Select whether the data source has headers or not.


Keywords:
VDB Design Studio 
Doc ID:
137391
Owned by:
Veronica H. in UI Training and Development Resources
Created:
2024-05-16
Updated:
2024-07-08
Sites:
University of Illinois Training and Development Resources