Dynamic ODBC Connection.

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.