Trigger MS SQL Stored Procedure in BIRST

Christian Maldonado

Hi,

I just want to ask if the Stored Procedure will be triggered in Modeler → Connect when we add it as an extract object?

I added this code in the Query and the object is returning the result. However the table being populated in BI_Util.[dbo].[usp_dvProcessExecution] is not updated.

DECLARE @processName varchar(100)
SET @processName = 'PTO_Reporting'

EXECUTE BI_Util.[dbo].[usp_dvProcessExecution]
@processName = @processName
, @minimumSequenceToRun = 0
, @debug = 0

SELECT 1 as [result1], 1 as [result2]

Diane McElhiney

It seems you are trying to use the Birst Platform to execute a SP in your database to update a table in your database. The Birst Platform is not meant to do that. Calling SPs in Modeler/Connect will return results to the Birst Platform. The extraction is staged to a file within your Birst platform tenant that issued the connection. That file is then used to Publish that raw data into a staging or measure/hierarchy table in the Birst Platform data warehouse.