Data Migration from BIRT to Jasper Server

About Client

One of Asia’s largest E-commerce marketplaces that assists businesses with services in the areas of e-auction and e-procurement of resources like steel, oil and coal.
Client Revenue: $185 Million (FY’21)

Challenge

The client wanted to migrate from BIRT (Business Intelligence and Reporting Tools) to TIBCO Jasper because of Jasper’s advanced functionalities that would support their business better by-

  • Reducing the load on their main application server
  • Generating pixel perfect and user friendly reports with drag and drop features
  • Deploying reports/dashboard seamlessly without any workflow dependencies thereby, saving time and cost

However, this meant consolidation of several reports, as well as the development of new dashboards on Jasper as per the ad hoc requirements for the client.

Our Solution

  • The BizAcuity team started by collecting the existing report module design files and analyzed the best approach to develop in Jasper as per the stakeholders’ requirement
  • User-friendly accessibility to the reports were added by consolidating 80+ different categorized reports at one place which users could access with appropriate inputs
  • Old queries had also been optimized to improve performance for executing both dashboards and reports after migration
  • Secured application login activity with Single Sign On (SSO) feature was implemented which will generate a secure URL from the application to Jasper server from which the reports/dashboards could be accessed by the authorised personnel
  • Based on requirements, only limited export file format functionality to Xls, Xlsx, PDF was added
  • Back end server changes like Adhoc cache was implemented to drive faster execution of queries for adhoc reports which were self-driven

TIBCO Jaspersoft:
A popular open-source business intelligence platform that offers a variety of features and capabilities including interactive reports, dashboards, and charts, and embedded BI analytics.

Outcome

Migrated BIRT reports to Jasper with Single Sign On (SSON) implementation to allow access to authorised users in

6 Months

Consolidated

80+

reports

over

30

drill-down reports (parent-child reports) developed

Leave a Reply

Your email address will not be published. Required fields are marked *