<?xml version= "1.0"?>
<!--
= = $Id://open/mondrian-release/3.1/webapp/web-inf/datasources.xml#2 $
= = This software are subject to the terms of the Eclipse public License v1.0
= = Agreement, available at the following URL:
= = http://www.eclipse.org/legal/epl-v10.html.
= = (C) Copyright 2005-2006 Julian Hyde and others.
= = All rights Reserved.
= = You must accept the terms of the, agreement to use this software.
-
<DataSources>
<!--
A data source is a collection of logically related Mondrian
Catalogs.
The XMLA specification allows an XMLA provider to has
Multiple data sources, but some clients, particularly ones
Based on adomd.net such as Simba ' s o2x client and Pentaho
Spreadsheet Services, can only connect to the first declared
Data source. Therefore, we recommend that's a single
Data source, containing multiple catalogs if necessary.
-
<DataSource>
<!--
Name of the data source.
-
<DataSourceName>Provider=Mondrian;DataSource=Cost;</DataSourceName>
<!--
Description of the data source.
-
<datasourcedescription>cost Data warehouse</datasourcedescription>
<!--
The URL of the servlet.
-
<URL>http://localhost:8080/mondrian/xmla</URL>
<!--
Mondrian connect string for the data source. If this data
Source contains multiple catalogs, omit the ' Catalog '
property, and specify the URI of the Schema.xml file in
The catalog ' s <Definition> element.
Catalogs can override the connect string with their own
<DataSourceInfo> element.
-
<DataSourceInfo>Provider=mondrian; jdbc=jdbc:mysql://localhost/costaccount?user=root& #38;p Assword=haidong; Catalog=/web-inf/queries/costschema.xml; Jdbcdrivers=com.mysql.jdbc.driver;</datasourceinfo>
<!--
Provider name must be ' Mondrian '.
-
<ProviderName>Mondrian</ProviderName>
<!--
Provider type must be ' MDP '.
-
<ProviderType>MDP</ProviderType>
<!--
Authentication mode. Allowable values are
' Unauthenticated ', ' authenticated ', ' Integrated '.
-
<AuthenticationMode>Unauthenticated</AuthenticationMode>
<!--
A data source contains one or more catalogs.
-
<Catalogs>
<!--
Catalog names must match the name inside the
Schema.xml file, and must is unique across all data
Sources defined in this Datasources.xml file.
-
<catalog name= "Incomestatement" >
<!--
Mondrian connect string for the data source. This
element is optional; If specified, it overrides the
Data source ' s <DataSourceInfo> element. Typically,
You would use this element if the catalogs has
Different JDBC data sources.
-
<!--
<DataSourceInfo>Provider=mondrian; Jdbc=jdbc:odbc:mondrianfoodmart; Jdbcdrivers=sun.jdbc.odbc.jdbcodbcdriver</datasourceinfo>
-
<!--
URI of the schema definition file.
-
<Definition>/WEB-INF/queries/CostSchema.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
</DataSources>
Datasource.xml Configuration in Mondrian