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.
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 an ETL workflow and add a data extractor task to it. For a guide to creating this kind of workflow, see Building ETL Workflows.
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.
- Click Add a data destination.
- Search and select Load data to Amazon S3.
- 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.
- If you want to add new AWS account credentials, click Add a user account and follow the steps in the connecting an AWS account section.
- Click Next.
- Choose a Data source. This will be the extract data task you set up earlier.
- 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.
- Type the Bucket name where the file will be stored.
Attention: For bucket naming guidelines, see the AWS documentation.
- Select this option if you’d like to Encrypt files using PGP.
- When you’re finished, click Save.