Merging data silos

In this scenario, multiple applications from different vendors are used in one company workflow. The applications are not integrated, and their data is isolated, only accessible by a single application.

From the user's perspective, the data across these databases should be connected. Switching between these apps all the time makes the work inefficient, and is a source of frustration for the users.

If there are distinct user roles for data creation and data access, it could be highly beneficial for the data access user to see all the data related, harmonized, and accessible via a single GUI.

Finding the right connection points between the silos can be challenging, but if there are some permanent global identifiers, which are not vendor/system specific, then those can be used to make the connections, aggregate the data across the isolated silos.