Case Study: Mercer
Share on:
LinkedIn
WhatsApp
Email
Mercer is one of the world’s leading firms for superannuation, investments, health and human resources consulting and products. Their global team help clients to create solutions that drive business results and make a difference in the lives of millions of people every day.
With this in mind, it is imperative that they support their staff and clients with up-to-the-minute data so that they can make timely, balanced and informed decisions.
The Needs / Challenges
- Capture changes in real time from an on-premises MS SQL Server instance to the Azure cloud
- Negligible impact to source business applications
- Must have visibility on processes currently executing, and executed, as well as audit logging and management
The Solution
- Attunity Replicate – MS SQL Server to Azure SQL
The Results
- After successfully trialling Replicate for a proof of concept, the business quickly realised the benefits of real time change data capture
- Reports can now be run by the business users based on real time data
- Reduced a 3-day lag for mission critical reporting down to near real time.
- Expanded use cases into the wider MMC organisation.
