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.
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?
@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.
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.
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.