MicrosoftjehayesYeah you're correct, with ADF you need a different linked service per database technology type. Then use a SWITCH to execute different COPY activities depending on the database technology (I've done this and its a bit ugly, but its the only option). Obviously if you're only dealing with source data from say database technology like SQL server databases then you don't need it as a single parameterised SQL server linked service would be fine... but then again, who is lucky enough to be in that situation 🙂
My dream scenario I guess would be somthing like the ability to parameterise the database technology type (e.g. SQL server, PostgreSQL etc...) and also the connection string, as I reckon this would cover a lot of cases. You might of course need some additional connection configuration options for if/when a connection needed Windows auth (for just one example). But imagine a single parameterised connection where you just passed the database technology type and a connection string... oh I dream of the day 😉
Thanks for checking, and also liked your original post, its definitly the way to go 🙂
P.S. if you happen to bump into any of the Fabric dev's, please ask them if they could make my dream come true! 😉
