Clarity

  • 1.  How to access dwh tables from nsql?

    Posted May 19, 2015 04:37 PM

    What steps should we follow in order to access dwh tables from NSQL? Is it possible?

     

    Thank you.



  • 2.  Re: How to access dwh tables from nsql?

    Posted Jun 03, 2015 04:20 PM

    Can anyone answer Fabio?

     

    Thanks

     

    How to access dwh tables from nsql?

     

    What steps should we follow in order to access dwh tables from NSQL? Is it possible?

     

    Thank you.



  • 3.  Re: How to access dwh tables from nsql?

    Broadcom Employee
    Posted Jun 04, 2015 05:24 AM

    I don't think you can access the DWH from CA PPM but you can go to Advance reporting and when you create a domain you can access the DWH tables.

     

    Regards

    Suman Pramanik



  • 4.  Re: How to access dwh tables from nsql?

    Posted Jun 08, 2015 04:04 AM

    NSQL should be able to read data from the DWH schema - you would just need to make sure (at database level) that the "Clarity database" can see the "DWH database" - if your are on-premise then this is something your local DBA can sort out (via DB-links for example, but not the only way), if you are on-demand I don't know whether that is possible (perhaps you define an additional database-source in the CSA and can do it that way too).