Question
MUFG Bank
SG
Last activity: 7 Dec 2018 10:27 EST
Is it recommended to have different Data schema for each application ?
Hi,
I would like to understand, if it is recommended to use different data schema for different applications built on same Org layer.
For Eg:
- We are implementing 3 applications (App1, App2 & App3) for an Organisation ABC. Two applications (App1 and App3) are under Division 1 and 1 application (App2) is under Division 2.
- All 3 applications are sharing AD authentication, Int layer and User admin function (as most of the users are common).
In such a scenario,
1. Should we use the same data schema with app specific transactional work tables?
OR
2. Should we split the data schema further for each application?
and what are the pros and cons of each approach.
Thank you in advance.
Accepted Solution
MUFG Bank
SG
I found a useful thread related to my question above:
https://collaborate.pega.com/discussion/share-rule-schema-non-shared-data-schema
EPAM Systems, Inc.
ES
I don't think so, you require the separate schema for different applications within the same organisation.
Pegasystems Inc.
IN
Hi Arpit,
As per my knowledge Application, specific transactional data means work objects, application specific custom data tables etc. if you place them in the org level you can have an option of reusability
if you want to place them at the application level I don't think you have any advantages and you have the additional burden of maintaining the common data along three applications.
Hope this helps and kindly let me know if you have more concerns
Regards
Prasanth
MUFG Bank
SG
Hi Prasanth,
In the scenario mentioned above, all the reusable functions/rules are kept at organisation layer. The work tables for each application is at implementation layer.
So, can I extend the split schema concept here to each implementation layer? Meaning, splitting the data schema further for each application/implementation/FW layer. What will be the pros and cons of it.
Thanks in advance.
Accepted Solution
MUFG Bank
SG
I found a useful thread related to my question above:
https://collaborate.pega.com/discussion/share-rule-schema-non-shared-data-schema
Accenture
CA
Hi Arpit. Can you please let me know if you were able to achieve this and any road blocks you encountered?
We are planning to have two data schema for co hosted applications. Please advice.
Accenture
CA
Hi Arpit. Can you please let me know if you were able to achieve this and any road blocks you encountered?
We are planning to have two data schema for co hosted applications. Please advice.