Hi All,

Has anyone connected from a linux install to SSAS ?

We do have a third part JDBC driver for it from cdata, but cannot get it to work.

Has anyone done this ?

This message has been edited. Last edited by: Waz,

Waz

Do you have the jdbc driver in the CLASSPATH? The adapter administration guide only talks about OLE/DB connection but I think JDBC should work if it can find the jar file and you have a correct connection string. what error are you getting?

This message has been edited. Last edited by: FP Mod Chuck,

Yes, it was in the path.

We had a long session yesterday and worked out the connect string for the JDBC Adapter, and we got a connection. It just doesn't support the SSAS Models measures and dimensions.

Just in case anyone else tries to use CData's JDBC connector for SSAS, the connect string should be:

jdbc:ssas:URL=http://server{: port}/OLAP/{msmdpump.dll};Catalog={DB}