Denodo - Connecting to a XML file
This article provides step-by-step instructions on how to connect to an XML 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 XML.
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.
- If a Validation type is selected, the structure of the input XML file will be obtained from a Schema or a DTD. If “None” is selected, Denodo will analyze the XML document to infer its schema.
- Click Test Connection.
- If the test is successful, click Save to save the data source.
Creating the Base View
- Select Create Base View.
- Select Execution panel.
NOTE: The Query Results tab will appear and show the first 150 rows of data. - XML files are formatted in a way that makes directly viewing the base view for the data source impossible. We must Flatten the base view to be able to access the data.
- See the Flatten Views section of the Denodo - Creating Derived Views article for the steps to flatten these base views.