Clever Geek Handbook

Connecting to Analysis Services from R or Nodejs

I am trying to connect Analysis services from R or Nodejs.

For R, I found the following library: https://github.com/overcoil/X4R

For Nodejs, I found the following library: https://github.com/rpbouman/xmla4js

The Analysis Services server is external. This is not on my local machine. Currently I can successfully connect it from Excel using both Windows and Basic Authentication (username / password).

To access it via R or nodejs, the following link says that I need to configure HTTP access using IIS. But since it is not local, how can I get the msmdpump.dll file and configure it.

In this link https://www.linkedin.com/grp/post/77616-265568694 , at the end Sara Lukens said that I need to follow the steps outlined in https://msdn.microsoft.com/en-us/library /gg492140.aspx

Since I have not worked in SSAS, I do not have more clarity. Can anyone please help me to establish an R or Nodejs connection for Analysis Services. Then I just want to send MDX requests and get the result.

thanks r karthik.

+3


source to share


1 answer


There seems to be no way to connect to your SSAS remotely without IIS. You have to share your msmdpump.dll in order to access your SSAS connection for 3rd party APIs through the xmla interface.



0


source






More articles:


All Articles