Gen EDGE

  • 1.  Anyone have sql to create a Data Dictionary from the CSE?

    Posted Sep 05, 2017 10:53 AM

    I am being asked to create a data dictionary.  The Gen CSE has all the information i need, before reinventing the wheel, I wondered if anyone else has done this thru SQL?

     

    Thanks!



  • 2.  Re: Anyone have sql to create a Data Dictionary from the CSE?

    Broadcom Employee
    Posted Sep 05, 2017 09:19 PM

    Hi Bill,

    Under the Gen toolset installation "Gen" folder C:\Program Files (x86)\CA\Gen8x\Gen  you will find a CSE Reference Help file csref.chm which describes the CSE Schema (SCHEMA & DATA tables).

    Also the same content is here on the 8.5/8.6 documentation wikis:

    Client Server Encyclopedia Reference - CA Gen - 8.5 - CA Technologies Documentation 

    Client Server Encyclopedia Reference - CA Gen - 8.6 - CA Technologies Documentation 

     

    Not sure if it will have enough detail for you?

     

    Hope it helps.

     

    Regards,

     

    Lynn



  • 3.  Re: Anyone have sql to create a Data Dictionary from the CSE?

    Broadcom Employee
    Posted Sep 06, 2017 10:45 AM

    Bill,

     

      Please, if Lynn's post helped you resolve the problem, kindly click the 'Mark Correct' on his post.

     

    Thanks.



  • 4.  Re: Anyone have sql to create a Data Dictionary from the CSE?
    Best Answer

    Posted Sep 06, 2017 07:31 PM

    On the CSE you can also utilise the PI views

    https://docops.ca.com/ca-gen/8-5/en/encyclopedia/client-server-encyclopedia/client-server-encyclopedia-public-interface

     

    that can help generating some queries like this (ENT to ATTR)

     

    select

                     ent.name

                    ,attr.name

                    ,attr.id

                    ,attr.type

                    ,attr.domain

                    ,attr.length

                    ,attr.dec_places

                    ,attr.case_sensitive

                    ,attr.opt

                    ,txt.text_value

    from

                     model mdl

                    ,entity_type ent

                    ,attribute attr

                    left outer join dtxt txt

                                    on  txt.text_obj_id = attr.id 

                                    and txt.text_model_id = attr.model_id

    where mdl.name like <filter by model naming std here>

                    and attr.model_id = mdl.id

                    and ent.model_id = mdl.id

                    and attr.parent_entity_id = ent.id

    order by ent.name asc, attr.seq asc;

     

    A lot easier than navigating the meta-model 



  • 5.  Re: Anyone have sql to create a Data Dictionary from the CSE?

    Posted Sep 07, 2017 10:21 AM

    Thank you Alfred and Lynn!  With those 2 answers I should be on my way.  We just need to get Cognos setup to read those views.  Thanks again!