topic Re: Dynamic Connection To Sources in Pipelines

Dynamic Connection To Sources

Anonymous — Fri, 29 Dec 2023 16:48:04 GMT

In Azure Data Factory you could create dynamic sources (Azure SQL DBs in our case) based on a Lookup or something, using parameters to fill in Server, Database, User, Pass, etc. I can't seem to figure out how you would do that in Fabric Data Factory, as the parameters option is missing for the sources. Am I missing something?

Re: Dynamic Connection To Sources

Anonymous — Tue, 02 Jan 2024 05:55:20 GMT

Hi Anonymous ,

Thanks for using Fabric Community.

Currently parameterization support for connection is not present in Fabric Data Factory.
But we can expect them in upcoming release. You can refer this link to check what's new planned for Fabric.

Incase if you have any specific requirment, appreciate if you could share the feedback on our feedback channel . Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this is helpful. Please let me know incase of further queries.

Re: Dynamic Connection To Sources

Anonymous — Tue, 02 Jan 2024 14:15:29 GMT

Alternatively, there is no way to load a Fabric Data Warehouse from an Azure Data Factory pipeline? I don't see that as a destination option.

Re: Dynamic Connection To Sources

NandanHegde — Wed, 03 Jan 2024 05:05:25 GMT

Hey, as stated as of now it is not possible to have dynamic connections in Fabric unlike dynamic values in ADF linked services.

Also, MSFT Fabric datawarehouse is not supported as soucre/sink in ADF

Re: Dynamic Connection To Sources

Anonymous — Wed, 03 Jan 2024 05:23:22 GMT

Hi Anonymous

As NandanHegde mentioned currently Fabric Datawarehouse/ Lakehouse is not supported as source/sink in ADF. Inorder to load the data in Lakehouse only option is to use Fabric Data Factory.

Re: Dynamic Connection To Sources

NandanHegde — Wed, 03 Jan 2024 07:21:17 GMT

hey Anonymous
a slight correction to what you have stated.

Lakehouse is supported in ADF but warehouse is not

Re: Dynamic Connection To Sources

Anonymous — Thu, 04 Jan 2024 08:45:38 GMT

Hi Anonymous ,

We haven’t heard from you on the last response and was just checking back to see if you got some insights .
Otherwise, will respond back with the more details and we will try to help .