Clarity

  • Private Community

  • 1.  Is SQL Server Database Schema name niku or ppm_dwh?

    Posted Mar 10, 2018 05:39 PM

    Configure the Data Warehouse Database (Microsoft SQL Server)

     

    After you install Microsoft SQL Server (SQL Server), complete the following tasks to configure the Data Warehouse for use with CA PPM:

     

        Set up a login for CA PPM
        Import the SQL Server database backup image
        Review the imported database options

     

    Set Up a Login Name for CA PPM

     

    Set up a valid login name for use by CA PPM. This login name and password are the values that you specify in CA Clarity System Administration to log in to the database. The login name and password can be any combination. Set the Microsoft SQL Server Database Schema name as niku. This name must be the Default Schema for the login user that you created in the Microsoft SQL Server.

     

    Is that true?

    A little later it says

    Database Schema Name     

     

    ppm_dwh

     

    The login name can be anything, but the default schema name for the login user must be ppm_dwh.

    I tried to put this as a comment in the documentation page, but there was always an error when saving the comment.



  • 2.  Re: Is SQL Server Database Schema name niku or ppm_dwh?

    Broadcom Employee
    Posted Mar 11, 2018 05:54 AM

    Ppm_dwh is for dataware house schema and Niku for ppm schema



  • 3.  Re: Is SQL Server Database Schema name niku or ppm_dwh?

    Posted Mar 11, 2018 06:43 AM

    I understand that and that is why I posted this.
    Under

    Configure the Data Warehouse Database (Microsoft SQL Server)

    it should talk about the ppm schema as that is already dealt with earlier.

    The ppm shuold be dropped it is just confusing.



  • 4.  Re: Is SQL Server Database Schema name niku or ppm_dwh?
    Best Answer

    Broadcom Employee
    Posted Mar 12, 2018 01:58 AM

    Thats been the nomenclature since we came to DWH. Thank you for the feedback we will have a discussion internally and see if we can make something less confusing. 



  • 5.  Re: Is SQL Server Database Schema name niku or ppm_dwh?

    Posted Mar 12, 2018 01:15 AM

    Niku = Default Schema for CA PPM Database

    PPM_DWH = Default Schema for DWH Database



  • 6.  Re: Is SQL Server Database Schema name niku or ppm_dwh?

    Posted Mar 12, 2018 06:00 AM

    Thank you for your responses guys.

    I do have a sort of understanding of those as I have installed CA PPM and version 15.4 among others.

    My point was about improving the documentation.

    The content should match the heading and presenting content once might be clearer.

     

    I tried to put this as a comment in the documentation page, but there was always an error when saving the comment.



  • 7.  Re: Is SQL Server Database Schema name niku or ppm_dwh?

    Broadcom Employee
    Posted Mar 12, 2018 06:05 AM

    CA-TECH-INFO-DAMON - Can you see why Martti is getting error commenting on the documentation page