Send data to Domo

Domo is a cloud-based, self-service BI tool that helps you visualize data from a single dashboard.

You can use a variety of data visualization workflows to analyze data in Domo. Send query results from Amperity to a customer-managed Amazon S3 bucket, and then load that data to Domo as a DataSet . You may also send query results to Databricks, and then use the Databricks Connector to load data to Domo.

This topic describes the steps that are required to send data to Domo from Amperity:

  1. Get details

  2. Add destination

  3. Add data template

Get details

Amperity can be configured to send data to a customer-managed Amazon S3 bucket .

Domo requires the following configuration details:

  1. The IAM access key.

  2. The IAM secret key.

  3. The Amazon Resource Name (ARN) for a role with cross-account access. (This is the recommended way to define access to customer-managed Amazon S3 buckets.)

  4. The name of the Amazon S3 bucket to which Amperity will send data and its prefix.

  5. The public key to use for PGP encryption.

Note

Amperity supports using cross-account role assumption with Amazon S3 buckets when Domo supports the use of cross-account roles and your tenant uses the Amazon S3 destination.

Add destination

Domo is a destination that may be configured directly from Amperity. This destination uses a customer-managed Amazon S3 bucket. Use the customer’s credentials to this Amazon S3 bucket when configuring this location.

To add a destination

  1. From the Destinations tab, click Add Destination. This opens the Add Destination dialog box.

  2. Enter the name of the destination and a description. For example: “Domo” and “This sends query results to Domo”.

  3. From the Plugin drop-down, select Amazon S3.

  4. The “iam-credential” credential type is selected automatically.

  5. From the Credential drop-down, select a credential that has already been configured for this destination or click Create a new credential, which opens the Create New Credential dialog box. For new credentials, enter a name for the credential, the IAM access key, and the IAM secret key. Click Save.

  6. Under Amazon S3 settings, add the name of the Amazon S3 bucket and the prefix. For example: “domo” and “path/in/customer-managed/s3/”.

  7. From the File Format drop-down, select CSV or JSON.

  8. Add a single character to be used as an escape character in the output file.

    Note

    If an escape character is not specified and quote mode is set to “None” this may result in unescaped, unquoted files. When an escape character is not specified, you should select a non-“None” option from the Quote Mode setting.

  9. Specify the encoding method. “None”.

  10. Add the PGP public key that is used to encrypt files sent to Domo.

  11. Set the quote mode.

    Note

    If the quote mode is set to “None” and the Escape Character setting is empty this may result in unescaped, unquoted files. When quote mode is not set to “None”, you should specify an escape character.

  12. Optional. Select Include success file upon completion to add a .DONE file to indicate when an orchestration has finished sending data.

    Tip

    If a downstream sensor is listening for files sent from Amperity, configure that sensor to listen for the presence of the .DONE file.

  13. Optional. Select Include header row in output files if headers are included in the output.

  14. Select Allow business users to use this destination.

    This allows users who have been assigned to the Amp360 User and/or AmpIQ User policies to use this destination with orchestrations and/or campaigns.

  15. Select Allow business users with limited PII access to send data.

    This allows users who have been assigned to the Restrict PII Access policy option to use this destination with orchestrations and/or campaigns.

  16. Click Save.

Add data template

A data template defines how columns in Amperity data structures are sent to downstream workflows. A data template is part of the configuration for sending query and segment results from Amperity to an external location.

You can configure Amperity to send query results to Domo. These results are sent using an orchestration and will include all columns that were specified in the query.

To add a data template for orchestrations

  1. From the Destinations tab, open the menu for a destination that is configured for Domo, and then select Add data template.

    This opens the Add Data Template dialog box.

  2. Enter the name of the data template and a description. For example: “Domo customer profiles” and “Send email addresses and customer profiles to Domo.”

  3. Enable the Allow customers to use this data template option. This allows users to build queries, and then configure orchestrations that send results from Amperity to a configured destination.

  4. Optional. Enable the Allow orchestrations from customers with limited PII access option. This allows users who have been assigned the Restrict PII Access policy option to send results from Amperity.

  5. Verify all template settings and make any required updates.

  6. Click Save.