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.

1 comment:

Anonymous said...

Casino Review, Slots, Mobile & More
Casino 메리트카지노 Reviews – Play at online casinos with the most popular games: roulette, blackjack, live casino, baccarat, live jeetwin casino. The site 메리트카지노 has a large selection of