Dynamic Connection To Sources

[jacobgolden]

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?

[v-gchenna-msft]

Hi @jacobgolden ,

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 .

[NandanHegde]

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

[v-gchenna-msft · Accepted solution]

Hi @jacobgolden ,

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.

[jacobgolden]

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.

[v-gchenna-msft]

Hi @jacobgolden 

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.

[NandanHegde]

hey @v-gchenna-msft 
a slight correction to what you have stated.

Lakehouse is supported in ADF but warehouse is not