Tableau Connector for Asana

Build 21.0.7930

Executing Stored Procedures

Stored procedures are available to complement the data available from the Data Model.

Executing Stored Procedures

Stored procedures can be executed using the custom SQL window that appears when selecting New Custom SQL from the bottom of the table list.

Procedures can be executed using the EXECSP system table with the following syntax.

SELECT * FROM(SELECT * FROM EXECSP ('SchemaName.ProcedureName',StoredProcedureInput1,StoredProcedureInput2,...))

SchemaName denotes the name of the connection that the table list is pulled from. ProcedureName is the name of the stored procedure to execute.

Note that the stored procedure inputs are dynamic, there will be as many as are documented (and in the same order documented) in the procedure's page in the stored procedures section.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930