Question
How to find out the external database table column to the properties?
An external database & database table instances were created successfully. Now I want to write a Connect-SQL query to insert data into the external table.
How to find the external database table column names to which the pega properties were mapped during external database table class mapping? Also, please advise how to get the primary key and foreign key columns for that external database table(through pega application).
***Edited by Moderator Marissa to update categories***
You can check the external mapping tab in the class definition for which database table is mapped to find the properties that are mapped to table columns.
Please note that only those table columns which are mapped to Pega properties will be visible here.
If we have other columns in the external table which are not mapped to Pega properties while creating class mapping through 'new external table class mappings', we can't see from external mapping tab.
Check the keys section in the class definition to see keys defined in the table
