Hello @ShanthanPaladi
You can't achive it using on-premise data gateway, the right way to go about is to use a self-hosted integration runtime SHIR, which should work for ADF pipelines, since you mention you're already using it.
You can create a Linked Service using a DSN with parameterised attributes and an appropriate driver.
Driver={Firebird/InterBase(r) driver};
Dbname=@{linkedService().fileName};
Uid=@{linkedService().userName};
Pwd=@{linkedService().password};
Client=fbclient.dll;
Role=;CharacterSet=UTF8;Dialect=3;
"fileName" is the only value that would be different across your 80 connections. It is best to place the user credentials in a Key Vault.
Please note, parameterised linked service won't work on Fabric data pipelines, it is only relevant if you're using Azure Data Factory.
I trust this will be helpful. If you found this guidance useful, you are welcome to acknowledge with a Kudos or by marking it as a Solution.
