Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aclarke
Posting Yak Master
133 Posts |
 Posted - 2002-11-08 : 00:34:17
|
| I'm new to Analysis Services / OLAP and fairly new to Java too. I have a project that seems to lend itself to OLAP and I'm writing the logic tier in Java.Is there a way of accessing an OLAP cube from Java? Preferably a FREE way? I only have SQL Server 7.0 - is that going to severely hamper this project?Thanks!- Andrew. |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-11-08 : 13:36:37
|
-I haven't tried this, but Microsoft provides a PivotTable service that eases access to cubes on SQL Server.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/pt_intro_61b9.aspHere's the first paragraphquote:
PivotTable® Service is the primary interface for applications interacting with Microsoft® SQL Server™ 2000 Analysis Services. It is used to build client applications that interact with multidimensional data. PivotTable Service also provides methods for online and offline data mining analysis of multidimensional data and relational data. PivotTable Service is included as part of Analysis Services, and it can be redistributed by third-party client applications.
-Yes, it's 2000 instead of 7.0. I haven't found an MDX OLE DB provider for 7.0 other than the standard ODBC OLE DB Provider included with SP3+.Edited by - Kevin Snow on 11/08/2002 13:40:03Edited by - Kevin Snow on 11/08/2002 13:47:55 |
 |
|
|
|
|
|
Accessing OLAP via Java?