AnsweredAssumed Answered

Scheduled extraction from CA PPM On Demand to a local DWH

Question asked by BarakBes on Sep 5, 2016
Latest reply on Feb 1, 2017 by Dave_3.0


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?