How to connect File from SFTP to Adriel

Detailed instructions to help you set up the data source for File from SFTP

Lastly modified on: Fri, 21st June, 2024 at 02:25 PM

Supported Service

• CSV and XLSX file type are supported.

Prerequisites

• SFTP Server User
• SFTP file

Instructions

1. Move to Adriel's Connections page.
2. Type “File from SFTP” into the search bar.
3. Fill in the 2 required fields and 1 optional field below accordingly to the file that you want to connect to Adriel.
   - (Required)User Name: SFTP server username
   - (Required)Upload Folder Name: Location where files are stored in the SFTP server
   - (Optional)SFTP Server Host Name: static IP like ‘11.22.33.44’ or ‘static@domain.com’
4. Fill in the 2 required and 1 optional fields below for data source settings.
   - (Required)Name: Data source name that is shown on the dashboard
   - (Required)File Type: Select between CSV or XLSX
   - (Optional)File Name to Filter: Part of the file name that is used to filter and stack the data in one table
   - ex) By entering 'Adriel', all files including 'Adriel' will be filtered.
   - The name is case-sensitive, so please follow the capitalization written on the file names.
   
   - (Optional)Alternative Channel Name: Alternative name for the data source
   - No icon is provided as a default for this feature. However, there are channels that can use internally saved icons and display next to the channel name you just wrote down. 
   
   - Refer to this guide to input the correct name to display the icon. 
   https://academy.adriel.com/en/how-to-set-alternative-channel-name-for-file-db-data-source
5. Click the “Submit” button below to complete the data connection.
    
   It can take up to one working day for your data to arrive.