Microsoft Analysis Services Connection?

gfraser — Tue, 10 May 2022 20:33:56 GMT

Hi Pros, I am wondering if you can connect to an on-prem Microsoft Analysis Service? If so, can anyone point me in the right direction for the config.yml settings required for Workato?

Re: Microsoft Analysis Services Connection?

max-knutsson — Tue, 10 May 2022 22:52:24 GMT

Hi Greg, it might be tricky because SSAS does not provide an easy to access REST API, however it does have an XML API. I can give some ideas on how this could be done.

1. SSAS does offer XML/SOAP web api, you will need to activate it following these instructions. The process requires admin rights to create IIS8 profile etc. https://docs.microsoft.com/en-us/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0?view=asallproducts-allversions&viewFallbackFrom=sql-server-2017

then using HTTP profile configure to access the HTTP endpoint on IIS https://docs.workato.com/on-prem/agents/profile.html#http-profile

2. (probably easier) Go via MS SQL Sever connector, I do not think we can connect today to SSAS instance but if you can create a virtual-table / View or databump into one SQL Server database then you would have an access point. https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/explore-data-in-a-data-source-view-analysis-services?view=asallproducts-allversions

The #2 will be a MS SQL Server profile https://docs.workato.com/on-prem/agents/profile.html#database-profile

Re: Microsoft Analysis Services Connection?

meghan-legaspi — Tue, 31 May 2022 22:55:14 GMT

Hey Greg Fraser, were you able to find a solution to this?

topic Re: Microsoft Analysis Services Connection? in Workato Pros Discussion Board

Microsoft Analysis Services Connection?

Re: Microsoft Analysis Services Connection?

Re: Microsoft Analysis Services Connection?