This calculator estimates monthly Azure Data Factory costs based on:
Pricing Model Differences:
For bc2adls, the ADF cost is more predictable and adjusted only by enabled modules and the number of runs per day.
This is because the new staging method does not need to loop through every company to load the data.
The cost can vary a little depening on the data volume, but the impact is minimal.
For Standard pricing, the ADF costs scale with data volume, execution frequency and the number of companies.
In short, the bc2adls model is a little bit more expensive when running a single small company, but as soon as you have multiple companies or larger data volumes, bc2adls becomes significantly more cost effective.
When selecting the database service tier for either scenario, you will need to consider the data volume and performance requirements of your specific deployment.
In our load testing, we have found that the S2 service tier is sufficient for up to 300,000 rows per run.
Larger deployments with multiple companies or higher data volumes may require higher service tiers to ensure optimal performance.