Server/client command

Previous Member

Hi guys,

 

I have a customer who runs BOARD in the cloud and am trying to trigger a Stored procedure using a powershell or batch file which i would like to run via the server command option in BOARD. Would this be possible? If not, what would be an alternate solution?

 

Your help would be much appreciated.

 

Regards,

 

Ghalid

Björn Reuber

Hi,

 

if you want to run a Stored Procedure, I assume you want to start a Process in MS SQL Server.

For this case I would create it in a different way (much simpler way). Just use a SQL DataReader (mapped to a dummy/empty entity/cube) with a manual query using EXEC (to start the stored procedure). You can also save the return value to a certain cube, to start a certain action within board depending on the Value.

 

For details on Stored Procedure please see following discussion

https://community.board.com/message/2850-re-store-procedure?commentID=2850#comment-2850 

Regards

Björn

Previous Member

Hi,

 

Thanks Bjorn.

 

When u say "Just use a SQL DataReader (mapped to a dummy/empty entity/cube) ", do you mean, create a dummy cube which has the entities as in the table which is being used for import data?

 

Regards,

 

Ghalid

Björn Reuber

yes and no,

if you use an SQL DR you need map the Result from the Query (or the Exec) to some board elements

Previous Member

Bjorn, should this work too for the cloud version. I can do a select * from a table, which works fine, but exec a SP doesn't seem to work. Are there limitations for the cloud solution on executing SP?

Björn Reuber

Hi,

 

don't know if this also work with Cloud. As far as I know the SQL Statement should be re-routed directly, so it might work. Does the exec work from MS SQL Manager?

 

Regards

Björn

Previous Member

Hi, the exec work from MS SQL manager. It might be a (cloud)security/limitation.. Is this something i can validate with the cloud team of Board?

 

regards,

Björn Reuber

hi, sure maybe they now in detail if its also supported with Cloud to OnPrem connector

 

regards

Björn

Previous Member

Hi Ghalid si Boukaceme 

Did you ever get a conclusion to all of this? I'm having the same issue, and wondering if its at all possible when using the cloud version. 

Previous Member

Hi Greg Wilson,

 

I have managed to run a SP using a datareader with the cloud version. Is this you're also trying to accomplish?

Lorenzo Colelli

Hi,
Please can you give me further information about "how to run a SP" in cloud enviroment?
Can you give me an example?
I've tried to run EXEC SchemaName.ProcedureName; but it doesn't work.
Doesn't work either EXEC dbName.SchemaName.ProcedureName;
Thank you very much 
Lorenzo

------------------------------
Lorenzo Colelli
IT Supply Chain Manager
POMELLATO SPA
Italy
------------------------------
-------------------------------------------