execute activities in another workspace?

[Jerome22]

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?

[v-gchenna-msft]

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.

[v-gchenna-msft]

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

[v-gchenna-msft]

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