Export data to FTP servers

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

To export data to FTP servers

1. Click the Export now option from the Export menu in the DataPrep Studio page.

2. 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.

3. 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.

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

5. 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

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

7. 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.

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

9. 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.

10 . 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.

11. Once you input the required values, click Export.

12. Once the export is completed successfully, you can also choose to schedule the export using the Schedule this export? checkbox.

13 . To schedule export,

Select a Repeat method (Every 'N' hours, Every day, Weekly once, Monthly once) and set frequency using Perform every dropdown.

You can also select the Time zone to export data. By default, your local timezone will be selected.

Click Save.

Click here to know more about Schedule export.

Learn about scheduling export.

How to export data to cloud database?