Unlock the Power of your SQL Server Data with AWS Data Lake

Bachar Rifai, Varvara Murphy, Simon Cunningham

In this session, we will propose a modern data architecture as a mechanism to drive innovation from business insights in siloed data on SQL Server operational systems end to end.
We will give an overview on the process to feed a data lake using the native AWS tooling to build data pipelines and catalog data derived from your SQL Server databases.
We will describe the use of Redshift serverless as a cloud native Data Warehouse for stage and data mart and the use of Athena and integrated ML services to derive BI dashboards and derive business insights directly from the datalake or data warehouse.
Finally we will run through a use case scenario specific to a SQL Server ERP application to showcase the art of the possible.