You can export files to FTP servers using the following steps.

To export data to FTP servers

3. You can search FTP under the All destinations tab or choose it from the Files category.

Note: If you had already added a FTP connection earlier, you can simply select the existing connection under FTP servers in the Saved connections section and proceed with exporting. To learn more about Saved data connections, click here.

5. Configure FTP connection to connect to the server and export the file. Enter the folder path in FTP server.

6.  Select an option from the FTP server type drop down as follows.

• FTP - File Transfer

• FTPS - File Transfer Over Implicit TLS/SSL

• FTPS - File Transfer Over Explicit TLS/SSL
  

• SFTP - SSH File Transfer Protocol
  

7. Enter the FTP server host. You can also enter the IP address or the FQDN (Fully Qualified Domain Name) of the server.

8. Enter the Username and Password if authentication is required.

The connection configuration will be saved for exporting data in the future. Credentials are securely encrypted and stored.

9. Give a name to your connection in the Connection name text box.

10. Click Next and do the following as required.

• You can choose to export the file in any of the supported file formats: CSV, TSV, JSON, XLS, XLSX and XML formats.
  

• Select the required option from the File export option drop down. You can choose to replace or update the file with a new version at the destination, or add as new file during export.

• Use the Compress file option to save your export as a .zip file.

• You can also encrypt the file and protect it with a password.
  
  
  
  

11 . You can also click the Advanced options link for the following options.

• You can encode the file using character encoding methods like UTF-8 using the File encoding option.
  

• You can use a Row Separator such as UNIX (Line Feed) or MAC (Carriage Return) to ensure the line endings are translated properly.
  

• You can distinguish the point at which the content of a text field begins and ends using Text qualifiers such as Single Quote(') or Double Quote(").
  

• You can separate out the data or split using a Delimiter such as a Comma(,) , Semicolon(;) , Space, Tab, or Custom.
  
  

Info: Each run is saved as a job. When a pipeline run is executed, the data fetched from your data sources will be prepared using the series of transforms you have applied in each of the stages, and then data will be exported to your destination. This complete process is captured in the Jobs page.

SEE ALSO

How to import data from FTP servers?
What other export options are available?

Learn about scheduling a pipeline.

How to export data to cloud database?