The Data Extract tool is proving to be extremely useful to us in pulling data from the live database, so now we'd like to know if there's a way to use it to query the data warehouse.
I am sure it can be done, the columns names are not exact the same so the field mappings needs to be done it the extraction tool. If you are using CA services tool then please get in touch and let them know your requirements.
Please elaborate what is Data Extract tool and where can I find more information on that.
CA services provides few PWP and you can find more information on the same PPM Insights: CA PPM Packaged Work Products
Suman, thank you for your reply. We are able to set CA PPM DATAWAREHOUSE as the source for a data extract, but unable to execute a successful query. We receive the error "Table or view does not exist." We believe this may be due to us being SaaS clients, and have an open ticket with CA to troubleshoot.
The name of tables in PPM and DWH are not same. You should be able to get more information from our documentation
Getting Started with Advanced Reporting with Jaspersoft - CA PPM - 15.2 - CA Technologies Documentation
We have a requirement to extract PPM data to Tableau, is the data extraction tool available for PPM v 15.1?
CA has informed us that the data warehouse is not accessible to us via the Data Extract tool because we are a SaaS customer.