Data Factory
Needs VotesConnections should be parameterized to allow for connections across multiple similar connection types
Cyndi Johnson on 06 Jul 2023 20:16:19
In ADF, you can parameterize a linked service so that one linked service could communicate with multiple database servers/databases. In Fabric, you would need a connection for every database. Please make connections parameterized so that working with an enterprise-level multi-tenant source database system would be easier.
- Comments (1)
RE: Connections should be parameterized to allow for connections across multiple similar connection types
Currently we need to create a pipeline for every SQL server we want to simply copy data from, this is a huge and unrealistic task to build and maintain so many pipelines instead of being able to just parameterize the server and database in a similar way to Azure Data FactoryThis 1 feature being missing necessitates a 100 fold increase in work to ingest data from on prem SQL servers, adding it would enable true metadata driven pipeline ingestion in Fabric