Search code examples
python-3.xlinuxazureazure-functionsssas

Python library to connect to SSAS model in Linux environment


I had developed the script to refresh tables in SSAS model using python. It was working fine in my local, but I want to deploy the script in Azure Function.

In Azure Function, if we choose Python, only OS available in Linux. The python library (Pyadomd - https://pypi.org/project/pyadomd/ ) I used to refresh the table does not work on Linux, it works only with Windows OS.

Kindly suggest some alternative python libraries to connect to SSAS model to perform operations like partition creation, partition deletion, partition & table refresh.


Solution

  • see Can Install SSAS (Sql Analysis services) for Ubuntu. SSAS is not available on linux although there exists some other methods. First you have to install CData ODBC Driver then install pip install pyodbc. The full article is here https://www.cdata.com/kb/tech/ssas-odbc-python-linux.rst.