Question

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.

Correct Answer
June 25, 2018 - 3:26am

Comments

Keep up to date on this post and subscribe to comments

Pega
January 22, 2018 - 11:02am

I don't think so, you require the separate schema for different applications within the same organisation.

January 23, 2018 - 3:22am

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

 

January 25, 2018 - 4:16am
Response to prasanthkumar

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.

June 25, 2018 - 3:26am

December 7, 2018 - 10:27am
Response to ArpitS1704

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.

December 7, 2018 - 9:59am

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.