Denodo - Connecting to a JSON file

This article provides step-by-step instructions on how to connect to a JSON file 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 JSON.

Data Source Configuration

  1. Enter a descriptive Name with no spaces.
    NOTE: Names will automatically be converted to lowercase.
  2. For Endpoint access configuration, select Direct, where you configure the data route, or path, to the XML file.
  3. 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.
  4. If using HTTP Client, keep the HTTP method set to GET.
  5. Enter the URL for the file.
    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.
  6. For Authentication, select the method you'd like Denodo to use to authenticate you as a user of that data.
  7. Click Test Connection.
  8. If the test is successful, click Save to save the data source.


KeywordsDesign Studio VDB   Doc ID137387
OwnerLearning Systems SupportGroupUI Training and Development Resources
Created2024-05-16 11:46:08Updated2024-07-03 12:34:57
SitesUniversity of Illinois Training and Development Resources
Feedback  0   0