How to connect to OLAP cube (Referring Accelerator as a DLL) using Nodejs

Answered

Hi,
I am using Nodejs as my backend. Is it possible to connect to OLAP cube by referring accelerator as DLL from nodejs ? Can you please proivde me with an example. Thanks.

6 answers

Public
Dmytro Zvazhii Flexmonster September 18, 2018

Hello Sudhashree,
Thank you for your question. Referring to the accelerator as DLL implies that you are using Microsoft stack of server technologies such as ASP .NET and .NET Core. In case you are using Node.js as your backend, we recommend launching Flexmonster Accelerator as a separate instance on your server. Please find more information here: https://www.flexmonster.com/doc/installing-accelerator-as-a-windows-service/.
Let us know in case of any other question.
Regards,
Dmytro

Public
Sudhashree September 19, 2018

Thanks Dmytro. I am able to connect to OLAP cube using Console application. But getting the below error while trying to connect to Cube using Flexmonster Accelerator as a windows Service.
Also, Can Flexmonster accelerator can be launched as a service in Linux OS ? 
2018-09-19 12:42:07.3654 | TRACE | Data Source=localhost;
2018-09-19 12:42:09.3786 | ERROR | Data Source connection – FAILED
2018-09-19 12:42:09.3786 | ERROR | A connection cannot be made. Ensure that the server is running.
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Flexmonster.Proxy.FlexmonsterProxy.TestConnection()

Public
Tanya Gryshko Flexmonster September 19, 2018

Hello, Sudhashree,
Thank you for your prompt reply.
Please check that the default user has enough rights to access the cube. This is the most probable reason for such error.
As about OS, Flexmonster Accelerator is available as a service only for Windows.
Please let me know if you’re able to get the Accelerator working as expected.
Regards,
Tanya

Public
Sudhashree September 19, 2018

Hi Tanya, 
Thanks for your reply. The user has default rights to access the cube. I am able to connect to cube when Flexmonster Accelerator is installed using console application. The connection is not established when I try to install Flexmonster accelerator as windows service.

Regarding OS , can we install flexmonster accelerator using console application in Linux OS ?

Public
Iryna Kulchytska Flexmonster September 20, 2018

Hello Sudhashree,

You write that you are able to connect to the cube using Flexmonster Accelerator console application. Based on this we can make an assumption that Analysis Services is up and running correctly.

The difference between the connection to the cube using Flexmonster Accelerator console application and using Flexmonster Accelerator windows service is under what user they are running. Flexmonster Accelerator console application is running under Administrator user. You can check under what user Flexmonster Accelerator Service is running https://www.screencast.com/t/lpo0ABERJwz. Analysis Services service is running usually under the different user https://www.screencast.com/t/oTgqg8LNIwf. The user under which Flexmonster Accelerator Service is running should have enough rights to access the cube. You can check your settings and adjust them to enable the connection.

Additionally, when you use Data Source=localhost; as a connection string, this means that you will try to connect through the standard port. If Analysis Services service was configured to run on the different port, the port should be specified in the connection string.
 
Please let me know if the above two recommendations were helpful.

Regarding Linux OS, Flexmonster Accelerator is available only for Windows.
 
Kind regards,
Iryna

Public
Sudhashree September 20, 2018

Thank you very much, Iryna. I will check the user access for the cube in Analysis Services.  

Please login or Register to Submit Answer