Amazon S3 

Amazon Simple Storage Service (Amazon S3) is an object storage service that offers industry-leading scalability, data availability, security, and performance.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

To connect to Amazon S3, you need permissions in AWS Identity Access Management (IAM) that allow you to create policies, create roles, and attach policies to roles. This is required to grant the authorization to your S3 bucket:

• Creating an IAM policy.
• Creating an IAM Role.

Creating an IAM policy

An IAM policy is JSON-based access policy language to manage permissions to bucket resources.

To create the IAM policy:

1. In AWS, navigate to the IAM service by clicking the Services menu and typing IAM.
2. Click IAM once it displays in the results.
3. Click Policies in the menu on the left side of the page.
4. Click Create Policy.
5. In the Create Policy page, click the JSON tab.
6. Select everything currently in the text field and delete it.
7. In the text field, paste the following JSON and replace MyBucketName by the name of your bucket:

   {
       "Version": "2012-10-17",
       "Statement": [
           {
               "Sid": "",
               "Effect": "Allow",
               "Action": [
               "s3:GetObject",
               "s3:ListBucket"
               ],
               "Resource": [
               "arn:aws:s3:::MyBucketName",
               "arn:aws:s3:::MyBucketName/*"
               ]
           }
       ]
   }

8. Click Review policy.
9. On the Review Policy page, give the policy a name. For example: qlik_amazon_s3.
10. Click Create policy.

Creating an IAM role

1. In AWS, navigate to the IAM Roles page.
2. Click Create Role.
3. On the Create Role page:
   1. In the Select type of trusted entity section, click the Another AWS account option.
   2. In the Account ID field, paste 338144066592.
   3. In the Options section, select the Require external ID checkbox.
   4. In the External ID field that displays, paste qlik_connection_<tenant-id> and replace <tenant-id> by your tenant ID.

      To find your tenant ID, see Finding tenant information.

   5. Click Next: Permissions.
4. On the Attach permissions page:
   1. Search for the policy you created in the Creating an IAM policy.
   2. Once located, check the box next to it in the table.
   3. Click Next: Tags.
5. If you want to enter any tags, do so on the Add tags page. Otherwise, click Next: Review.
6. On the Review page:
   1. In the Role name field, paste qlik_s3_<tenant-id> and replace <tenant-id> by your tenant ID.

      To find your tenant ID, see Finding tenant information.

   2. Enter a description in the Role description field. For example: Qlik role for Amazon S3 integration.
   3. Click Create role.

Defining the search pattern

The Search Pattern field defines the search criteria Qlik should use for selecting and replicating files. This field accepts regular expressions, which can be used to include a single file or multiple files.

When creating a search pattern, keep the following in mind:

• When including multiple files for a single table, each file should have the same header row values.
• Special characters such as periods (.) have special meaning in regular expressions. To match exactly, they will need to be escaped. For example: .\
• Qlik uses Python for regular expressions, which may vary in syntax from other varieties. Try using PyRegex to test your expressions before saving the integration.
• Search patterns should account for how data in files is updated. Consider these examples:

customers\.jsonlCopy code to clipboard

(customers-).*\.csvCopy code to clipboard

File requirements

Creating the connection

For more information, see Connecting to SaaS applications.

1. Fill in the required connection properties.

2. Provide a name for the connection in Connection name.

3. Select Open connection metadata to define metadata for the connection when it has been created.

4. Click Create.