mondrain不同数据库的连接方法

• • FoodmartJdbcURL

    public final transient StringProperty FoodmartJdbcURL

    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

转载于:https://www.cnblogs.com/zzw1787044/p/4204211.html