Clarity

  • 1.  Does the Data Extract tool work against the data warehouse?

    Posted Apr 25, 2017 02:27 PM

    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.



  • 2.  Re: Does the Data Extract tool work against the data warehouse?

    Broadcom Employee
    Posted Apr 26, 2017 03:03 AM

    Hi Tanessa,

     

    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.


    Regards

    Suman Pramanik 



  • 3.  Re: Does the Data Extract tool work against the data warehouse?

    Posted Apr 26, 2017 03:17 AM

    Please elaborate what is Data Extract tool and where can I find more information on that.



  • 4.  Re: Does the Data Extract tool work against the data warehouse?

    Broadcom Employee
    Posted Apr 26, 2017 03:37 AM

    Hi Martti,

     

    CA services provides few PWP and you can find more information on the same PPM Insights: CA PPM Packaged Work Products 

     

    Regards

    Suman Pramanik 



  • 5.  Re: Does the Data Extract tool work against the data warehouse?

    Posted Apr 26, 2017 03:57 AM

    Thanks SumanPramanik 



  • 6.  Re: Does the Data Extract tool work against the data warehouse?

    Posted May 03, 2017 12:09 PM

    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.



  • 7.  Re: Does the Data Extract tool work against the data warehouse?

    Broadcom Employee
    Posted May 03, 2017 12:21 PM

    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 

     

    Regards
    Suman Pramanik 



  • 8.  Re: Does the Data Extract tool work against the data warehouse?

    Posted May 05, 2017 10:24 AM

    We have a requirement to extract PPM data to Tableau, is the data extraction tool available for PPM v 15.1?



  • 9.  Re: Does the Data Extract tool work against the data warehouse?
    Best Answer

    Posted May 18, 2017 06:02 PM

    CA has informed us that the data warehouse is not accessible to us via the Data Extract tool because we are a SaaS customer.