Monday, May 28, 2007

Setting up Mondrian's FoodMart example

So I tried to setup Mondrian's example data mart. It is included in the distribution and referred to by the documentation. It supports various databases, which means it's a Java program, rather than an SQL file. The program creates does all the DDL and then populates it with sample data.



Unfortunately, none of the documentation provides actual working details on how to run that program. After about an hour of screaming at my keyboard, the following command emerged and did the job:



C:\Pentaho\mondrian-2.3.2.8944>java -cp ../workbench-2.3.2.9247/drivers/mysql-connector-java-3.1.14-bin.jar;../workbench-2.3.2.9247/lib/eigenbase-properties.jar;../workbench-2.3.2.9247/lib/eigenbase-resgen.jar;../workbench-2.3.2.9247/lib/eigenbase-xom.jar;lib/mondrian.jar;../workbench-2.3.2.9247/lib/log4j-1.2.12.jar mondrian.test.loader.MondrianFoodMartLoader -tables -data -indexes -jdbcDrivers=com.mysql.jdbc.Driver -inputFile=demo/FoodMartCreateData.sql -outputJdbcURL="jdbc:mysql://dbtest/foodmart?user=user&password=blah"

Java is a lovely system.

No comments: