How to export metrics from Jasper Report server (On Premise)?

This thread was migrated from an old forum. It may contain information that are no longer valid. For further assistance, please post a new question or open a support ticket from the Customer Support portal.

I can see how to export a Jasper Report (formatted template with data, etc.), however, I want the ability to export the metric data and import into my data lake for analytics and aggregation using my enterprise analytic tools.

Hi,

Please refer to the below article, this might be helpful for you.

https://basecamp.kony.com/s/article-detail/a046A000001lavgQAA/kony-analytics-reporting-faqs-best-practices-for-kony-cloud

Also, please check the below component from Marketplace and confirm if this matches your requirement.

https://marketplace.kony.com/items/kony-mobilefabric-custom-report-downloader

Thank you

I neglected to point out that my Jasper Report server is the On-Premise solution. As Kony has informed me, there are limitations from Cloud to On-Prem. What is the On-Prem solution?

Hi,

Please refer to the below document, this might help you.

https://docs.kony.com/konylibrary/konyfabric/kony_fabric_user_guide/Default.htm#Export_Import_Custom_Reports_Dashboards_MFCLI.htm#ReportsExport_2

Thank you

Correct me if I am wrong, but that is to export an entire report -- not the raw, unformatted, un-boiled metrics.

Hello @Lillivnv Cote​, need your help here. Please take a look. Thanks!

@Fwvnciszek Riley​ in on-premise the reporting DB is in your premise. You can feed the data to your data lake similar to how you feed any of your other data from database to it.

Without knowing your setup i can't recommend any particular solution. Several options like

1) point your BI tool to reporting DB as data source

2) create a cron job to pull data via stored procs and feed it to your other data source

3) create a read only replica of your reporting DB for integration with your other tool ... etc.

OK - i thought there might be "export tools or scripts" that would be meaningful for the metrics schema. I will let Leadership know that the data is "open" and can be exported in the traditional way. Meanwhile, is there documentation on the schema / data-dictionary? I would expect that to come from Kony since Kony defined that schema to support your reporting objectives.

@Fwvnciszek Riley​ the schema is present in installation guide as an image.

However the data-dictionary with reference to exact table info, i have attached with this comment

Wow! That is buried deep. I have read that document multiple times and never noticed the link to the schema-map image. This will be VERY helpful, however, I am asking for a "data dictionary" where each table and each of its fields are documented as to their meaning. It may appear to be intuitive, but that is how mistakes are made with assumptions among different users of the same code. That will be needed by the Analyst who is reading the data into the data lake.

@Fwvnciszek Riley​ please read my previous comment. It looks like you did not read it fully nor did you see the file that was attached in the comment.

Am not sure the email notification from basecamp would have sent the attachment, so you should probably login to basecamp and read it.

You are correct, I did not fully read and assumed the attachment was the "installation guide" that was mentioned in the first sentence. Thank-you for bringing it to my attention and providing the needed documentation.