Post reply

Load azure data warehouse

  • April 8, 2019 at 10:50 am

    #3011546

    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

  • August 3, 2019 at 6:30 am

    #3668448

    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 1 (of 1 total)

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