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?
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