topic Re: Stored Proc Activity/Connectivity in Data Engineering

Stored Proc Activity/Connectivity

asifsyed — Tue, 04 Mar 2025 03:03:55 GMT

From data pipeline, we are calling stored procedure via stored procedure activity.

In Settings of Stored Procedure, we have Connection which points to the warehouse name in a specific workspace.

Now the workspace name changes for each env.

i.e. say

Warehouse_SP (WorspaceA) -> dev

Warehouse_SP (WorspaceB) -> uat

The deployment pipeline does not have rules for pipeline. How do we handle this change while deploying to other workspace/env.

Re: Stored Proc Activity/Connectivity

v-nmadadi-msft — Tue, 04 Mar 2025 10:48:28 GMT

Hi @asifsyed ,
Thanks for reaching out to the Microsoft fabric community forum.

It is not possible to set the data pipelines parameters with the deployment pipelines yet. As a workaround, you could set a variable in the data pipeline passing workspace name as the parameter, where you look at the workspace id/name and set the value of the variable based on the value of the workspace id/name.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

Re: Stored Proc Activity/Connectivity

v-nmadadi-msft — Mon, 10 Mar 2025 11:43:31 GMT

Hi @asifsyed,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: Stored Proc Activity/Connectivity

v-nmadadi-msft — Thu, 13 Mar 2025 10:20:44 GMT

Hi @asifsyed

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Re: Stored Proc Activity/Connectivity

v-nmadadi-msft — Mon, 17 Mar 2025 04:01:20 GMT

Hi @asifsyed ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards