You connect to data that's stored on FTP or SFTP servers by configuring a connection to the server, selecting the desired spreadsheet, and creating a data feed. Then, using the data feed, you can visualize your data in custom metrics.
Note: We support the following file formats: XML, RSS, CSV, Excel, and JSON.
This article includes:
- Creating a data feed that connects to data from FTP or SFTP servers
- Next steps - Creating custom metrics
Creating a data feed that connects to data from FTP or SFTP servers
To create a data feed for data that's stored on an FTP or SFTP server:
- Add a new data feed by clicking the + button beside Data Feeds in the left navigation bar. (See below.)
- Click Select data.
- On the Where is your data? page, under Core Data Services, click FTP & SFTP. (See below.)
- Type the Host name for the FTP or SFTP server.
- Type the Port number for the FTP or SFTP server. The default port is 21.
- Provide a valid Username and Password.
- Provide a Start Path. For example, \.
- Use the drop down menu to select the correct Protocol setting.
Optional: Select Enable passive mode, if required.
- Click Connect.
- From the Pick a file window, select a file.
- Click the Get File button.
- Verify the correct content was uploaded, then click Continue.
- You're taken to the data feed editor, where you can make changes to the data feed or save it as-is.
- Give the data feed a name and, optionally, enter a description.
- Click Save data feed.
Next steps - Creating custom metrics
Now that you've created one or more data feeds that connect to data in an FTP or SFTP server, you can return to them and use them to make custom metrics. A single data feed can be used to create a single or multiple custom metrics.
To create custom metrics using a data feed:
- In the left navigation sidebar, click Data Feeds to open your list of data feeds.
- Select the data feed you want to use for your custom metric.
- Click either the +Add metric button in the top right corner of the window or open the Metrics tab and click +Add metric. (See below.)
- Choose settings for your custom metric and click Save metric. If you need help, go here to learn more.
The metric is added to your list of metrics, accessed by clicking Metrics in the left navigation sidebar.