Forum Discussion

Jerome22's avatar
Jerome22
Icon for Resolver I rankResolver 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.

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