How to
How to access your Pendula Activity Sync data in Domo

Activity Sync data that is stored in an Amazon S3 bucket can be accessed by analytics tools. These tools can be used to track, generate, and report on business metrics that are relevant to your business needs.

Domo is a cloud-based business intelligence platform that aggregates data from multiple sources, delivering real-time insights and interactive visualisations to empower data-driven decision-making.

This article shows how to Pendula activity sync data from an Amazon S3 bucket into Domo, so you can analyse and report on Pendula experiences.

Prerequisites

• You must have Administrator access to your AWS environment
• You must have the ability to add Connectors in your Domo environment

How to connect Domo to an Amazon S3 bucket

This procedure assumes you have already connected activity sync from your Pendula tenant to an Amazon S3 bucket.

The procedure covers

• adding permissions to your AWS User account to allow read access to the S3 bucket
• adding a connector in Domo to Amazon S3

Allow Domo to read the contents of your S3 bucket

1. Log into your AWS Account.

2. As an Administrator, open the Management Console.

3. Search for “Users” and select Users from the list of features.

4. Select the user that has permission to manage the Amazon S3 bucket you want to access.

5. In the Permission policies section, select Create inline policy from the Add permissions drop-down list.

6. Click the JSON button.

7. Copy and paste the following JSON into the Policy editor:

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

8. Replace the Resource values with the ARN (Amazon Resource Name) for the bucket you want to access.

9. Click Next.

10. Enter a Policy name that describes the policy.

11. Click Create policy.

You can now connect your Domo account to this bucket.

Add an Amazon S3 connector to Domo

1. Log into your Domo account.
2. In the top menu, select Data.
3. Click Connect Data.
4. Select Connectors to open the list of available connectors.
5. Search for Amazon S3.
6. Select the Amazon S3 Advanced Connector.
7. If you have existing Amazon S3 Accounts in your Domo instance, select Add account from the drop-down list. Alternatively, proceed to the next step.
8. Enter the ACCESS KEY for the AWS User that has permission to access the S3 bucket.
9. Enter the SECRET KEY for the AWS User that has permission to access the S3 bucket.
10. Enter the name of the S3 BUCKET you want to access.
11. Select the AWS REGION where the bucket is located from the drop-down list.
12. Click CONNECT. Domo will try to connect to your Amazon S3 bucket, using the credentials you have supplied. If any issues are encountered, they will be displayed at this time.
    After the connection is established, you can provide information about the data in the S3 bucket, to control how Domo imports it into a Domo database.
13. Select JSON from the WHAT FILE TYPE WOULD YOU LIKE TO IMPORT drop-down list.
14. In the FILE NAME field, enter the first part of the file name used in your S3 bucket. The first part of the file name matches the name of the S3 bucket. For example, if the complete file name is something like
    mybucketname-version-date-hash
    you would enter mybucketname into the FILE NAME field.
15. Select File name starts with the specified string from the FILE NAME MATCH TYPE drop-down list.
16. Select None from the FILE COMPRESSION TYPE drop-down list.
17. Select Yes from the ENABLE PARSING FOR LARGE JSON FILES drop-down list.
18. Click Next.
19. Define the schedule you want to use for importing the data.
20. Select Append as the Update method.
21. Click Next.
22. Enter a DATASET NAME.
23. Click SAVE AND RUN.

Domo will run an import of the data to create your initial database. Future imports will occur at the schedule you defined.

You can now use the Pendula activity sync data from your Amazon S3 bucket to create reports in Domo.