SFTP Configuration

SFTP, or Secure File Transfer Protocol, is a secure method for transferring files over a network. It operates over SSH (Secure Shell), providing encryption to protect data during transmission. SFTP allows users to upload, download, and manage files on remote servers securely, ensuring confidentiality and integrity in data exchanges.

 

Basic Working of SFTP


SFTP works by establishing a secure connection between a client and a server using the SSH (Secure Shell) protocol. Here’s a brief overview of how it functions


Connection Establishment: 

The client initiates a connection to the server using the SFTP command. The default port is 22.


Authentication: 

The server authenticates the client through methods like username/password or SSH key pairs. This step ensures that only authorized users can access the server.


Secure Channel Creation: 

Once authenticated, a secure encrypted channel is established, protecting data from interception during transmission.


File Operations: 

Users can perform various operations such as uploading, downloading, renaming, and deleting files using SFTP commands.


Data Transfer: 

Files are transferred over the secure channel, ensuring both confidentiality and integrity.


Session Termination: 

After completing the file operations, the client can terminate the session, closing the secure connection.


This process ensures that all data exchanges remain secure throughout the transfer.


Setting-up an SFTP Server in SheetKraft

Following are the methods used to configure SFTP

1) Using Username & Password

To Set-Up an SFTP connection in SheetKraft, follow the below steps:

• Locate Installation Directory: Navigate to the Runner folder in the SheetKraft installation.

• Open Configuration File: Find and open the ConfigEditor.exe

• Select FTP Connection option: Within the config file, look for the option to set up SFTP and FTP

• Fill Required Fields: Add a name for the connection in the blank space provided and click on Add button. it will create a new connection name once done when user clicks on (…) button a pop-up screen will appear prompting you to enter the following information:

• Host: Enter the IP address or URL provided by the client.

• Port: Input the port number as specified by the client. The default port is 22.

• Username: Enter the username provided for the SFTP connection.

• Password: Fill in the password associated with the username.

• Test Connection: Once all required fields are filled, click the Test button located at the bottom right of the pop-up. This action will initiate the connection test.

• Connection Confirmation: If all fields are accurate, the test will pass, and the SFTP connection will be established successfully.

• The Fingerprint (alpha-numeric code) gets generated automatically post successful connection 

By following the above steps, you can successfully set up an SFTP connection in SheetKraft.