FTP exports are a valuable way to deliver your Data Builder data tables to your own FTP or SFTP server. Data exports are available as a paid add-on on the Business, Grow, and Pro plans, and are included with the Custom plan when your negotiated agreement includes data exports. In this article, we will walk you through creating an FTP export, including connecting an FTP destination, choosing your data, scheduling data refreshes, and managing your exports to ensure seamless data transfer.

Step 1: Create Your Export and Choose the Destination

1. In your hub, select FTP from the left navigation pane under Exports.
2. Click + Create export. The Create export wizard opens and walks you through four steps: Destination, Data, Schedule, and Review.
3. Under Destination, select the FTP or SFTP account you'd like to use.
   • If you haven't yet connected your server, click the plus button to add a destination account. Select the type of FTP connection you want to use (FTP or SFTP), then enter a name for your server, its host (IP address or URL), and your FTP login username and password. Click Connect. Once the account is added, return to the wizard and restart the export setup.
4. Choose a file format for your exported files: CSV or JSON.
5. Enter the Directory Path you want to use on your FTP server, then click Next.

PMA interacts with your FTP server from the IP address 35.188.118.242 (also shown in the Help panel when connecting your server). If your server restricts access by IP, whitelist this address before connecting.

Step 2: Choose the Data to Export

A Data Table is a single table in Data Builder. A Dataset groups related data tables. Exporting a whole dataset sends every data table in it.

1. Under Data table or dataset, search for and select either a single data table or an entire dataset from Data Builder.
2. Click Next.

Step 3: Set Your Export Schedule

1. Choose a Refresh period: On demand, Monthly, Weekly, Daily, or Hourly.
   • On demand: Your export has no schedule and runs only when you run it manually from the exports list. Leave Run as soon as you create the export enabled to run the export immediately after you create it.
   • Monthly: Choose a day of the month (1 through 28), the hour, and the timezone.
   • Weekly: Choose a day of the week, the hour, and the timezone.
   • Daily: Choose the hour and the timezone.
   • Hourly: Your export runs every hour; no further settings are needed.
2. For scheduled refresh periods, the Timezone is required and determines the local wall-clock time at which your export will run. We suggest setting the time for an hour before the start of your workday. Your export will run on this schedule until you pause or delete it.
3. Click Next.

Remember: Each scheduled export will overwrite data in the date range of the Data Builder data table.

• To accumulate data over time, choose a date range with an end date of today or yesterday. When you are creating your data table in Data Builder, choose a Custom Start option under Date Range to accumulate data over time.
• Fixed time frame options like Last 7 days will export only the most recent 7 days of data with each refresh. Data from before that period will not be overwritten.

Step 4: Review and Create Your Export

1. Under Review, check the Destination, Data, and Schedule summaries. Click Edit on any card to make a change.
2. Click Create export. If you selected On demand and left Run as soon as you create the export enabled, your export runs immediately.

Manage Existing Exports

FAQ

What is the source IP?

What is the data format?