Denodo - Connecting to an FTP/SFTP Site
This article provides step-by-step instructions on how to add a data source from an FTP or SFTP site 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 which type of file you want to connect to.
Data Source Configuration
- Enter a descriptive Name with no spaces.
NOTE: Names will automatically be converted to lowercase. - For Data route, select SFTP / FTP / FTPS Client.
- Enter the URL for the file, making sure to include two slashed between the top-level domain and the sub-directory.
Example: sftp://xferprod.admin.uillinois.edu//export/home/ibuydataout/test.csv - For Authentication, select the Use login and password.
- Enter the Login and Password to access the data on the SFTP site.
- For Column delimiter, enter the character that separates the values.
- For a CSV file, enter a comma (,).
- For a tab delimited text file, enter \t.
NOTE: Multiple delimiters can be listed with a space separating individual delimiters.
- Select the Header checkbox if your delimited data source file includes headers.
- Once the configuration has been completed, select Test Connection.
- Once the connection is successful, select Save to save the data source.