If a person has numerous databases (because of separate application front-finishes) that offer an entire picture - for instance a CRM, accounting, and product database - what techniques are for sale to centralize/abstract this data for simple confirming?
Basically, I am wondering if there's a method to instantly pull data from multiple databases right into a central repository that's continuously up-to-date in the three databases and which can be used as confirming?
I am also available to alternative best practice suggestions?
you could have sights that join data all your other databases.
Or would you like duplicated data on all servers?