Loading data into Domo

This guide explains how to load data into Domo for further analysis.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

Procedure

To load data from a datastream into Domo, you need to create a new Domo destination in Adverity, and then enter the credentials generated in Adverity in Domo.

This guide explains each of these processes in the sections below.

Creating a Domo destination

  1. Go to the Destinations page.

  2. Click + Create destination. This will automatically open a pop-up window on the right-hand side of your screen.

  3. In Name, enter a name for the destination.

  4. In the Date range drop-down menu, select the date range for which you want to include data in the data share:

    Fixed

    Select this option to load data for a fixed date range that does not depend on the current date into Domo.

    After selecting this option, click the date picker on the right and select a date range. To add data for the current date only, in the date picker, select the current date as the start and end of the date range.

    Moving end

    Select this option to load data for a date range that starts on a specific date and always ends on the current date into Domo.

    After selecting this option, click the date picker on the right and select the start data for the date range.

    Open end

    Select this option to load data for a date range that starts on a specific date and has no end date into Domo.

    After selecting this option, click the date picker on the right and select the start data for the date range.

    Last x days/weeks/months/quarters/years

    Select this option to load data for a specific amount of time before the current date into Domo.

    After selecting this option, in the field that appears next to the drop-down menu, enter the number of days/weeks/months/quarters/years before the current date for which to add data.

    All time

    Select this option to add all available data to the data share, from the first to the last date when data is available. This option may increase load times.

  5. In Dimensions, select the dimensions that you want to load into Domo. You must select at least one dimension.

  6. In Metrics, select the metrics that you want to load into Domo. You must select at least one metric.

  7. (Optional) In Filters, click + Add filter and define the data to load into Domo:

    Select dimension

    Select a dimension from your data extract or a dimension created by Adverity based on which you want to filter data.

    Operator

    Select a condition that the values of the filter must meet.

    Select value

    Enter the values for the filter.

    To create an additional condition for the filter, click + Add filter. The resulting filter is a combination of all conditions using AND logic.

    Applying dimension filters will reduce the amount of data included in the data share.

  8. (Optional) Click Data preview to preview the data that will be loaded into Domo.

    The preview displays up to 50 rows.

  9. Click Create.

  10. In the Destination credentials dialog that appears, copy the credentials for this new destination to finish setting up this destination in Domo.

Entering the destination credentials in Domo

To finish creating your new Domo destination, make sure you have copied the credentials shown in Adverity when you created the destination.

To find these credentials again, go to the Destinations page, click the name of the destination in the table, and then click View credentials.

To enter these credentials in Domo, follow these steps:

  1. Select the OData connector.

  2. Enter the username and password generated in Adverity.

  3. On the Details page, fill in the following fields:

    URL

    Enter the URL generated in Adverity and add /query to the end of the URL.

    Data Tag

    Leave the default value value in this field.

    Pagination Type

    Select the Server Based pagination type.

  4. (Optional) Set up a schedule to automatically update your data.

    To avoid duplicates, select the Replace update method.

  5. Enter a name for your dataset.

For more information, see the Domo documentation.