Question
British Telecommunications PLC
IN
Last activity: 7 Aug 2018 13:18 EDT
Application and database mapping
Hi,
I'm very new to pega. In our development environment the setup is split schema. There is application schema but don't have admin schema.
I've created one blank FW application and one Implementation application using the FW.
When I'm trying to create the case on the implementing application it's throwing table does not exists.
My requirement is that this is a sales application for ordering product and I want to make the baseline tables created manually not directly from pega.
So the tables : MY_ORDER, MY_ORDER_ITEM, MY_PRODUCT, MY_CUSTOMER, MY_CUST_ADDRESS are link together with foreign keys.
These are already created in the database.
So do I need to first create a table with the application name or I can map the order table with the application class without a separate table for the class. I want the order raised will be populated in the order & order item table.
Thanks,
Sovan
***Edited by Moderator Marissa to move from Pega Academy to Pega Support Community; updated platform capability tags***
Coforge DPA
GB
Hi
You would need a class and database mapping to use the tables you have created in the database.
Have a read of below links:
You will get some idea.
Regards
Bhavya
British Telecommunications PLC
IN
So you mean to say that when I created the implementation application it already mapped to a data table. However to use the table created manually in the application we need separate class under the main application class? So when I'll do the external mapping then the implementation application class will refer to which table? the manually created table or the already mapped table which does not exists.
Now I've created the tables MY_ORDER, MY_ORDER_ITEM, MY_PRODUCT, MY_CUSTOMER.
This application is for raising a order journey names USSales as you can see.
So external mapping will create different data classes (4) under the Amaz-US-USSales-Work class??
Then Amaz-US-USSales-Work will point to which table? Will it be still pc_Amaz_US_USSales_Work?? If so the what will be the structure of the pc_Amaz_US_USSales_Work table as that I need to create manually in pegaDATA. Also I can understand the order related record will be populated in the my_order and my_order_item table then what will be populated in the pc_Amaz_US_USSales_Work table.
So you mean to say that when I created the implementation application it already mapped to a data table. However to use the table created manually in the application we need separate class under the main application class? So when I'll do the external mapping then the implementation application class will refer to which table? the manually created table or the already mapped table which does not exists.
Now I've created the tables MY_ORDER, MY_ORDER_ITEM, MY_PRODUCT, MY_CUSTOMER.
This application is for raising a order journey names USSales as you can see.
So external mapping will create different data classes (4) under the Amaz-US-USSales-Work class??
Then Amaz-US-USSales-Work will point to which table? Will it be still pc_Amaz_US_USSales_Work?? If so the what will be the structure of the pc_Amaz_US_USSales_Work table as that I need to create manually in pegaDATA. Also I can understand the order related record will be populated in the my_order and my_order_item table then what will be populated in the pc_Amaz_US_USSales_Work table.
Thanks,
Sovan