Enhance Efficiency: Embed Bold Reports with Multitenancy
Tags: multitenancy, reporting, reportingtool, boldreports
Published: 2023-10-24 09:43:55

Multitenancy enables multiple teams or customers to share a single instance of an application while maintaining isolation and security using an organized software architecture. It is both cost-effective and easily scalable, helping businesses save money and grow.

In this blog, we’ll explore what multitenancy is, its benefits, and how to set up multitenancy with the Bold Reports Report Server.

**What Is Multitenancy?**
Multitenancy is a software architecture design that allows a single instance of an application to serve multiple tenants or users, each with their own isolated and secure environment. In the context of reporting and analytics, it means that you can provide different organizations, departments, or users access to the same reporting tool while ensuring data segregation and security.
![Multitenancy](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0mw52rxqq7382hr8b34j.png)

**Benefits of Multitenancy**
**Cost-Efficiency**: One resource can serve the reporting solution to multiple teams or companies, and by sharing resources and infrastructure, you can reduce operational costs.

**Scalability**: It is easier to scale a single system without spending more on resource allocation and without the need for assistance from the infrastructure team to set up new items. This will be helpful for scaling multiple teams or companies with a single instance.

**Data Security**: Multitenancy allows you to maintain strict data isolation between tenants. This ensures that one tenant’s data is inaccessible to others, providing robust data security and privacy.

**Ease of Maintenance**: Managing a single instance is much simpler than maintaining multiple separate installations. Updates, patches, and maintenance tasks become more efficient and cost-effective.

**Steps to Create a Multitenant with Report Server**
In this blog, I am going to explain how to set up multiple tenants for the clients of a company.

Let’s assume that the company ABCD Corporation provides an asset management solution, and they want to create a reporting solution to present asset management information in the form of reports. The company will develop standard reports for their clients, but these reports’ data needs to be customized for each client using their own data.

Following are the steps to create the reporting solution for clients using the Bold Reports Report Server.

**Set up Report Server**
Prepare the ABCD Corporation tenant on the Report Server installation to maintain the reports:

1. To download and install the Bold Reports Server, please refer to this [link](https://www.boldreports.com/blog/getting-started-with-the-report-server/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23).
2. After installing the Bold Reports Server, it will automatically create the first tenant named ‘BoldReports_EnterpriseReporting.’ Afterward, you can change the site name to your preference. In this demo, I’ve used the name ‘ABCD_Corporation.’
![Report Server Setup](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/61hvyss3ofuyygbsrxn7.png)
3. Afterward, you can create additional tenants, each with its own database, to serve multiple teams or clients.

**Create Common Reports**
Create common reports for clients on the ABCD Corporation site but customize the data in these reports for each client using their own data. Use this [documentation](https://help.boldreports.com/enterprise-reporting/designer-guide/manage-content/reports/create-report/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23) to create the common report.

**Create Reporting Tenant for the Client**
To add a new tenant for the client in the Bold Reports application, create a new site using the site administration module. Follow these steps to create another tenant in Bold Reports:

1. Click Create Site in the site management module, as shown in the next image.
![Create Site](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ndp9sg9ebeqsv6p2pl9j.png)
2. In the Site Creation tab, provide the details for tenant type, name, domain, and identifier. The identifier should be unique and a part of the site URL. Click Next. In this demo, I’ve used the site name ‘ACME_Corporation’ and the site identifier ‘acme’.
![Site Creation](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/f0vcqn4jcif855e68p6p.png)
3. In the Select Database section, choose one of the databases from the Select a Database dropdown to create Bold Reports Server tables in that database. Provide the required credentials and click Next.
![Select Database](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/f9i5pth9mev4lbdibcz6.png)
4. In the Select Storage section, choose either File Storage or Blob Storage for storing the dashboard server site resources. Then, click Next.
![Select Storage](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/49x7fo7eek03ltpojtoc.png)
5. In the Data Security section, add a custom attribute if you want to, but you can add one later, too. I have skipped this step.
![Data Security](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ww5kgaf6irz2c12wbhoq.png)
6. In the Administrator section, select a site administrator to manage the site, and then click Create and Launch Site.
![Administrator](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5h91gsc3c9dh6yncmxro.png)
7. The new site will render as shown in the following image, providing access to multiple tenants in your Bold Reports deployment. You will be taken to the Bold Reports View All page.
![Site Created](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dod3wmud2yba65gmv3ky.png)

**Publishing the Reports**
I have already created a common reports dashboard for ABCD Corporation. Now, I need to publish the dashboard to the ACME Corporation tenant using internal publishing.

1. Click Publish in reports. Select Internal Click Next.
![Internal Publish](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/w4xcudosl0csm23m8dcv.png)
2. Here, you need to select the site you want to publish to from the dropdown menu and provide a name for the category.
![Publish Category](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/w5uzhljw3lma579ec1n8.png)
3. If you don’t want to share access with other tenants, you can restrict access using the lock option.
4. Next, click **Submit**, and the dashboard will be published on the ACME Corporation site, as shown in the following image.
![Publish Reports](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0kbqqqkat17tuurvi3dp.png)

**Sharing the Reports with the Client**
Share reports with users by granting permissions in the Bold Reports Server. In this case, I have shared a report from one user with another user. Refer to [this link](https://www.boldreports.com/blog/schedule-business-reports/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23) for more information.

1. Click the Share Permissions icon in the Reports grid context menu in the ABCD Corporation site.
![Share reports](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8nawj5jq1b3w2c7v881r.png)
2. Click Manage Access, then select the permission level and the users or groups with whom you want to share the report.
![Share Manage Access](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/snky51mn64razhcxuyl1.png)
3. Click Add.
![Reports Shared](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/lb400f4vc78lcvxc8942.png)

**Site Management in Bold Reports Multitenant Environment**
Bold Reports offers various site administration features for different tenants.

**Rebranding**
[Rebranding](https://help.boldreports.com/enterprise-reporting/administrator-guide/custom-rebranding/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23) makes each tenant’s experience unique. It helps clients recognize and connect with the brand on Bold Reports websites. It also lets businesses give their customers a consistent brand experience. You can change the organization name, site URL, login screen logo, welcome text, header logo, favorite icon, email logo, favicon, time zone, and date-time format for each tenant. To make these changes, click Settings in the left panel of the Report Server, then go to the Site tab, as shown in the following picture.
![Rebranding](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ehpbko7xad50ksn3gn62.png)

**Appearance settings**
Bold Reports enables organizations to customize fonts for each tenant, improving the user experience with a customized look and feel. You can adjust fonts independently for each report server. In the next image, you’ll see that the font style has been changed.
![Appearance Settings](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/50ufgfdh849l5vy58vvs.png)

**Managing users**
[Managing users](https://help.boldreports.com/enterprise-reporting/administrator-guide/manage-tenants/manage-users/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23) in a system with multiple tenants means keeping each tenant’s users separate. Administrators can set up rules and permissions for their groups, add or remove users, and control their accounts. Authentication methods like [single sign-on](https://help.boldreports.com/enterprise-reporting/administrator-guide/authentication/single-sign-on/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23) (SSO) make it easy for everyone to log in. Good user management keeps data safe, helps people work together, and allows organizations to maintain control over user access. User access can be granted or revoked, as shown in the following figure.
![Managing Users](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6o197cwizau83auk0mrp.png)

**Managing admin access**
[Admin access management](https://help.boldreports.com/enterprise-reporting/administrator-guide/manage-tenants/manage-admin-access/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23) in multitenant setups works like this: there’s a top-level super admin who controls system settings. Then, each tenant has its own admin with special powers, like handling user setups and settings for their part of the system. Bold Reports uses roles to decide what each admin can do, and we can make admin hierarchies, too. The platform keeps a record of admin actions in logs to make sure everything’s secure and accountable. Strong authentication methods and logs keep an eye on what admins are doing, so your data stays private and secure. Admin access can be provided as shown in the following figure.
![Manage Admin Access](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/aanqco5txksynmm541p7.png)

**Managing localization**
The Bold Reports multitenancy feature makes it easy for administrators to oversee all tenants in one central place, even if users speak different languages or come from diverse backgrounds. To meet these varied needs, organizations can customize the platform for different regions and language preferences. [Localization](https://help.boldreports.com/enterprise-reporting/administrator-guide/localization/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23) enhances user satisfaction, engagement, and adoption of the analytics platform. Localization can be done in Bold Reports as in the following image.
![Managing Localization](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ys1ymrcoiadp395p0p25.png)

**Embed Reports within an Application**
Bold Reports offers you the ability to integrate the Report Viewer and Report Designer controls into your application. This allows you to design reports, save them on the server, and load them from the server. For more information, refer to this [blog](https://www.boldreports.com/blog/how-to-load-a-report-from-the-report-server-in-javascript/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23).

**Conclusion**
Bold Reports with multitenancy can help you save money, keep your data safe, and make your work easier. It doesn’t matter if you’re a company with different teams or a software provider with many customers; multitenancy helps you manage your data better and collaborate effectively in today’s data-driven world. It’s a smart choice for making things more efficient and cost-effective.

If you have any questions, please post them in the comments section. You can also contact us through our [contact page](https://www.boldreports.com/contact/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23) or, if you already have an account, you can [log in](https://www.boldreports.com/account/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_embedreportwithmultitenancy_cy23) to submit your support question.

Bold Reports offers a [15-day free trial](https://www.boldreports.com/pricing) without the need for a credit card. We welcome you to start a free trial and experience Bold Reports for yourself. Let us know what you think!

Stay tuned to our official [Twitter](https://twitter.com/boldreportsoffl), [Facebook](https://www.facebook.com/boldreportsofficial/), and [LinkedIn](https://www.linkedin.com/showcase/boldreportsofficial), pages for announcements about upcoming releases.