โ05-10-2022 01:33 PM
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?
โ05-10-2022 03:52 PM
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
โ05-31-2022 03:55 PM
Hey Greg Fraser, were you able to find a solution to this?