Azure Analysis Services

Web Resources

Automated enterprise BI with Azure Synapse Analytics and Azure Data Factory
3/6/2020, Manual
This reference architecture shows how to perform incremental loading in an extract, load, and transform (ELT) pipeline. It uses Azure Data Factory to automate the ELT pipeline. The pipeline incrementally moves the latest OLTP data from an on-premises SQL Server database into Azure Synapse. Transactional data is transformed into a tabular model for analysis.
Enterprise BI in Azure with Azure Synapse Analytics
3/4/2020, Manual
This reference architecture implements an extract, load, and transform (ELT) pipeline that moves data from an on-premises SQL Server database into Azure Synapse and transforms the data for analysis.