mondrain不同数据库的连接方法

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

Sybase

ondrian­.­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