Please follow the below step to create combined Bold BI and Bold Reports Azure web app using the ARM template.
-
Login to Azure portal: https://portal.azure.com.
-
Click on the “New” in the left menu.
-
Search “Template deployment” in the marketplace and select Template deployment.
-
Then click on the create button.
-
Now select “Build your own template in the editor” in the “Custom deployment” window.
-
Click here to download the ARM template file.
-
Copy all the contents in the template file and replace them in the “Edit template” window. Then click on the save button.
-
Fill the form as instructed below to complete the deployment steps.
Subscription: Choose the subscription that you have with Azure. Learn more about subscriptions from here.
Resource group: This is a logical group in Azure to group your resources like a web app, storage account, network, etc. Learn more about resource groups here.
Location: Choose the location on which your app to be deployed. “East US” is our recommended location.
Web App name: This is the name of the Bold BI and Reports App that you want to have in the URL. As this is going to be the URL, it should be unique globally. The deployment process will get failed if this is present already and you will need to start once again with another name.
Storage account name: This is optional if you have chosen File storage in Storage type and mandatory for Blob storage. This also must be unique as that of the Web App name. Learn more about storage accounts here.
Storage account type: This is optional if you have chosen File storage in Storage type and mandatory for Blob storage. Learn more about storage account types here.
Click the agreement checkbox and click on the purchase to deploy the Bold BI and Reports web app.
-
Bold BI and Reports Azure App service(web app) deployment gets started. This may take 5-10 minutes to complete the deployment.
-
We have created an app service plan for the web app which will be in “Basic – B1” by default. Learn more about App service plans here. Bold BI web app does not support Free or Shared app service plans. Bold BI and Reports supports Basic, Standard, and Premium App Service plans in the Azure. The minimum recommended App Service plan to run the application is the Basic plan. To get better performance, can scale up the App Service plan from Basic to Standard or Premium plans. Please find the below documentation links on how to scale up and scale out the App Service plan.
Scale-up: https://docs.microsoft.com/en-us/azure/app-service-web/web-sites-scale
Scale-out: https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/insights-how-to-scale
Please follow the procedures in this guide to configure the application. This will activate the Bold Reports license. To activate the Bold BI license, please refer to the next section.
To activate the Bold BI license, please follow the steps from this document.
Once the Bold BI license is activated, we can create new Bold BI sites. Please follow the procedures in this document to create a new Bold BI site.
Bold BI Enterprise Edition uses client libraries such as Oracle, MySQL, Snowflake, and MongoDB to connect with their respective SQL database variants. You need to read and accept client library license to install client libraries.
Please follow the below step to install client libraries.
- Open kudu PowerShell console for Bold BI Azure App service. We can access the Kudu service through the portal by navigating to Web App dashboard > Advanced Tools > Click on Go.
- Select PowerShell console.
- Go to client library location.
{drive}\home\site\wwwroot\ClientLibraries\boldbi
- Here, you can see the client library consent document consent-to-deploy-client-libraries.txt. Read client libraries LICENSE details and execute the following command to install client libraries.
.\install-optional-libs.ps1 “npgsql,mongodb,influxdb,snowflake,mysql,oracle,google,clickhouse”
Please refer here https://help.boldreports.com/enterprise-reporting/administrator-guide/installation/azure-app-service/client-libraries/