These are estimates to calculate pricing for Azure Data Factory.
- Microsoft Azure Data Factory pricing
- Azure Data Factory pricing examples
- Azure Data Factory copy activity performance
- Microsoft MVP Cathrine Wilhelmsen on Youtube about ADF pricing
- An on-prem SQL Server
- An on-prem Windows Server with Self-Hosted Integration Runtime
- ADF copies tables from on-prem SQL Server to staging Azure SQL DB (through Self-Hosted IR Server)
- ADF transforms data from Azure SQL DB to production Azure SQL DB (star schema SCD Type 2)
- Production Azure SQL DB is used for Power BI
- On-prem SQL Server has 100 tables.
- There is 1 copy activity from on-prem SQL Server to staging Az