Setting Microsoft Analysis Services as Data Source

Question

I'm trying to set as data source some cube on Analysis Services, but the Analysis Service just accept authentication by network domain and when I try to set domain\user (like in others windows application) the test fail.

There is a way to connect to Analysis Services by domain?

How to set?

Answer 1

In Knowage, the main two way to interact with external data sources is to use JDBC driver or REST interface, but ti seems that Analysis Services only accept XMLA-like protocol to communicate.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ed6d7e90-0ca0-4b4b-8c5a-9e3757100800/can-we-connect-to-analysis-services-using-java?forum=sqlanalysisservices

For this reason, the only way to exploit would be the one documented here http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/WhatIf#HXMLAConnection