MicrosoftHi sugidwani you'd have to put the different source database copy activities in something like a switch statement as there's no way to use a single connection (or linked service in old ADF) to cover several different database technologies. That's the only way to do it in normal/old Azure data factory...
Also, currently in Fabric it doesn't seem possible (unless you use data flows) to parameterise a connection like you could with old ADF linked services. I'm guessing (hoping) that MS will amend/improve the way connections work (as their currently just 'fudged' versions of PBI connections instead of the old ADF linked services) so they can be parameterised more easily without needing to use a data flow. Otherwise you'd need a separate connection for EVERY database (even if they're all SQL server for example) which is totally daft, thus defeating the point of using a meta data table driven pipeline like shown above.
Of course, Fabric is only in public preview at the moment so hopefully these features will come when GA...
jehayes- not wanting to pin you down for any official quote on this, but hopefully simple connection parameterisation is something that will come soon/eventually to Fabric? 😉
