The Cloud offers many advantages and many organizations are looking to utilize Cloud solutions. But how easy is it to move an existing Data Warehouse to Microsoft Azure or Amazon Web Services? To gain insight and better advise our clients, Data Warehouse Consultants has begun two research projects to identify the benefits and pitfalls of a move to the Cloud.
One project migrates an existing operational data warehouse to Microsoft Azure utilizing Azure SQL Data Warehouse, SQL Server Integration Services (SSIS) and T-SQL in a cloud hosted server environment. The other project migrates the same operational data warehouse to AWS Redshift using Python in the AWS Lambda serverless environment.
Through these two parallel development efforts, Data Warehouse Consultants will be better positioned to help clients evaluate the different Cloud based solutions and assist an organization as it migrates existing systems or implements new solutions in a Cloud based environment.