Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Connecting to SSAS from Linux
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Connecting to SSAS from Linux
 Login/Join
 
Expert
posted
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...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6303 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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,


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2046 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
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.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6303 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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}


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6303 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Connecting to SSAS from Linux

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.