Pulling data from a Microsoft Server Analysis cube using cdata driver

[SJ3]

Hi, I am using following jdbc driver to pull data from a Microsoft Server Analysis cube:

https://www.cdata.com/kb/tech/ssas-jdbc-talend.rst

I can connect to the cube but I cannot run queries. I am getting following error:

XcoreXssasX180X6996.dmb: An error was encountered in the transport layer.

I want to use a generic login. Is there a way to stop windows authentication here? I think I am getting this transport layer error because Talend is using my windows authentication instead. Thanks!

SJ

[vapukov]

Hi,

but SSAS does not support standard SQL server authentification

https://docs.microsoft.com/en-us/sql/analysis-services/instances/connect-from-client-applications-an...

[SJ3]

Hi,

Thanks for your post! But I was able to connect to the analysis server cube using a generic login. I used tjdbc component to test the connection. 

[vapukov]

when you use tJDBC - you connect to SQL Server but not to SSAS

try to run Management Studio and connect to SSAS, you will see it also does not support SQL Server authentification