Denodo - Connecting to a JSON file
This article provides step-by-step instructions on how to connect to a JSON file in Denodo.
- Go to the Denodo webpage.
- Log into Denodo.
- Open Design Studio for the appropriate environment.
- Open your VDB (virtual database).
- Navigate to Connectivity then Data Sources.
- Select the vertical ellipses next to the 01 - Data Sources folder.
- Select New.
- Select Data source.
- Select JSON.
Data Source Configuration
- Enter a descriptive Name with no spaces.
NOTE: Names will automatically be converted to lowercase. - For Endpoint access configuration, select Direct, where you configure the data route, or path, to the XML file.
- 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.
- If using HTTP Client, keep the HTTP method set to GET.
- 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.- Instructions to generate the Base URL for a file in Box.
- Instructions to generate the Base URL for a file in SharePoint.
- For Authentication, select the method you'd like Denodo to use to authenticate you as a user of that data.
- Click Test Connection.
- If the test is successful, click Save to save the data source.