Skip to main content

​
Intro

You can use Domo’s DataSet Copy Advanced connector to copy data from one Domo instance to another. You do this in the Data Center. The DataSet Copy DataSet connector is a “File” connector, meaning it retrieves files and outputs them to Domo. In the Data Center, you can access the connector page for this and other File connectors by clicking File in the toolbar at the top of the window. There are two versions of this connector, a regular and an advanced version. The only difference between these is that the advanced version asks you for the username and password for the Domo instance you are copying from. Because of this, we do not provide separate documentation for the advanced version. This topic discusses the fields and menus that are specific to the DataSet Copy connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Connector.

​
Prerequisites

To create the credentials you need the Domo Client ID and Domo Client Secret. To obtain your Domo Client ID and Client Secret:
  • Log into the Domo developer account.
  • In the top right corner under My Account click New Client.
  • Enter the application name and description.
  • Provide the application scope by selecting the checkboxes for Data and User.
  • Click Create. Once you have created a client, you can manage the client by clicking on Manage Client.
  • Your Value will appear in the Manage Client section.
The DataSource ID of the data you want to copy. You can find the DataSource ID by opening the Details view for the DataSet in the Data Center. The ID is the number in the URL following “/datasources/”.

​
Configuring the Connector

This section enumerates the options in the Credentials and Details panes in the DataSet Copy Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Connector.

​
Credentials Pane

This pane contains fields for entering credentials to create a DataSet Copy account. The following table describes what is needed for each field:

Field

Description

Domo Client ID

Enter the Client ID for the Domo instance you are copying from.

Domo Client Secret

Enter the Client Secret for the Domo instance you are copying from.

For more information about obtaining the above credentials, see “Prerequisites,” above. Once you have entered valid credentials, you can use the same account any time you go to create a new DataSet Copy DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector/Adapter Accounts.

​
Details Pane

In this pane you enter details about the DataSet you want to copy.

Field

Description

Report

Select the report you want to run.

Report Name Description

Complete Data

Retrieves the data for all of the successful runs of the input dataset.

Incremental Data

Retrieves the incremental data for the input dataset.
If the input dataset is in Append mode then the incremental report will retrieve the data from the last successful runs.
If the input dataset is in Replace mode then the incremental report will retrieve the data only from the last successful run.

Input DataSet Id

Enter your Domo dataset ID(GUID) located in the dataset url. For example: https://customer.domo.com/datasources/ <strong>aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee</strong>/details/settings.

Only Updated Data

Choose ‘Yes’ to retrieve the data only if the dataset has run after the latest run of this copy dataset. This helps prevent stale data.

Use Dataset Schema Choose ‘Yes’ to use the schema from the input dataset for every run.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Connector.