Configuring an SFTP Connection
Updated
Secure File Transfer Protocol (SFTP) is widely used as a data connector in various applications to securely transfer files between systems, especially when integrating data sources or destinations. Setting up an SFTP connection requires several key components, including the host name, port, authentication credentials, and directories for file transfer. These elements work together to establish a secure and reliable connection for data exchange. This guide is a walkthrough on how you can configure an SFTP that can be used to ingest data into the Sprinklr platform.
Note: You must fill out the fields on the Entity Selection and Entity Specific Settings screens, and choose SFTP in the Source Selection screen before you can access the Source Specific Settings screen. Check out these pages for details on setting up a Data Connector and obtaining permission:
Configuring SFTP in the Source Specific Settings Screen
Click Next to bring up the Source Specific Settings screen after choosing SFTP from the Source Selection screen and entering all the necessary information. You can set up SFTP as an entity source to be utilised for ingesting data into your platform under the Source Specific Settings screen.
Fill the following fields in the Source Specific Settings screen. Filling these details in the Source Specifications Screen unlocks the directory path from where you can import files.
Fields | Description |
Host Name | This is the remote server's IP address or domain name that you wish to connect to. For instance, "sftp.sprinklr.com" identifies the server hosting the SFTP service. |
Port | This refers to the network port used to establish the connection. |
Username | The username is used to authenticate your identity on the remote server. It is a required credential that allows the server to verify who is attempting to access the files. This could be a pre-assigned username that you must input to gain access. |
Authentication Type | Password: The user provides a password to authenticate and establish the connection. Private Key: For a more secure connection, key-based authentication makes use of cryptographic keys as opposed to password-based authentication, which depends on a user supplying a password. |
Source Files Directory Path | This refers to the specific source location on the remote server where the files are either read from or written to. The source directory path must be defined to ensure the correct handling of files, whether they are being uploaded or downloaded during the file transfer process. |
Successful Files Directory Path | This refers to the directory path where the successfully ingested files will be placed. |
Failed Files Directory Path | This refers to the path where the files that were not ingested will be placed. |
IP Whitelisting
If the selected source is SFTP and the SFTP location is owned by the partner, the following Sprinklr IP addresses must be whitelisted to allow Sprinklr to access the SFTP location. IP whitelisting can be done by the partner's IT team.
Note: Ensure to enable the Connect via Sprinklr Proxy toggle in the Advanced Settings section once the IPs have been whitelisted by the partner.
Environment | IP address |
Prod | 54.209.94.94 , 54.84.223.236 , 54.210.111.111 , 54.209.35.117 |
Prod10 | 34.86.137.226 |
Prod11 | 3.24.226.173, 52.62.250.127 |
Prod12 | 107.23.170.14, 18.215.74.5 |
Prod0 | 52.6.41.147, 52.0.225.196 |
Prod2 | 54.209.94.94, 54.84.223.236, 54.210.111.111, 54.209.35.117 |
Prod3 | 54.209.94.94, 54.84.223.236, 54.210.111.111, 54.209.35.117 |
Prod4 | 13.232.194.203, 3.7.126.101, 13.232.57.235, 3.7.14.199 |
Prod8 | 35.186.176.41, 34.86.83.44 |
Prod15 | 3.28.86.111, 3.28.103.81 |