topic Re: Pulling data from a Microsoft Server Analysis cube using cdata driver in Talend Studio

Pulling data from a Microsoft Server Analysis cube using cdata driver

SJ3 — Tue, 19 Mar 2019 19:20:46 GMT

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!

Re: Pulling data from a Microsoft Server Analysis cube using cdata driver

vapukov — Tue, 19 Mar 2019 21:23:07 GMT

Hi,

but SSAS does not support standard SQL server authentification

https://docs.microsoft.com/en-us/sql/analysis-services/instances/connect-from-client-applications-analysis-services?view=sql-server-2017

Re: Pulling data from a Microsoft Server Analysis cube using cdata driver

SJ3 — Tue, 19 Mar 2019 21:36:48 GMT

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.

Re: Pulling data from a Microsoft Server Analysis cube using cdata driver

vapukov — Tue, 19 Mar 2019 21:59:38 GMT

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