Starting from version 6.1, Bold Reports® introduced a feature that supports a single database for multiple sites.

Single Database For multiple sites

In a multi-tenant architecture, multiple instances of an application operate in a shared environment. The instances (sites) are logically isolated but physically integrated. In the context of databases, this means that multiple sites share the same database, but each site has its own set of tables that are distinguished by schema and prefix. This allows for efficient resource utilization while ensuring data isolation and security for each site.

Site Creation

You can create a new site in the Bold Reports® On-premise application by clicking on the Create Site button in the site management module. Create Site

Please enter the site name and site identifier in the Site Creation tab, then proceed with Next.

Select Database:

MSSQL Server

  1. Select the server type as Microsoft SQL Server, and provide the Server name, Username, and Password. Select MSSqL

  2. Please provide the name of the existing database that you have already used to create a site, as well as the new database schema name and the new server table prefix name. Once provided, click Next to proceed further. Prefix Schema

    Note: After configuring the database, follow the steps in the provided link to create a site.

  3. In the screenshots below, user represents the existing database, dbo.BOLDRS_ is the schema and prefix used for the tables created for site 1, while dbouser.BoldRSuser_ denotes the newly created schema and prefix for the tables created for site 2. Here, both schemas are present within the single database. By differentiating the schema and prefix names, you can create multiple sites within a single database.

Existing Database New Table

Note: By default in MSSQL, the database schema name is dbo, and server table prefix name is BoldRS_.

PostgreSQL

  1. Select the server type as PostgreSQL Server, and provide the Server name, Username, and Password. Select Postgresql

  2. Please provide the name of the existing database that you have already used to create a site, as well as the new database schema name and the new server table prefix name. Once provided, click Next to proceed further. Custom Prefix Schema

    Note: After configuring the database, follow the steps in the provided link to create a site.

  3. In the screenshots below, user represents the existing database, public is the schema, and boldrs_ is the prefix for the tables created for site 1, while test denotes the newly created schema and boldreportsuser_ is the newly created prefix for the tables created for site 2. Here,both schemas are present within the single database. By differentiating the schema and prefix names, you can create multiple sites within the single database.

Postgres Schema Postgres Prefix Table Prefix

Note: By default in PostgreSQL, the database schema name is public, and server table prefix name is BoldRS_.

MySQL

  1. Select the server type as MySQL Server, and provide the Server name, Username, and Password. Create MySQL

  2. Please provide the name of the existing database that you have previously used to create a site, along with the new server table prefix name. After providing these details, click Next to continue. Existing Mysql

    Note: After configuring the database, follow the steps in the provided link to create a site.

  3. In the screenshots below, user represents the existing database, boldrs_ is the prefix for the tables created for site 1, while boldrsuser_ is the newly created prefix for the tables created for site 2. Here, tables for both the sites are present within the single database. By differentiating the prefix names, you can create multiple sites within the single database.

    MySQL table MySQL Prefix

Note: By default in MySQL, the server table prefix name is BoldRS_.