cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft Analysis Services Connection?

gfraser
Deputy Chef I
Deputy Chef I

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?

2 REPLIES 2

max-knutsson
Workato employee
Workato employee

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

meghan-legaspi
Community Manager
Community Manager

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