Forum Discussion

Jerome22's avatar
Jerome22
Resolver I
2 years ago

execute activities in another workspace?

Hi,   How can I execute activities like a stored procedure but where the warehouse is in another workspace than where my pipeline is stored?   I have a first workspace "Finance data" and a second...
pipelines
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Jerome22 ,

Thanks for using Fabric Community.
We don't have direct connection or way to do it. But we have a work around to achieve this goal.

Can you please check the below steps:

Open the Warehouse in another workspace and copy the SQL Connection String -


Add stored procedure and click external connection -


Please paste the SQL Connection String here ans Sign in to Organizational Account -


Please select the warehouse and stored procedure present in different workspace -


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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Jerome22 ,

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

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Jerome22 ,

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

      Thanks

  • AnirL's avatar
    AnirL
    Frequent Visitor
    1 year ago

    Hi, 

    I am trying to replicate the process that you have outlined. But unfortunately, I am not sure where you got the "New Connection" interface from. Can you please include the intermediate steps to create the New Connection in Fabric?
    Many thanks!!