Recommended Versions #

• Jaspersoft Studio Version: 6.21.3
• Jasper Server Version: bitnami/jasperreports:8.1.0

Install JasperReports #

Execute the following command to install. Open http://localhost:8080/ in a browser to access the JasperServer UI.

docker network create jasperreports-network

docker run -d --name mariadb \
  --env ALLOW_EMPTY_PASSWORD=yes \
  --env MARIADB_USER=bn_jasperreports \
  --env MARIADB_PASSWORD=bitnami \
  --env MARIADB_DATABASE=bitnami_jasperreports \
  --network jasperreports-network \
  --volume /YOUR_MARIADB_DATA_PATH:/bitnami/mariadb \
  bitnami/mariadb:latest

docker run -d --name jasperreports \
  -p 8080:8080 -p 8443:8443 \
  --env JASPERREPORTS_DATABASE_USER=bn_jasperreports \
  --env JASPERREPORTS_DATABASE_PASSWORD=bitnami \
  --env JASPERREPORTS_DATABASE_NAME=bitnami_jasperreports \
  --network jasperreports-network \
  --volume /YOUR_JASPERREPORT_DATA_PATH:/bitnami/jasperreports \
  bitnami/jasperreports:8.1.0

For related issues, refer to the official documentation: https://hub.docker.com/r/bitnami/jasperreports

Install Jaspersoft Studio #

Download the installation package and execute the installation, for details please refer to the official documentation: https://community.jaspersoft.com/download-jaspersoft/community-edition/jaspersoft-studio_6.21.3.

Connect to ByteHouse data source #

Connect through ClickHouse Data Adapter #

• Fill in the following connection information:
  • Name: Customizable.
  • JDBC Driver: com.clickhouse.jdbc.ClickHouseDriver
  • JDBC Url:jdbc:clickhouse://<HOST>:8123/<DATABASE_NAME>
  • Username: default to bytehouse
  • Password:API key

The Host and API key fields, you can obtain the related information at 获取连接信息this link.

• Fill in the connection properties
  • compress:0
  • server_version:54021
  • ssl:true

• Provide the driver file path.

Please download the file from this link and load it locally.

• Test the connection

Connect using the MySQL Data Adapter #

• Fill in the following connection information:
  • Name: Customizable.
  • JDBC Driver: com.mysql.jdbc.Driver
  • JDBC Url:jdbc:clickhouse://<HOST>:3306/<database name>
  • Username: The default is bytehouse
  • Password:API key

Host and API key fields, which you can obtain at 获取连接信息acquire location

• Import Driver Files:

Please download it from the link to your local machine and load it from there.

• Test Connection

Preparation Work #

Create JasperReport Server #

• Enter connection information.
  • Name: Customizable Name
  • URL: http://<ip>:8080/jasperserver/。 Please enter the domain name or IP address of the Jasper server.
  • User: jasperadmin
  • Password: jasperserver password

• Test Connection

Create ClickHouse Data Source #

• Upload Clickhouse JDBC driver

JDBC driver package name: com.clickhouse.jdbc.ClickHouseDriver
Driver download URL: https://github.com/ClickHouse/clickhouse-java/releases/download/v0.6.3/clickhouse-jdbc-0.6.3-http.jar

• Fill in the following information
  • Url:jdbc:clickhouse://<HOST>:8123/<database name>
  • Username: Default is bytehouse
  • Password:API key

Host and API key fields, which you can 获取连接信息obtain.

• Test Connection

• Save Data Source

Create MySQL Data Source #

• Upload Driver

Driver package name: com.mysql.jdbc.Driver
Driver download URL: https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.28/mysql-connector-java-8.0.28.jar

• Fill in the Following Information
  • HOST: Enter the server HOST address
  • Port: 3306
  • Database: Database Name
  • Username: Default is bytehouse
  • Password:API key

Host and API key fields can be retrieved from 获取连接信息here.

• Test Connection

• Save Data Source

Execute Query #

• Customize Query Name

• Select Data Source

• Write SQL Query Statement

Publish Report #

• Select the Data Source Created Above

• Select the Query Created Above

• Complete

• View Report