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 workspace or open an existing workspace. Click here to see how to create a workspace.
2. Choose the FTP option in the Choose your data source section.
3. Give a connection name. Configure the FTP connection to connect to the server and fetch the file. You can enable the Import from local network toggle to import data incrementally. Click here to know more.
4. Select the FTP server type.
5. Enter the FTP server host. You can also enter the IP address or the FQDN (Fully Qualified Domain Name) of the server.
6. Enter the username and password if authentication is required.
Note: The connection configuration will be saved for importing data in the future. Credentials are securely encrypted and stored.
7. Give a name to your connection in the Connection name text box.
8. Click Import to upload data into Zoho DataPrep from the FTP server.
9. Once you have completed importing data, your dataset will open and you can start preparing your data right away.
Note: You can choose to schedule the import using the Schedule import option available for datasets in your workspace or from the Import menu in the top bar of the DataPrep Studio page. Click here to know more.
To edit the FTP connection
DataPrep saves your data connections to avoid the hassle of keying in the credentials every time you need to connect to a data source or destination. You can always edit the saved data connection and update them with new parameters or credentials using the Edit connection option.
1. While creating a new dataset, click Saved data connections from the left pane in the Choose a data source section.
2. You can manage your saved data connections right from the data import screen. Click the ellipsis (3 dots) icon to share, edit, view the connection overview, or remove the connection.
3. Click the Edit connection option to update the saved connection with new parameters or credentials.