These are estimates to calculate pricing for Azure Data Factory.



  • 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

Pricing assumptions

  • On-prem SQL Server has 100 tables.
  • There is 1 copy activity from on-prem SQL Server to staging Az