Load Data to Amazon S3 Task

About Loading Data into Amazon S3

Amazon Simple Storage Service (also known as Amazon S3) is a service where you can store data. You can import data from Qualtrics to Amazon S3 buckets. This import can happen on a regular schedule, allowing you to automate the upload of survey data, employees, contacts, or even data extracted from other third party services.

Connecting Qualtrics to AWS

You can connect Qualtrics to AWS by following the steps on the Extract Data from Amazon S3 Task page. The only difference is that when you select an extension, you should choose Load data to Amazon S3.

S3 Permission Required for an IAM role

IAM roles must have the following S3 permissions to connect their AWS account. For more details on S3 access management, see AWS’s documentation.

• • s3:ListBucket
  • s3:PutObject
  • s3:AbortMultipartUpload
  • s3:ListMultipartUploadParts

To learn how to connect Qualtrics to an Amazon Web Service (AWS) account, see Adding an AWS Account.

{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:ListBucket"
],
"Resource": [
"arn:aws:s3:::s3bucketname"
]
},
{
"Effect": "Allow",
"Action": [
"s3:PutObject",
"s3:AbortMultipartUpload",
"s3:ListMultipartUploadParts"
],
"Resource": [
"arn:aws:s3:::s3bucketname/*"
]
}
]
}

Extract Data to Upload to Amazon S3

Before you can upload data to your S3 bucket, you need to extract it from someplace. Consider where your data currently lives; is it inside a survey or XM Directory? Or is it not inside Qualtrics at all, but a third party, such as Salesforce or Google Drive?

Create a workflow and add a data extractor task to it. See a full list on Available Extractor Tasks.

Load Data to Amazon S3

Once you’ve created a workflow and added your data extraction task, it’s time to upload the data into Amazon S3.

1. Click the plus sign ( + ) under your extraction task, and select Task.
   
2. Search and select Load data to Amazon S3.
   
   
3. Choose the Amazon Web Services (AWS) account to extract files from. Any accounts added by Brand Administrators, as well as accounts you’ve added yourself, will be listed here.
   
4. If you want to add new AWS account credentials, click Add new account and follow the steps in the connecting an AWS account section.
5. Click Next.
6. Choose a Data source. This will be the extract data task you set up earlier.
   
7. In S3, bucket ‘folders’ are called prefixes. In the File name prefix box, add the full bucket prefix as well as a prefix for the file itself.
   Example: To put the file in this location: bucketname/QualtricsPrefix/ with the filename prefix “example”, enter QualtricsPrefix/example into the file name prefix box.
   Qtip: If your IAM policy specifies that Qualtrics can only write to a specific S3 bucket prefix (for example, “arn:aws:s3:::s3bucketname/QualtricsPrefix/*”), make sure the prefix matches here.
8. Type the Bucket name where the file will be stored.
9. Select this option if you’d like to Encrypt files using PGP.
10. When you’re finished, click Save.