Mondrian xml服务mysql_Mondrian xmla Provider的配置

本文档介绍了如何设置Mondrian XMLA服务,包括在datasources.xml中描述数据源,详细列出了配置各个参数如Provider、Jdbc、JdbcDrivers、Catalog等,并提到了针对不同XML/A客户端的支持情况以及在web.xml中配置XmlaServlet的步骤。
摘要由CSDN通过智能技术生成

To will setup XMLA service, follow these steps.

1. Describe the data sources in datasources.xml

In WEB-INF directory of your webapp, create a file called datasources.xml, with content like this:

MondrianFoodMart

FoodMart 2000 Data Warehouse From MS Analysis Services

http://localhost:8080/mondrian/xmla

Provider=mondrian; Jdbc=jdbc:odbc:MondrianFoodMart; JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver

MDP

Unauthenticated

/WEB-INF/schema/FoodMart.xml

Provider=mondrian; Jdbc=jdbc:odbc:MarketingDB; JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver

/WEB-INF/schema/Marketing.xml

PostgreSQLTest

Test Data Warehouse On PostgreSQL

http://localhost:8080/mondrian/xmla

Provider=mondrian; Jdbc=jdbc:postgresql://localhost/olap; JdbcDrivers=org.postgresql.Driver; JdbcUser=pgsql; JdbcPassword=pgsql

Mondrian

MDP

Unauthenticated

/WEB-INF/schema/TestPgsql.xml

备注说明:

URL:xmla所在地址,tomcat端口号可能不同,请改为安装tomcat时设置的端口号;datacourceinfo部分

Provider:提供者必须是mondrian

Jdbc:数据库jdbc驱动的路径,此处为acceess数据库,不同数据库的jdbc路径请参阅相关文档

JdbcUser:用户名

JdbcPassword:密码

JdbcDrivers:jdbc完整的驱动名称,此处为access数据库,不同数据库的驱动名称请参阅相关文档

Catalog:cube文件存放的路径

 and  are ignored because the XML/A implementation currently only supports 'MDP' and 'Unauthenticated'.

Multiple data sources and multiple catalogs

if you intend to use Mondrian with Microsoft's ADOMD.NET client library or Simba's O2X bridge, the data sources file must have precisely one  element. These clients will ignore all but one data source. Other XML/A clients, such as Rex, work fine with multiple data sources.

Note that each catalog has a name attribute, and the URI (path) of an XML schema file. The name of the catalog must match the name attribute in the schema file (for example ).

Whether  you use one data source or several, the catalogs in the datasources.xml file must have unique names.

Configure XmlaServlet in your web.xml

(1)       修改…\Tomcat 6.0\webapps\mondrian\WEB-INF中web.xml文件对应内容如下:

MondrianXmlaServlet

mondrian.xmla.impl. MondrianXmlaServlet

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值