Forum Discussion

sreedhar mella's avatar
sreedhar mella
Copper Contributor
May 25, 2017

Azure Data Factory

 Can I connect one dataset from one data source(sql server) and another dataset from another data source(another Sql server) then join these two datasets based on join key if exists and move data to Azure blob with combined data

1 Reply

  • Sunit Patil's avatar
    Sunit Patil
    Brass Contributor

    Hi Sreedhar,

     

    On any of your SQL Server you can link your 2nd server, then you can achieve it.

     

    Best

    Sunit Patil