How to export data to FTP servers?

Export data to FTP servers

 

 

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

To export data to FTP servers

1. Open an existing pipeline or create a pipeline from the Home Page, Pipelines tab or Workspaces tab. You can bring your data from 50+sources.

2. On the Pipeline Builder page, once you have completed creating your data flow and applying the necessary transforms in your stages, you can right-click a stage and select the Add Destination option.

 

 

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



Notes 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.
4.  If your data contains columns with personal data, you can choose to include or exclude them in the PII columns section. You can also apply the required security methods to protect your data as follows.

A. Data masking  
Data masking hides original data with 'x' to protect personal information.
 
B. Data Tokenization  
Data tokenization replaces each distinct value in your data with a random value. Hence the output is statistically identical to the original data.
 
C. None
You can select none if you do not want to use any security method. You can choose whether to export these column using the corresponding check boxes.  


 

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.

Notes

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.

 

12. Now that you have added a destination, you may want to try executing your pipeline using a manual run at first. Once you make sure manual run works, you can then set up schedule to automate the pipeline. Learn about the different types of runs here.

Info
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?