HomeAzure Data FactoryAzure Data Factory and SSIS compared

Comments

Azure Data Factory and SSIS compared — 4 Comments

  1. James, ADF might not be as inexpensive as it’s sold. ADF is priced per activity. An activity can move data from only one source table (dataset) to one destination table (dataset). For high frequency activities (executing more than once a day) it will cost you ONLY $1 a month. That looks cheap right? Well, for most large companies implementing ADF across the enterprise would result in thousands if not tens of thousands of activities. Guess what, that $1 just ballooned into more than $10,000/month for ADF alone. You are still going to pay for the Apache Spark/SQL DW/ADLA computation resources where such data would be transformed and further analyzed … in addition to ADF. Questions linger on whether it’s worth taking the ADF route.

  2. Great post, James. I just wanted to note that you can use Biml to automate ADF as well. We are doing it on my current project copying data from on prem SQL Server to ADLS, and it has worked well.

  3. I think it worth pointing out that ETL is in fact:
    Extract – Transform – Load
    But you also get ELT tools as well (e.g. Oracle Data Integrator) where the data is extracted from source, loaded into target and then transformed.

    As such, I think what you are saying is that SSIS is an ETL tool whereas ADF is an ELT tool, amongst other differences.

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>