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 one "Compliance data".

in the finance data workspace I have a pipeline in place to refresh some data, but I have to refresh data in my warehouse stored in the compliance data workspace.

I want to run a pipeline there or (at least) want to run stored procedures in the warehouse from this second workspace.

 

how can I do that?

pipelines

4 Replies

  • 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!!