Export data to FTP servers
You can export files to FTP servers using the following steps.
To export data to FTP servers
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.
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.
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?
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Import data from FTP servers
You can import files from FTP servers using the following steps. To import data using an FTP connection 1. Create a pipeline or open an existing pipeline from the Home Page, Pipelines tab or Workspaces tab and click the Add data option. You can also ...Export options
DataPrep offers a wide range of export options. Your data can be exported to BI tools, cloud storage services, cloud databases. They can also be downloaded as files in different formats. To export your data 1. Open an existing pipeline or create a ...Export data as files
You can export your data in various file formats which includes CSV, TSV, JSON, XLS, XLSX and XML formats. To export data as files 1. Open an existing pipeline or create a pipeline from the Home Page, Pipelines tab or Workspaces tab. You can bring ...Import data using saved data connections
DataPrep saves your data connections to avoid hassles in keying them often. To access your saved data connections 1. Create a pipeline or open an existing pipeline from the Home Page, Pipelines tab or Workspaces tab and click the Add data option. You ...Export data to cloud storage services
You can export data to the following cloud storage services. Google Drive OneDrive Box Storage Dropbox Zoho WorkDrive Amazon S3 To export data to cloud storage services 1. Open an existing pipeline or create a pipeline from the Home Page, Pipelines ...