Question

6
Replies
1075
Views
ArpitSharmaLSA Member since 2017 3 posts
Oversea-Chinese Banking Corporation Ltd
Posted: 2 years ago
Last activity: 1 year 9 months ago
Closed
Solved

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.

Data Integration
Moderation Team has archived post
Share this page LinkedIn