Multiple Data Sources

This guide describes how to configure Explo to support multiple data sources

Why Multiple Data Sources?

There are a few different reasons why you may want to connect multiple data sources to Explo:

  • You want to connect and build dashboards against both your staging and production databases

  • You have customer data segmented into multiple different databases

In either of these scenarios, you can use Explo to connect multiple data sources to power your dashboards.

Note, each data source that you connect to Explo must have the same schema in order for things to work as expected. All dataset queries and visualizations you configure in dashboards must run correctly against every data source you add

View Data Sources

To view all connected data sources, navigate to the Data tab.

Data tab in Explo

Note that the first data source you connect to Explo during the onboarding process will be the Default data source that is used.

On this page, you will see all connected data sources. If you click on a specific data source, you will be taken to a data viewer where you can preview the data in the data source:

Data Source data viewer

Add a Data Source

On the Data tab, click the "Add Data Source" button to add a new data source. On this flow, you will be asked to enter the data source credentials, similar to how you added the initial data source

Connect Data Source form

Connecting User Groups to Data Sources

Every user group you create in Explo is associated with a specific data source. When you render the dashboard for that user group, it will pull all data for that view from the data source associated with the user group.

When you create a user group via the API, you can optionally specify a data_source_id or the data_source_provided_id. If you do not specify the data source, it will associate the user group with the default data source, the first data source you connected to Explo.

You can retrieve the data default data_source_id by going to the data tab and looking at the number ID for the data source (213 :

Example data sources with IDs

You can assign a data_source_provided_id in the data tab which then can be used to identify the data source in your API requests:

Selecting to rename the provided ID
Providing an ID to the data source
Updated ID provided to use

Viewing Dashboards in Different Data Sources

When you are making dashboards, you'll notice that, in addition to a dropdown for user groups, there is a dropdown for data sources:

Switching between data sources on the dashboard edit page.

For each dashboard, you will be able to toggle between the different data sources to select which one you are viewing as. When you switch data sources, the user groups you can view as filter down to just the user groups associated with that data source.

The data on the page will then reflect data from that data source and user group.

Embedding with Multiple Data Sources

Embedding with multiple data sources is as straightforward as with a single data source.

When you create your user groups, we will give you back the user group token. Simply provide this token when embedding and we will query from the right data source and present the correct data.