How to decouple cross databases query?

Question

Hi

I've been trying to find a solution for this company, where they several databases and applications cross referencing sql queries to pull data for different application.

Here's the summary of existing structure,

Existing structure

Database

1. Travel
2. CRM
3. Product

With travel app being their key app which perform search and collects/updates data from other two DB's.

Proposal

One of the suggestion is that to have Azure Search or Elastic search index on top of DB's so all the application will look to index via API instead of direct sql query.

However with the requirements and existing data structure sitting on different db, having a single index or split indexes for each db. Question relies on how to keep the data sync? or is there a possibility to perform a single search on different index at once?

Much appreciate for any feedback.

Answer 1

Hi @Uday Solanki ,

Is the reply helpful?

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.