The new platform utilised Microsoft SSIS for data integration and their SQL server for the data warehouse. We used the AWS database migration service and SAS visual analytics for data exploration, reporting and model building.
The environments were built using Cloudformation for the VPC and SAS EC2. The automation was achieved using Ansible, enabling rapid and repeatable deployment.