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.
Explo allows you to folder your data sources by schema to configure which queries run against which data sources. For more information, navigate to the Managing Schema section of our documentation.

View Data Sources

To view all connected data sources, navigate to the Data tab.
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. This view also allows you to toggle between different data sources within that schema.

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

Connecting User Groups to Data Sources

End User Group API

Every user group you create in Explo is associated with a specific set of data sources, one for each schema. When you render the dashboard for that user group, it will pull all data for that view from those data sources 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. This will associate the user group with that data source for the schema that data source belongs to. If you do not specify the data source, it will associate the user group with the default data source, which you can configure from the data page.
For more information, go to our section on the End User Group API
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

Customers Tab

On the Customers tab, there are dropdowns for choosing a data source for each schema when editing or creating a customer. If no data source is selected for a given schema, that customer will be associated with that schema's default data source.

Viewing Dashboards in Different Data Sources

When you are making dashboards, there is a dropdown for user groups.
For each dashboard, you will be able to toggle between different user groups to select which one you are viewing as. the data on the page will then reflect data from the data sources associated with that 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 sources and present the correct data.
Last modified 8mo ago