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.
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:
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
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.
When you are making dashboards, you'll notice that, in addition to a dropdown for user groups, there is a dropdown for data sources:
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 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.