About Company

One of the leading healthcare AI company. Founded in year 2011. Host their data warehouse environment in AWS Redshift. Company helps healthcare systems prevent harm and lower costs. The system provide quality, cost-effective and patient focused care for some of the complex patients. Also, maintains the data of patients more accurately.

Project Summary

Migrating AWS Redshift to Azure SQL Data Warehouse. Azure SQL Data Warehouse has a pause and start function, is a high performance, lower-cost solution with an ability to scale and compute storage, less time is involved in installation and maintenance, includes various demographics tables and could run some queries in order to extract patients information.

Challenge

Migrating from AWS Redshift to Azure SQL Datawarehouse. Also, migrating queries from AWS Redshift environment to Azure SQL Datawarehouse environment.

Solution

We used PolyBase which uses T-SQL to join data which will help to move data from AWS Redshift to Azure SQL Datawarehouse. We moved data into the internal table and used PolyBase to run queries on external table, we performed migration using different customer designed queries.

Country

United States

Industry

Healthcare

Organization Size

Medium (51-200 Employees)

Solution

Bigdata & Analytics

Products & Services

• Azure SQL Datawarehouse
• SQL Server Management studio(18)
• AWS Redshift
• Azure Datafactory

Post Implementation Benefits

1. Easy scale-up and scale-out available in Pay-As-You-Go model.
2. Automated data backup.
3. 24*7 IFI Support.
4. Alerts Setup.
5. Data Security