Execute XMLA on a Unix server

Question

Hello,

I would like to know what the best option is to trigger a SSAS cube refresh from an Unix server.

 

Today I am using powershell on windows with the powershell command line:

Invoke-ASCmd -Server myserver:port -InputFile my_refresh_instruction.xmla.

 

In a near future, we are planning to decommission the windows server that we are currently using, and we will only have Unix servers.

 

How can we execute XMLA on a Unix server ?

What is MS SQL Server support recommandation on this ? I can’t find any information on Internet ?

• Do you recommend Powershell on Unix ?
• Do you recommend to do it with an SQL Agent job ?

(https://learn.microsoft.com/en-us/analysis-services/instances/schedule-ssas-administrative-tasks-with-sql-server-agent?view=asallproducts-allversions)

 

Many thanks for your help !

Answer 1

The ASCmd-CmdLet utilize the AdoMD .NET Frameowrork, AFAIK not available for Unix. I don't think you get it working on Unix.

Use any other Windows machine, could be also a small workstation.