Welcome to Knowage Q&A

Here you can read the Q&A history.

To get new community support please go to GitHub discussions (KnowageLabs/Knowage-Server · Discussions · GitHub).

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

Setting Microsoft Analysis Services as Data Source

0 votes
1 view
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?
Environment Knowage 6.1.1, Windows 7
in General Configuration by (120 points)

1 Answer

0 votes

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

by (15.2k points)
Powered by Question2Answer
...