Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dynamic Connection To Sources

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?

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable

        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.

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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 .