We’re thrilled to announce the launch of Multi-Data Source Connections in Databrain.

This new feature allows you to connect multiple data sources with identical schemas to a single workspace. Instead of creating separate dashboards for each client or database, you can now reuse one dashboard and instantly switch between data sources—all while maintaining consistent metrics and secure data handling.

Whether you’re scaling your embedded analytics solution or setting up multi-tenant analytics from scratch, Multi-Data Source Connections make it easier than ever to deliver accurate insights at scale.

Why is multi-data source connections a big deal for SaaS businesses?

The challenge: Many SaaS providers and businesses rely on embedded analytics to deliver data insights to clients or internal teams. These dashboards often pull data from separate databases or sources. Traditionally, this setup required duplicating dashboards, reconfiguring connections, and repeating updates for each data source—an inefficient and error-prone process.

The solution: With Databrain’s Multi-Data Source Connections, you can:

• Connect multiple databases with the same schema to one workspace.
• Switch between data sources using a simple dropdown menu.
• Maintain consistent dashboards and metrics across all sources.

This feature eliminates the repetitive tasks of managing multi-tenant analytics, empowering businesses to scale their dashboard software efficiently and securely.

Prerequisite for multi data-source connections:

Schema Consistency

To ensure seamless integration, all connected data sources must share:

• The same table names, columns, and relationships.
• Identical data types for each column.

This alignment allows metrics, formulas, and visuals to remain accurate across all sources.

Key Features

1. Unlimited Data Sources

Whether you manage a handful of clients or hundreds, Multi-Data Source Connections can scale to meet your needs. Attach as many data sources as needed to a single workspace for a truly scalable embedded analytics solution.

2. Instant Switching with Auto-Refresh

Switch between data sources instantly using a dropdown menu. Databrain automatically refreshes dashboards and visuals with the new data, keeping workflows smooth and efficient.

3. Secure Authentication

Each data source has its own credentials, securely stored by Databrain. This ensures that data for each client or branch remains isolated and protected.

4. Multi-Tenant Support

Databrain supports multi-data source connections irrespective of the tenancy models:

• Row-Level Tenancy: For shared databases with tenant data filtered by rows.
• Database Isolation: For separate databases or schemas dedicated to each tenant.
  
  

5. Reusable Metrics and Dashboards

Define metrics and formulas—such as Revenue by Product or Customer Retention Rate—once. These metrics work across all data sources, eliminating the need to rebuild calculations for each database. All you need to do is export these dashboards (including their metrics & formulas) and import them across all tenants irrespective of their physical location. 

Real-World Impact

Use Case: SaaS Provider with Embedded Analytics
A SaaS provider uses Databrain’s embedded analytics to offer dashboards to 100 enterprise clients. All databases follow the same schema—users, transactions, products, etc.—but house different data sets.

Before Multi-Data Source Connections:

• The provider had to create individual dashboards for each client.
• Updates to metrics or visuals had to be applied manually to every dashboard.
• Scaling analytics for new clients was time-intensive and error-prone.

With Multi-Data Source Connections:

• A single dashboard serves all 100 clients.
• Each client’s database is added as a data source in the workspace.
• Switching between client datasets is as easy as selecting a dropdown menu.
• The provider delivers consistent analytics faster and with less effort.

How to Get Started

1. Set Up a Workspace

Create a workspace with dashboards and visuals connected to your primary data source.

2. Add Additional Data Sources

Navigate to the data source management page and add details for each database. Confirm the schemas match to ensure seamless integration.

3. Test Connections

Switch between data sources in the dropdown menu to validate connections. Databrain automatically refreshes dashboards with the selected data.

4. Optional: Configure Tenancy

For multi-tenant environments, set up row-level security for shared databases or isolate tenants with separate database connections.

Why Databrain stands out

With Multi-Data Source Connections, Databrain enhances your embedded analytics and dashboard software by offering:

• Scalability: Manage analytics across any number of clients or branches.
• Consistency: Deliver uniform metrics and dashboards across all data sources.
• Security: Ensure each client’s data is protected and isolated.
• Efficiency: Onboard new clients or data sources in minutes, not hours.
• Reusability: 

This feature empowers businesses to eliminate redundant work, improve data governance, and scale their analytics offerings with confidence.

Take your analytics to the next level

Multi-Data Source Connections are now live in Databrain!

Get started today or schedule a demo to see how this feature can elevate your embedded analytics and streamline your dashboard software.