Okay, so the Best-of-Breed option is not perfect however I just wanted to highlight that it is an option with plenty of benefits. Furthermore, it also has challenges, so let me high-light a few of them and try to provide ways you can overcome these.
Multiple databases, resulting in multiple versions of the truth. In other words, you might get a different answer depending on which solution you report from.
So how to solve this challenge?
So how to solve this challenge?
Multiple databases, resulting in multiple versions of the truth. In other words, you might get a different answer depending on which solution you report from.
So how to solve this challenge?
- Real-time integration – should your environment, skills and budget allow, this is one of the ways to solve this issue, but in most cases, the infrastructure and budget does not allow for it.
- Data analysis and reporting platform – this used to be a very lengthy and expensive way to solve this issue, but with all the cloud analytics and modern data architecture solutions available, this is becoming a much quicker and more affordable solution and definitely one of my favorites. This could even be a solution to some of your current challenges, should you run multiple solutions with multiple databases.
So how to solve this challenge?
- Take charge - my view is that this problem is not going away soon and as such business must enable themselves to take charge and deal with this. In most cases solution providers get away with this, because there is no-one in the business who fully understands the solution and who can spot the lies. If you don’t have someone in-house, contract someone in with the knowledge and experience to fulfil that role in your team.