Topics Map > Technology > Denodo

Denodo - Connecting to a Delimited File (.csv)

This article provides step-by-step instructions on how to add a delimited file data source in Denodo.
  1. Go to the Denodo webpage.
  2. Log into Denodo.
  3. Open Design Studio for the appropriate environment.
  4. Open your VDB (virtual database).
  5. Navigate to Connectivity then Data Sources.
  6. Select the vertical ellipses next to the 01 - Data Sources folder.
  7. Select New.
  8. Select Data source.
  9. Select Delimited 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, select 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. Expand the Authentication section.
  6. For Authentication, select the method you'd like Denodo to use to authenticate you as a user of that data.
  7. For Client identifier, copy and paste the Client ID from the application that will be interacting with Denodo.
  8. For Client secret, copy and paste the Client Secret from the application that will be interacting with Denodo.
  9. Instead of individually filling in the following fields, select Launch the OAuth 2.0 credentials wizard to help you obtain these credentials.
    NOTE: If this option is inactive or grayed out, go to the upper right and select Tools. Then select OAuth credentials wizards and select OAuth 2.0 wizard.

OAuth 2.0 Credentials Wizard

  1. Enter the authentication details.
    1. For Token endpoint URL,
      1. For files in a Box folder, enter: https://account.box.com/api/oauth2/token.
      2. For files in SharePoint folder, login to the Azure Portal, select your Application, select Endpoints and use the OAuth 2.0 authorization endpoint (v2) option.
    2. For Authorization server URL,
      1. For files in a Box folder, enter: https://account.box.com/api/oauth2/authorize.
      2. For files in SharePoint folder, login to the Azure Portal, select your Application, select Endpoints and use the OAuth 2.0 token endpoint (v2) option.
    3. For Redirect URI, leave the Redirect URI as the default selected, if you are connecting to Dev or QA (assuming you included all three when you created the Box app).
      NOTE: If you only added one Redirect URI and it is not for the environment you are creating the data source in, you can go back to the Box app and add more Redirect URIs.
      NOTE: If you are connecting to production, select Other and enter https://datahub.uillinois.edu/oauth/2.0/redirectURL.jsp.
  2. Add a Scope, if needed.
    1. For files in a SharePoint folder, enter: https://microsoft.sharepoint.com/AllSites.Read (found in the API permissions tab in the Azure Portal).
  3. Generate the authorization URL.
    1. Expand the 2. Generate the authorization URL section.
    2. Select Generate to generate the authorization URL.
    3. Select Open URL next to the generated Authorization URL.
      NOTE: you may need to allow access to the application at this step.
    4. On the Virtual DataPort OAuth 2.0 Credentials Wizard webpage, copy the URL.
  4. Paste the authorization response URL.
    1. Return to the Denodo OAuth 2.0 credentials wizard.
    2. Expand the 3. Paste the authorization response URL section.
    3. Paste the URL into the Authorization response URL field.
  5. Obtain the OAuth 2.0 credentials.
    1. Expand the 4. Obtain the OAuth 2.0 credentials section.
    2. Select OAuth 2.0 credentials.
      NOTE: A notification will appear notifying you that the OAuth2.0 credentials were successfully obtained.
    3. Select Copy the credentials to the clipboard.
      NOTE: Paste to a convenient, easily accessible location (such as Notepad) in case the Access token and Refresh token are not automatically filled out in the data source configuration. The copied credentials include client identifier, client shared secret, access token, and refresh token.
    4. Select OK.

Data Source Configuration (continued)

  1. Make sure the Access token and Refresh token are filled out.
  2. For Column delimiter, enter the character that separates the values.
    1. For a CSV file, enter a comma (,).
    2. For a tab delimited text file, enter \t.
      NOTE: Multiple delimiters can be listed with a space separating individual delimiters.
  3. Select the Header checkbox if your delimited data source file includes headers.
  4. Once the configuration has been completed, select Test Connection.
  5. Once the connection is successful, select Save to save the data source.

Creating the Base View

  1. Select Create Base View.
  2. Select Execution panel.
    NOTE: The Query Results tab will appear and show the first 150 rows of data.
  3. Verify that the data is returned correctly.


KeywordsDesign Studio   Doc ID136837
OwnerLearning Systems SupportGroupUI Training and Development Resources
Created2024-04-17 15:34:19Updated2024-07-03 12:08:43
SitesUniversity of Illinois Training and Development Resources
Feedback  0   0