Question
CA
Last activity: 7 Apr 2017 4:43 EDT
How to update Database class mapping to use updated DDL.?
Hi,
I have a class BNS-Data-Customer which maps to a DB table Customer. Now often changes occur in DDL of this table, e.g. adding /removing columns and I have to create/delete properties with same name and case of these DDL columns and also update External Mapping in class definition.
Does PRPC have a wizard to run and update this class mapping again with updated DDL..?
Accepted Solution
Pegasystems Inc.
US
Hi Nikhil,
As per my understanding you have the class BNS-Data-Customer which maps to a DB table customer in the database. Now when you delete/add a new column in the customer table in the database with ALTER query then you need a mechanism in Pega to update the class Customer according to your columns available in the customer table after ALTER statement being executed.
If this is your requirement then it can't be done through Pega OOTB way, because it will have an issue with the Inheritance concept if you have child classes for your Customer class which might affect based on the removal of the columns in the parent table to the child table.
So when you add/remove the columns in the table using ALTER query at database and if you are sure that it doesn't have any child classes then you can manually map the new properties into the class Customer.
Hope i explained what you were expecting from us.
Regards
Mahesh
Swedbank AB
SE
Hello,
You could try the Optimize Schema wizard for this. To access it, go the System Database landing page by selecting the 
>System > Database menu item.
Let us know if this helps.
Sincerely,
Pawan
Pegasystems Inc.
IN
Hi Nikhil,
You can use Database Class Mappings wizard (Designer Studi--> Data model--> Classes & Properties--> Database Class Mappings).
Here you can see your classes based on the category you selected.
Regards
Saran kolla
Accepted Solution
Pegasystems Inc.
US
Hi Nikhil,
As per my understanding you have the class BNS-Data-Customer which maps to a DB table customer in the database. Now when you delete/add a new column in the customer table in the database with ALTER query then you need a mechanism in Pega to update the class Customer according to your columns available in the customer table after ALTER statement being executed.
If this is your requirement then it can't be done through Pega OOTB way, because it will have an issue with the Inheritance concept if you have child classes for your Customer class which might affect based on the removal of the columns in the parent table to the child table.
So when you add/remove the columns in the table using ALTER query at database and if you are sure that it doesn't have any child classes then you can manually map the new properties into the class Customer.
Hope i explained what you were expecting from us.
Regards
Mahesh