Dynamic/Widespread SQL Ingestion With On-Premises Gateway

I don't have a solution but I can see where you would find that having this feature could be beneficial. While having that many similar pipelines will require a bit of initial setup, I have found that there are benefits to having multiple pipelines.

My organization has a simliar setup with many servers, usually one for each vendor. Sometimes we experience an issue with a load failing from the vendor to our sql server, which will then cause our pipeline to fail. With having individual pipelines for each server, the impact of a load failing is limited to just the tables loaded in that pipeline, rather than our entire data library.