Using Excel file as a datasource for TIBCO JasperReports® Server

There might be an easier way, but the one that I’m going to describe works like a charm with any type of Excel file, and basically creates MySQL database that you can use with TIBCO JasperReports^® Server as a data source.

Prerequisites:

1. MySQL Community - https://dev.mysql.com/downloads/mysql/

Creating database with Excel table:

1. Save your Excel file as .csv (comma delimited)

2. Create MySQL script with table definition at following url: https://sqlizer.io/#/

3. Start terminal:

   • /usr/local/mysql/bin/mysql -h localhost -u “username” -p”your_password”

   • CREATE DATABASE database_name

   • USE database_name

   • SOURCE Path_To_MySQL_script_file

Creating JasperReports Server data source:

1. Login to JasperReports Server and click on Create data source

   • Datasource:

   • Type: JDBC Data Source

   • JDBC Driver: MySQL

   • Host: MySQL host (localhost if installed locally)

   • Port: 3306

   • Database: database_name

   • Username: “username”

   • Password: “your_password”

2. Click “Save” and choose the destination folder in the repository. Now you should be able to create a new domain from this data source or to explore data directly through Ad Hoc view.