mondrain配置mysql_mondrain不同数据库的连接方法

Property containing the JDBC URL of the FoodMart database. The default value is to connect to an ODBC data source called "MondrianFoodMart".

To run the test suite, first load the FoodMart data set into the database of your choice. Then set the driver.classpath, mondrian.foodmart.jdbcURL and mondrian.jdbcDrivers properties, by un-commenting and modifying one of the sections below. Put the JDBC driver jar into mondrian/testlib.

Here are example property settings for various databases.

Derby: needs user and password

mondrian.foodmart.jdbcURL=jdbc:derby:demo/derby/foodmart

mondrian.foodmart.jdbcUser=sa

mondrian.foodmart.jdbcPassword=sa

mondrian.jdbcDrivers=org.apache.derby.jdbc.EmbeddedDriver

driver.classpath=testlib/derby.jar

FireBirdSQL

mondrian.foodmart.jdbcURL=jdbc:firebirdsql:localhost/3050:/mondrian/foodmart.gdb

mondrian.jdbcDrivers=org.firebirdsql.jdbc.FBDriver

driver.classpath=/jdbc/fb/firebirdsql-full.jar

Greenplum (similar to Postgres)

mondrian.foodmart.jdbcURL=jdbc:postgresql://localhost/foodmart?user=gpadmin&password=xxxx

mondrian.foodmart.jdbcUser=foodmart

mondrian.foodmart.jdbcPassword=foodmart

mondrian.jdbcDrivers=org.postgresql.Driver

driver.classpath=lib/postgresql-8.2-504.jdbc3.jar

LucidDB (see instructions)

mondrian.foodmart.jdbcURL=jdbc:luciddb:http://localhost

mondrian.foodmart.jdbcUser=foodmart

mondrian.jdbcDrivers=org.luciddb.jdbc.LucidDbClientDriver

driver.classpath=/path/to/luciddb/plugin/LucidDbClient.jar

Oracle (needs user and password)

oracle.home=G:/oracle/product/10.1.0/Db_1

mondrian.foodmart.jdbcURL.oracle=jdbc:oracle:thin:@//host:port/service_name

mondrian.foodmart.jdbcURL=jdbc:oracle:thin:foodmart/foodmart@//stilton:1521/orcl

mondrian.foodmart.jdbcURL=jdbc:oracle:oci8:foodmart/foodmart@orcl

mondrian.foodmart.jdbcUser=FOODMART

mondrian.foodmart.jdbcPassword=oracle

mondrian.jdbcDrivers=oracle.jdbc.OracleDriver

driver.classpath=/home/jhyde/open/mondrian/lib/ojdbc14.jar

ODBC (Microsoft Access)

mondrian.foodmart.jdbcURL=jdbc:odbc:MondrianFoodMart

mondrian.jdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver

driver.classpath=

Hypersonic

mondrian.foodmart.jdbcURL=jdbc:hsqldb:demo/hsql/FoodMart

mondrian.jdbcDrivers=org.hsqldb.jdbcDriver

driver.classpath=xx

MySQL: can have user and password set in JDBC URL

mondrian.foodmart.jdbcURL=jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart

mondrian.foodmart.jdbcURL=jdbc:mysql://localhost/foodmart

mondrian.foodmart.jdbcUser=foodmart

mondrian.foodmart.jdbcPassword=foodmart

mondrian.jdbcDrivers=com.mysql.jdbc.Driver

driver.classpath=D:/mysql-connector-3.1.12

Infobright

As MySQL. (Infobright uses a MySQL driver, version 5.1 and later.)

Ingres

mondrian.foodmart.jdbcURL=jdbc:ingres://192.168.200.129:II7/MondrianFoodMart;LOOP=on;AUTO=multi;UID=ingres;PWD=sergni

mondrian.jdbcDrivers=com.ingres.jdbc.IngresDriver

driver.classpath=c:/ingres2006/ingres/lib/iijdbc.jar

Postgres: needs user and password

mondrian.foodmart.jdbcURL=jdbc:postgresql://localhost/FM3

mondrian.foodmart.jdbcUser=postgres

mondrian.foodmart.jdbcPassword=pgAdmin

mondrian.jdbcDrivers=org.postgresql.Driver

Neoview

mondrian.foodmart.jdbcURL=jdbc:hpt4jdbc://localhost:18650/:schema=PENTAHO;serverDataSource=PENTAHO_DataSource

mondrian.foodmart.jdbcUser=user

mondrian.foodmart.jdbcPassword=password

mondrian.jdbcDrivers=com.hp.t4jdbc.HPT4Driver

driver.classpath=/some/path/hpt4jdbc.jar

Netezza: mimics Postgres

mondrian.foodmart.jdbcURL=jdbc:netezza://127.0.1.10/foodmart

mondrian.foodmart.jdbcUser=user

mondrian.foodmart.jdbcPassword=password

mondrian.jdbcDrivers=org.netezza.Driver

driver.classpath=/some/path/nzjdbc.jar

Sybase

mondrian.foodmart.jdbcURL=jdbc:jtds:sybase://xxx.xxx.xxx.xxx:port/dbName

mondrian.foodmart.jdbcUser=user

mondrian.foodmart.jdbcPassword=password

mondrian.jdbcDrivers=net.sourceforge.jtds.jdbc.Driver

driver.classpath=/some/path/jtds-1.2.jar

Teradata

mondrian.foodmart.jdbcURL=jdbc:teradata://DatabaseServerName/DATABASE=FoodMart

mondrian.foodmart.jdbcUser=user

mondrian.foodmart.jdbcPassword=password

mondrian.jdbcDrivers=com.ncr.teradata.TeraDriver

driver.classpath=/some/path/terajdbc/classes/terajdbc4.jar

Vertica

mondrian.foodmart.jdbcURL=jdbc:vertica://xxx.xxx.xxx.xxx:port/dbName

mondrian.foodmart.jdbcUser=user

mondrian.foodmart.jdbcPassword=password

mondrian.jdbcDrivers=com.vertica.Driver

driver.classpath=/some/path/vertica.jar

Vectorwise

mondrian.foodmart.jdbcURL=jdbc:ingres://xxx.xxx.xxx.xxxport/dbName

mondrian.foodmart.jdbcUser=user

mondrian.foodmart.jdbcPassword=password

mondrian.jdbcDrivers=com.ingres.jdbc.IngresDriver

driver.classpath=/some/path/iijdbc.jar