从R或Node.js连接到Analysis Services [英] Connecting to Analysis Services from R or Nodejs

问题描述

我正在尝试通过R或Node.js连接Analysis Services.

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

对于R，我发现以下库: https://github.com/overcoil/X4R

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

对于Nodejs，我发现了以下库: https://github.com/rpbouman/xmla4js

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

Analysis Services服务器是外部的.它不在我的本地计算机中.目前，我能够使用Windows和基本身份验证(用户名/密码)从Excel成功连接它.

Analysis Services Server is external. It is not in my local machine. Currently I am able to connect it successfully from Excel using both Windows and basic authentication (username/password).

要通过R或nodejs访问它，在下面的链接中说我需要使用IIS配置http访问.但是由于它不是本地的，我该如何获取 文件msmdpump.dll并进行配置.

For accessing it through R or nodejs, in the following link it is said I need to configure http access using IIS. But since it is not local how can I get the file msmdpump.dll and configure it.

在此链接中 https://www.linkedin.com/grp/post/77616 -265568694 ，最后，莎拉·卢肯斯(Sarah Lukens)说，我需要遵循

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

由于我以前从不从事SSAS工作，因此我不太清楚.谁能指导我建立从R或Nodejs到Analysis Services的连接.然后，我只想提交MDX查询并获得结果.

Since I didn't work before in SSAS, I don't have much clarity. Can anyone please guide me in establishing the connection from R or Nodejs to Analysis services. Then I just want to submit the MDX queries and get the result.

谢谢， 卡蒂克(r karthik).

thanks, r karthik.

推荐答案

没有IIS，似乎无法远程连接到SSAS.您必须共享msmdpump.dll才能通过xmla接口访问第三方API的SSAS连接.

It seems there is no way to connect to your SSAS remotely without IIS. You have to share your msmdpump.dll in order to get access to your SSAS connection for third-party APIs via the xmla interface.

这篇关于从R或Node.js连接到Analysis Services的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！