Reporting across multiple applications in same Apps server instance.
Please share your thoughts on the below,
We are trying to build 2 different applications[APP1, APP2] within a same Instance(App Server) they both will be sharing the same Database - Rules/Data Schema. Since these two applications will be parallel not build on top of either, is reporting still feasible having said that they both share the same Data Schema but with different work tables.
Example : If the Customer Number column is common across both the application work- tables, we need to run a report across both the applications to give a consolidated view of all the In progress cases.
We are planning to have a wrapper application which will be built on both the applications (APP1 and APP2) from where we can switch between either of the applications and also to see the consolidated dashboard and wrapper application is not meant for any case creation.
The Question is how feasible it would be to generate the consolidated reports from the wrapper application.
We are planning to have 2 different applications and not as 1 App with multiple case types as they both will be serving for altogether different business purposes. Need to know the best practice of having multiple application vs one with various case types.