有可用的 JOLAP 或 Olap4j 驱动程序吗?
是否有任何驱动程序可供 JOLAP 或 Olap4j 访问现有的 OLAP 服务?我想在 OLAP 服务上,比如 Oracle、MS SQL 等。
我们想用 Java 启动一个 OLAP 项目吗?我们应该从这两个 API 中的哪一个开始?
Are there any driver available for JOLAP or Olap4j to access existing OLAP services? I think on OLAP services like Oracle, MS SQL, etc.
We want start a OLAP project with Java? With which of the both API should we start?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
olap4j 是适合此类项目的完美 Java API。它设计用于 OLAP 的功能就像 JDBC 用于关系数据库的功能一样。它允许您针对与服务器无关的 API 编写应用程序,然后针对各种服务器运行该应用程序,而无需更改代码。此外,该 API 很容易学习,因为它使用与 JDBC 相同的概念。
使用 XMLA olap4j 驱动程序(包含在 olap4j 发行版中),您可以连接到任何具有 XMLA 驱动程序的 OLAP 数据库 —— 大多数数据库都是这样做的。它已针对 Microsoft SQL Server Analysis Services、SAP BW 和 Mondrian 等进行了测试。它应该适用于 Oracle 的 XMLA 提供程序 [ http://www.oracle.com/us/corporate /press/173668]但我没有尝试过。
请参阅 www.olap4j.org 了解更多信息。
朱利安·海德
(olap4j项目创始人)
olap4j is the perfect Java API for this type of project. It is designed to do for OLAP what JDBC does for relational databases. It allows you to write an application against a server-neutral API, and then run that application against various servers without code changes. Also, the API is easy to learn because it uses the same concepts as JDBC.
Using the XMLA olap4j driver (included with the olap4j distro) you can connect to any OLAP database which has an XMLA driver -- and most of them do. It has been tested against Microsoft SQL Server Analysis Services, SAP BW, and Mondrian, and others. It should work against Oracle's XMLA provider [ http://www.oracle.com/us/corporate/press/173668 ] but I have not tried it.
See www.olap4j.org for more information.
Julian Hyde
(olap4j project founder)
icCube 有一个 xmla 客户端库: http://www.iccube.com/products /contributions/xmla-client-library,尽管我自己还没有尝试过。
There's an xmla client library by icCube: http://www.iccube.com/products/contributions/xmla-client-library, though I haven't tried it myself.