We have a customer who is on CA PPM On Demand (currently 14.2, but if required will upgrade to 15.1).
They don't want to work with Jaspersoft as their BI tool. They want Tableau.
My understanding is that they can't connect the Tableau directly to the On-Damand DB. They need to download their to a local DB/DWH.
It's not a problem to do it one-time by exporting Jaspersoft ad-hoc views to CSV files, but I want to create a mechanism that will do it incrementally for the evolving data.
How can that be achieved?
My initial reaction would be just to write a NSQL query which delivers the required data and call it (scheduled, incrementally) over the query API (web-service).
The details of that query would of course entirely depend on you functional requirements and you would need to take into account data-volume/security etc.
Volume would be key. You can't just export the entire database daily...
Yeah if you want some vague "all the data" / "adhoc reporting" requirements then that isn't practicle ; I was really just envisaging some specific targeted reporting - i.e. one query.
Not sure there is a easy answer.