Preparing a Reporting Solution in Azure Kubernetes Service using Ingress: A Step-by-step Guide
Tags: boldreports, syncfusionreportdesigner, syncfusionreportviewer, reportingtools
Published: 2023-09-21 12:11:46

In today’s world, containerization and Kubernetes are becoming increasingly popular as technologies that empower organizations to streamline application deployment, enhance scalability, and simplify management. Azure Kubernetes Service (AKS) is a managed Kubernetes service that can assist organizations in easily setting up and managing report servers.

The Bold Reports Report Server is a reliable, scalable, powerful reporting solution. It is easily used in different platforms, including the Azure Kubernetes Service. With the Bold Reports Server, it is simple to manage, style, create, and export reports since there is no requirement for coding.

In this guide, I will walk you through the steps of deploying the Bold Reports Report Server on AKS with Istio. This will not only enable you to acquire the necessary steps for deploying the report server, but you’ll also understand how to embed reporting tools into your application.

## Prerequisites
Let’s first look at the prerequisites for setting up the Report Server on the Azure Kubernetes service cluster.

**Hardware Requirements**
To ensure a smooth installation, your hardware should meet the following requirements:

1. CPU with two or more cores.
2. 4 GB of RAM.

**Software Requirements**
On the software side, you need the following components:

1. **A database** like Microsoft SQL Server 2012 +, PostgreSQL, or My SQL. Ensure your database is accessible outside the machine.
2. **Command-line tools**: kubectl and Azure CLI.
3. **Web browser** like Microsoft Edge, Mozilla Fire Fox, or Google Chrome

## Deployment
Let’s now go through the deployment process, so you can start with Bold Reports on your Kubernetes cluster smoothly.

**Step 1: Downloading the Deployment Files**
You have to download the highlighted deployment files from the Bold Reports Kubernetes [GitHub](https://github.com/boldreports/bold-reports-kubernetes) repository.


![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service.](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/oov0itwfulfa2cqgfe5x.png)Deployment files 

Using Visual Studio Code, open the folder containing all the deployment files.

Let’s review the usage of each file:

- **Deployment** contains the configuration to create and manage the pods using a replica set.
- **Configuration** in HPA is used to automatically increase or even decrease the number of pods in response to memory consumption.
- **Ingress** contains the configuration which is used to configure how traffic is routed to your Kubernetes application, and it exposes HTTP and HTTPS routes from outside the cluster to service within the cluster.
- **Log4net_config** has the configuration settings that are used to store the needed logs in a file.
- **Namespace** contains that configuration that will assist and will be helpful when different teams or projects share a Kubernetes cluster.
- **Pvclaim_aks** contains the configuration where the information for the file system will be provided.
**Service** provides access to retrieve one or more pods.

**Step 2: Connecting with the Azure cluster.**
Open PowerShell and navigate to the folder where the deployment files have been downloaded.

1. Run the following command to authenticate Azure.
        

```
az login
```
2. Open the Azure Kubernetes page, and then the cluster overview page, and click on the   Connect option.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ql9o1xvyw1tsnuw86jfm.png)


3. Copy these commands.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/z2qpsdh0x3yxjthtm2tb.png)Copy the highlighted commands


4. Run this command in PowerShell to connect with the cluster:

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fm0sshk41vlvrdv2mojz.png)Run the command in PowerShell

**Step 3: Deploying the NGNIX Ingress controller**
Deploy the NGNIX Ingress controller by running this command:

```
kubectl apply -f https://raw.githubusercontent.com/kubernetes/ingress-nginx/controller-v1.2.0/deploy/static/provider/cloud/deploy.yaml


```
**Step 4: Configuring the storage pods**
I have already created a storage account. Open the account access key page.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3rra3qh7tflz3y4odaen.png)Account access key page.

1. Copy the storage account name, storage account key, and convert them to base64.
![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wx9y6nhhlcofv38u7cnb.png)

2. A file-share instance has been created in the storage account to store the shared folder for application usage, and a note has been made for the file-share name.
![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1kknfpuzxjdfaxdtwih0.png)File-share name.

3. Open the Pvclaim_aks file and the Azure storage account name together with the account key, encoded in Base64, to the file. Also add the shared name to the file and save it.
![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8nxkdyopqs2dz5d8ngz8.png)Pvclaim_aks file

**Step 5: Creating a namespace and log configuration.**
1. Then run the following command to create a namespace for Bold Reports. Bold service is our namespace:

```
kubectl apply -f namespace.yaml

```
2. Run this command to create the log configuration:



```
kubectl apply -f log4net_config.yaml
```
**Step 6: SSL configuration**
Deploy the Report Server using the Ingress IP address; however, if you want to set up the Report Server with a domain, you can add the domain name and TLS secret name to the file under the tls and rules sections.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dmqrd4t632enbfcmsi4z.png)Ingress IP address

The application will be hosted in non-SSL mode by default. To configure SSL, you need to add the domain name and SSL configuration to the file.

Before you configure the SSL, you have to create the TLS secret with the SSL certificate by running the following command:

```
kubectl create secret tls boldreports-tls -n bold-services --key <key-path> --cert <certificate-path>

```
For this case, the secret name is boldreports-tls. <key-path> indicates the path for the .pem file and <certificate-path> indicated the .crt file path.

**Step 7: Generating Ingress IP address**
1. Run the command to apply the BoldReports Ingress and get the IP address of the NGINX Ingress:

```
kubectl apply -f ingress.yaml
```
2. Then run this command to get the IP address:

```
kubectl get ingress -n bold-services -w
```

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/e90n9uxgxg4wbbhdlqku.png)

**Step 8: Mapping the IP address with DNS.**
Open the deployment.yaml file and replace the DNS or Ingress IP address in the application base URL.


![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cq1lj13iuq918u5iqccq.png)

**Step 9: Add optional client library.**
To use third-party data sources like MySQL, Oracle, or PostgreSQL in your report, you need to install them as part of the Report Server deployment. Here I specify MySQL, Oracle, and PostgreSQL.


![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7w1r5x754v53bgpfj8ft.png)Third-party data sources

**Step 10: Apply configuration files**
1. Apply the configuration from the pvclaim_gke file by running the following command to create a persistent volume (PV) and persistent volume claim (PVC):

```
kubectl apply -f pvclaim_aks.yaml
```
2. Apply the configuration in the file by running the following command to create and manage pods with the specified number of replicas and the provided image. When you run the command to apply the deployment configuration, Kubernetes will create the specified number of pods and start them up. Apply the configuration from the pvclaim_gke file by running the following command to create a persistent volume (PV) and persistent volume claim (PVC):

```
kubectl apply -f pvclaim_aks.yaml
```
3. Apply the configuration in the hpa_gke file by running the command to set up autoscaling for the Kubernetes horizontal pod autoscaler (HPA:

```
kubectl apply -f hpa.yaml
```
4. Create all the services by running this command:

```
kubectl apply -f service.yaml
```
5. Once all the deployment files are applied, you need to verify and be sure that the pods are running and healthy. You can do this by running the following command

```
kubectl get pods -n bold-services -w
```

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qgs1xxgo54yfyasa6uv1.png)Application Startup Page

Being that the Report Server is ready, you can open the browser and navigate to the domain or Ingress IP address provided in the application base URL in the **deployment.yaml** file to configure the Report Server.

**Step 11: Application startup**
To activate your Bold Reports account, you can either use your online credentials or your offline unlock key. We can download the unlock key from  [Bold Reports accounts](https://login.boldid.net/accounts/login?ReturnUrl=%2Foauth%2Fv2.0%2Fauthorize%3Fclient_id%3D4bba72e0-3c0d-4422-98c9-58b2d16f2ef1%26scope%3D%26response_type%3Dcode%26redirect_uri%3Dhttps%253A%252F%252Fwww.boldreports.com%252Faccount%252Fhome%26state%3DCfDJ8LsC-mMNCfFBlAW0nIRwKnsdk0Psj3YXdgXxFwCcbVM2NlqGiO1AE6WTF7geNv1GeWE3JlpLGImtQgOV0ZxUX4Dwf4FVO7MscbT6MJPYQXbzoRc4AyZ0iQI9iGKC17QSWHo4Oj9URHLXBaC6g9pNNqdsd6gyuLUqniLU29tPf7kviCzfSfkH238n4uzC6ng_6KZGLI0r6NewBemHmPO-3lk) and upload it in the setup.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/d1nu4rz0tc40xlkw64f3.png)Activation of Bold Reports account by uploading the online unlock key.

Let’s activate the account using the online credentials.

1. Click **Log in to activate account** and enter the Bold Reports credentials.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/99p06u752r4qclhlc06h.png)Clicking Log in to Activate Account

2.  Enter your Bold Reports credentials. Since we only have one portal license, the portal license selection will be skipped. If you have more than one portal license, you will have to use only one.

**Step 12: Configuring the administrator.**
We configure the administrator user by entering the user information and password and then by clicking on the Next button.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/s76o0hzlg194d54a14c5.png)User information and password

**Step 13: Configuring the database for Report Server data storage**
Here we can configure the database to store the report server data. Reports can be stored in SQL Server, PostgreSQL, and MySQL databases.

1.  We use PostgreSQL. The fields in the Report will be updated based on the database selected, and you provide the necessary information in the required fields.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/c9nnwyvd9vb6wf6v3xmn.png)Database field


2. Choose new database and provide the database name as “boldserviceskubernetes”.
3. Then enable the SSL option to create a secure connection using the Secure Sockets Layer (SSL) protocol.
4. Click on the **Next**
5. The deployment of the report tenant will begin and will continue in the background.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/w4vv3y54h7zmsg42i5mm.png)Deployment of the report tenant


6. After that, click Go to Reports.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/a07dlr3wvsjhdit7z99s.png)Go to Reports


7. You will be taken to the “view all” page.
The sample reports that are already available in the Report Server can be added to the Report Server by simply clicking on the Explore in the Report Sample pop-up window. You will be able to see the list of samples, and when you click on the Add Report button, reports will be added under the Sample Reports category.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rzeu3ibui7z3mkipc9oj.png)Report Viewer


8. Clicking on the Report will now open it in the Report Viewer.
Now open the Share Data Source Data Connector page. You can see the third-party data sources like MySQL, Oracle, and PostgreSQL.

![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/msjoijuaq0xzld0lnrg3.png)Data Connector page

**Step 14: How to install PhantomJS in the deployed application**

By default, the Bold Reports Report Server does not export visualization report items such as charts and gauges when exporting reports while scheduling. To export these items, you need to install the PhantomJS client library in the Report Server. PhantomJS is a headless Webkit browser that can be scripted in the JavaScript.

You first need to bash the container.

1. Run this command to get the available container:

```
kubectl get pods -n bold-services -w
```
2. Then run this command to open the shell running in reports-web-deployment-container:

```
kubectl exec -it <pod-name> -n <namespace> -- bash
```
In the above command, <pod-name> refers to the name of the pod, and <namespace> refers to the namespace that was used when deploying the Report Server.

3. Once you are inside the container, you need to change the current directory by running this command:

```
cd /application/app_data/optional-libs
```
4. Then install the sudo and wget tools.

```
apt-get install sudo

apt-get install wget
```
5. Once you have installed the sudo and wget tools, you must install some required packages by running this command:

```
sudo apt-get install build-essential chrpath libssl-dev libxft-dev libfreetype6-dev libfreetype6 libfontconfig1-dev libfontconfig1 -y

```
 6. Then download the latest stable version of PhantomJS from the official website by running the following command:

```
sudo wget https://bitbucket.org/ariya/phantomjs/downloads/phantomjs-2.1.1-linux-       x86_64.tar.bz2
```
7. Once the download is complete, you can extract the downloaded archive file to the desired system location by running the following command:

```
sudo tar xvjf phantomjs-2.1.1-linux-x86_64.tar.bz2 -C /usr/local/share/
```
8. After that, create a symlink of the PhantomJS binary file in the system’s bin directory by running this command:

```
sudo ln -s /usr/local/share/phantomjs-2.1.1-linux-x86_64/bin/phantomjs /usr/local/bin/
```
9. To verify whether PhantomJS has been installed successfully, run the following command.

```
phantomjs --version
```
If it shows the version number, then you can be sure that PhantomJS has been installed successfully.

After that, you need to reload the browser and export the reports that have charts. Once the report is exported, open the exported file to see that the charts are exported.

**Report embedding**

Bold Reports allows you to embed reporting functionalities directly within your applications. Our embeddable reporting tools can be integrated with popular applications such as ASP.Net Core, Blazor, Angular, and React. The usage of embedded reporting tools will change depending on the deployment platform. You can find more detailed information about these differences in [our documentation](https://help.boldreports.com/enterprise-reporting/developer-guide/embed-in-application/view-report-through-report-viewer/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_reportingsolutionazurekubernateswithingress_cy23).


![This blog provides a step-by-step guide on how to deploy the Reporting Solution on Azure Kubernetes Service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qyeuajijdki4btzqg3p1.png)Bold Reports reporting tools and popular platforms it can be integrated with

**Conclusion**

This blog post covered the step-by-step process of deploying the Bold Reports Report Server on Azure Kubernetes Service including adding optional client libraries and installing PhantomJS for exporting data visualization report items. We hope you found this guide helpful

To explore more about the Bold Reports Report Server on the Google Kubernetes Engine with Ingress, look through our [documentation site](https://help.boldreports.com/embedded-reporting/blazor-reporting/report-designer/add-report-designer-to-a-blazor-application/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_reportingsolutionazurekubernateswithingress_cy23). To experience our live features, please check on our [demo](https://demos.boldreports.com/home/blazor.html), [sample](https://demos.boldreports.com/home/blazor.html)s, and [solution](https://solutions.boldreports.com/)s.

If you have any questions or need assistance, feel free to post in the comment section below. Alternatively, you can reach us through our [contact page](https://www.boldreports.com/contacthttps://www.boldreports.com/contact). If you already have an account, you can [log in](https://login.boldid.net/accounts/login?ReturnUrl=%2Foauth%2Fv2.0%2Fauthorize%3Fclient_id%3D4bba72e0-3c0d-4422-98c9-58b2d16f2ef1%26scope%3D%26response_type%3Dcode%26redirect_uri%3Dhttps%253A%252F%252Fwww.boldreports.com%252Faccount%252Fhome%26state%3DCfDJ8DwR1x66m9ROklERUFfeC_4TPauTbAMegZ9Zh23_q5xAwm9hHe37NYoiLWiz3C4EXf7iNXPnrJYXio1NAU0a2s1iZcQ8QiD3LplnJcm4joXDssszVZCrSFmEKQaYnzVT6sfvnOQDeMAENQL6BGrKVikpEhoF9RlnCsmItVeddaML-w-btf_lGAZsMDmMUz07IbEUav7mYKwc_DTakIi0AF4) and ask your support questions directly.

To have more experience and know more about Bold Reports firsthand, we offer [a 15-day free trial](https://www.boldreports.com/pricing/?utm_source=dev&utm_dev=partner_blog&utm_campaign=dev_reportingsolutionazurekubernateswithingress_cy23) with no credit card required. We invite you to start the trial and explore the potential of Bold Reports. We really value your feedback, so please don’t hesitate to let us know your thoughts.

Stay up to date with the latest announcements on upcoming releases by following our official [Twitter](https://twitter.com/i/flow/login?redirect_after_login=%2Fboldreportsoffl), [Facebook](https://www.facebook.com/boldreportsofficial/), and [LinkedIn pages](https://www.linkedin.com/showcase/boldreportsofficial/). Thank you for reading.