Tenant overrides

Contents[Hide]

1. Using tenant data connector overrides

1.1. Overview

This walkthrough shows you how to use data connector overrides to allow multiple tenants to share the same dashboard but have it display data that is specific to each tenant.

1.2. A typical multi-tenancy scenario

Dundas BI provides built-in support for SaaS (software-as-a-service) and multi-tenant deployment scenarios. This capability lets you provide viewing access to the same Dundas BI project and its dashboards across multiple tenants (where each tenant is one of your clients) using a single instance of Dundas BI. In this scenario, each tenant accesses the same dashboards but the data that is displayed is specific to the tenant. This is accomplished by having each tenant maintain its own database which contains the underlying data for the dashboards. All of the tenant databases have the exact same schema but different data values. At viewing-time, the correct database is referenced according to which tenant the viewer belongs to. This is possible because of data connector overrides which are configured per-tenant by the Dundas BI system administrator beforehand.

Important
When using a data connector with an override in a data cube, you will be unable to use the usually available data cube storage types (warehouse and in-memory).

1.3. Set up tenant data sources

Create a SQL Server database with a single table for the first tenant as follows:

  • Database name: DatabaseA
  • Table name: Products
    • Column: ProductID, int
    • Column: ProductName, nvarchar(50)
    • Column: ListPrice, decimal(18,2)

SQL Server database for the first tenant
SQL Server database for the first tenant

Create a SQL Server DatabaseB for the second tenant with the exact same schema (but different data) as above.

SQL Server database for the second tenant
SQL Server database for the second tenant

1.4. Create a new project and dashboard

Log on to Dundas BI as an administrator and create a new project (Project1) which will be accessible to all tenants. Make sure Project1 is the active project.

Create a new Project1
Create a new Project1

Create a new data connector (DataConnector1) using the SQL Server data provider for DatabaseA.

Then create a new dashboard (Dashboard1) by dragging the ListPrice and ProductName columns from DataConnector1 to the dashboard canvas.

A table visualization is displayed, showing values from DatabaseA.

Create a new Dashboard1
Create a new Dashboard1

Right click on Dashboard1 in the Explore window and check it in.

1.5. Add tenants and users

Go to the main menu and click Admin. Expand the SaaS / Multi-Tenancy section and click Tenants. (If you don't see this option, it means you aren't licensed for this feature.)

In the Tenants dialog on the right, click Add tenant.

Click Add tenant
Click Add tenant

In the Add Tenant dialog, enter the tenant name as TenantA

Enter a name for the tenant
Enter a name for the tenant

Expand the Seat Allocation section and add 5 reserved license seats for a Standard User.

Enter the seat allocation for the tenant
Enter the seat allocation for the tenant

Click Submit to add the tenant.

Repeat the above steps in order to add TenantB. The Tenants screen is updated with the list of tenants.

Two tenants have been added
Two tenants have been added

Tip
Every tenant that you create is given a unique ID (a GUID value). If you only know the ID of a tenant but not its name, you can search for it in the Tenants screen by pasting the ID in the Search box.

Next, go to the Admin screen, expand Account Service and click Accounts. Add a new account (UserA) and set its Tenant field to TenantA.

Add UserA account to TenantA
Add UserA account to TenantA

Similarly, add a new account (UserB) and set its Tenant field to TenantB. The list of accounts looks like this now:

Added UserA and UserB accounts
Added UserA and UserB accounts

As an aside, go to the Groups list. You'll see two groups corresponding to each tenant. You can edit the membership of a Tenant Administrators group in order to assign a user account as a tenant administrator. Tenant administrators have the ability to add new accounts to the tenant and assign available license seats to those accounts.

Tenant Administrators and Members groups
Tenant Administrators and Members groups

1.6. Add data connector overrides

Go back to the Tenants list and edit TenantB.

Click Add data connector override.

Click Add data connector override
Click Add data connector override

In the Open File dialog, select DataConnector1 and then click Submit.

Select DataConnector1 to override
Select DataConnector1 to override

In the DataConnector1 dialog, scroll down and update the settings required to connect to the SQL Server DatabaseB.

Update settings to connect to DatabaseB
Update settings to connect to DatabaseB

Click Submit. The data connector override is added to TenantB details.

Override for DataConnector1 is added to TenantB
Override for DataConnector1 is added to TenantB

1.7. View the dashboard as a tenant user

Log out of Dundas BI and log back on as UserA

View Dashboard1 and observe that it displays the correct data from DatabaseA.

Log out again and log back on as UserB.

View Dashboard1 and observe that it displays the correct data from DatabaseB.

UserB sees data from DatabaseB
UserB sees data from DatabaseB

2. Using tenant time dimension overrides

Tenant time dimension overrides allow for the time dimension property values to be changed per tenant. An example of this is if tenant A and tenant B have a different day in which they use for the start to the week. The following are the steps to apply a time dimension override:

  1. Select a tenant, and on the Tenant Details Screen select the Time Dimension Override button.

    Click the time dimension override button on the tenant details screen.
    Click the time dimension override button on the tenant details screen.

  2. Click the add override button.

    Click the add override button.
    Click the add override button.

  3. Select a time dimension to override.

    Select the time dimension to override.
    Select the time dimension to override.

  4. Select options to override.

    Select the time dimension options to override.
    Select the time dimension options to override.

3. See also

 

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri