EDC metadata extraction for DataTypes from Pega database in Pega cloud

General
, ,
1

We need to export Enterprise Data Catalog (EDC) information from Pega Database.

Each file has a different requirement and format. The files are listed below with the expected output examples:

  • Custom Lineage​​​​​​​
class identity core_name
com.infa.ldm.relational.Database pega pega
com.infa.ldm.relational.Schema pega/customerdata customerdata
com.infa.ldm.relational.Table pega/customerdata/tablename tablename
com.infa.ldm.relational.Column pega/customerdata/tablename/columnname columnname

  • Links

    association fromobjectidentity toobjectidentity
    com.infa.ldm.relational.DatabaseSchema pega pega/customerdata
    com.infa.ldm.relational.SchemaTable pega/customerdata pega/customerdata/tablename
    com.infa.ldm.relational.TableColumn pega/customerdata/tablename pega/customerdata/tablename/columnname
    Core.ResourceParentChild Pega_App Pega

  • Object

    association fromconnection toconnection fromobjectidentity toobjectidentity
    Core.DirectionalDataFlow Source for the Columns How are we using that column

We are checking if there is anything available from pega OOTB which can be utilized or if anyone had similar requirements and how they have implemented?

2

Hi Sridhar,

I do not think we have OOTB export option that generates informatica EDC import files directly from the Pega Database.