Another leading healthcare provider was keen to utilise the power of new cloud technologies for data warehousing and reporting, but also to reduce its dependency on coding and ETL development, speed up data movement and automate as much as possible.
The Needs / Challenges
- Replicate data from multiple sources – legacy mainframe and RDBMS systems into new cloud-based data warehouse
- Reduce reporting query burden
- Real time change data capture with minimal impact on production systems
- Able to support High Availability environments
- Simplify costly ETL development
- Scalable
The Solution
- Attunity Replicate – Informix and SQL Server to Snowflake on AWS
The Results
The business can now consolidate its production data into one cloud based target, empowering its business users to gain access to all data, when they need it.