Load azure data warehouse

  • a2zwd

    SSCrazy

    Points: 2342

    Hi

    I have on-premises sql server database. I need to load data from this DB to azure DW.

    What is the best solution?

    I am good in classic ETL using SSIS.

    When I search google, there are many options like traditional ETL(SSIS), ADF, Polybase, Azure BLOBs

    I am confused which one to use. I need to perform incremental load and schedule a job to refresh

    Please reply

  • RobertMPotter

    Newbie

    Points: 2

    Hi,

    Don't get confused also worry not about it. I can understand your worry regarding SQL server database. You can go for ETL (SSIS), ADF, Polybase or Azure BLOB as per your needs as all of these are having different data loading strategies. Still, if you are feeling confused, then try reading the data migration strategy. Hope you will get the best possible solution soon.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply