Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleUnfortunately these vendors for various reasons make it hard for you just to query read these databases

Most vendors make it difficult for their customers to just query access these databases. There is some genuine technical good reason for that. Sometimes they want to change them.

The economics of many vendors selling cloud applications for instance is that they need to be able to control costs - they use quite a small amount of hardware resources per customer which would become larger if customers started to heavily access the data in these systems.

There are also business reasons - a lot of vendors want to upsell their customers on the ‘gold package’ with extra functionality that is integrated into the system.

So in practice most vendors put limits around how easily their customers can access their own data from the vendor system.

...

Expand
titleYou can automate the reporting and you can combine data from multiple systems!

This is what really rocks about building mirror databases. It allows you to build reporting and dashboards off your systems in a way you simply cannot do with each vendor application.

In your mirror database you can cross query data between say your customer relationship management system and your accounting system. Or between your content management system with lead data with your customer relationship management system and so on.

This is where things get awesome because you can really Take control Control of your data.Data