Datasource.xml Configuration in Mondrian

Source: Internet
Author: User

<?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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.