> I'm trying to test Pentaho on Firebird running on my Ubuntu workstation, following this blog:
> http://interestingittips.wordpress.com/2011/04/27/complete-pentaho-installation-on-ubuntu-part-1/
> In the second part you create a set of permanent schemas, instead of ram based original Pentaho's sample.
> I've already created hibernate, quartz and steelwheels example schemas, they are the simplest part, but foodmart (the Mondrian sample db) is huge to reformat from MySql.
>
> I've almost done in DDL scripting, but to convert all INSERT from MySql dump format IMHO the only viable solutions are:
> - writing a PHP script to populate database.
> - asking an existent backup.
>
> Are there someone that has a populated firebird foodmart database in trasportable backup format?

I'm not sure if this still applies, but check out my old (nearly 4
years, wow time flies) blog post on Mondrian with Firebird, especially
step 3:

http://blog.upscene.com/thomas/index.php?entry=entry080812-144814



--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/