Starting from version 6.1
, Bold Reports® introduced a feature that supports a 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.
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.
Please enter the site name and site identifier in the Site Creation
tab, then proceed with Next
.
Select the server type as Microsoft SQL Server
, and provide the Server name, Username, and Password.
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.
Note: After configuring the database, follow the steps in the provided link to create a site.
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
.
Note: By default in MSSQL, the
database schema name
is dbo, andserver table prefix name
is BoldRS_.
Select the server type as PostgreSQL
Server, and provide the Server name, Username, and Password.
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.
Note: After configuring the database, follow the steps in the provided link to create a site.
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
.
Note: By default in PostgreSQL, the
database schema name
is public, andserver table prefix name
is BoldRS_.
Select the server type as MySQL
Server, and provide the Server name, Username, and Password.
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.
Note: After configuring the database, follow the steps in the provided link to create a site.
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
.
Note: By default in MySQL, the
server table prefix name
is BoldRS_.