Amazon S3

Our platform enables you to quickly and easily connect your data sources to data from a File Key/Location in Amazon S3 Storage.

This enables a one-way synchronization to occur – where any changes in the Amazon S3 Storage File Key/Location are downloaded into your data source on a regular basis.

Your data source will be automatically updated in this way until you remove the connector or an error occurs (such as losing authorization to access the file).

Note: You need to have configured a Connection to your Amazon S3 Storage account before adding a Connector.

• Adding an Amazon S3 Data Source Connector
• Configuring an Amazon S3 Data Source Connector

---

Adding an Amazon S3 Data Source Connector

Navigate to the Settings page of the data source you’d like to import rows into.

• Connected Data>Data Sources
• In the list of available data sources, hover your mouse over the listing of the data source you wish to connect.
  A set of options will show, click on the Settings link.

• On the Settings page, after Basic and Advanced Options is the Connector option, click the Add Connector link.

  
  

• A new window with connectors to choose from will appear, click the Amazon S3 Storage option.

  

The page should refresh with your newly added connector to be configured.

---

Configuring an Amazon S3 Data Source Connector

Next, configure the following:

• Bucket Name
  Enter the name of the Bucket the file is stored in.
• File Key/Location
  Specify the location which uniquely identifies the file within the S3 bucket.
  For example:
  Development/Projects1.xls
  Finance/statement1.csv
• Refresh Frequency
  The frequency that data is pulled by this connector.

Note: Data must be in .csv or .xlsx format and cannot contain formulae. The spreadsheet must exist in your connected Amazon S3 Storage account.