This is simple. Download and unpack the pentaho_sample_data-<version>.zip that you can find on Sourceforge.
In the root of the exploded tree, you should see a startup and a shutdown script. To start the database server, run the start-hypersonic (.bat for Windows, .sh for *nix) script. To stop the database server, run the stop-hypersonic (.bat for Windows, .sh for *nix) script.
A suggested directory layout is below:
/pentaho
/appserver
/pentaho-data
/pentaho-solutions
If you will be building an archive for MySQL, you will need to create databases and users, and you will have to import the sample data. We provide a sample sql file that does all of that:
- Grab the file from our subversion repostitory at svn://source.pentaho.org/svnroot/legacy/pentaho-data/trunk/mysql5/SampleDataDump_MySql.sql
- Then import the file into mysql like so: mysql> source c:/SampleDataDump_MySql.sql
10 Comments
user-eed46
nevermind.
Anonymous
there is no file pentaho_data-<version>.zip for version 1.6.0
user-bef2c
Changed package name to pentaho_sample_data-<version>.zip
Anonymous
Sample SQL file doesn't work :
ERROR 1064: You have an error in your SQL syntax near 'collate latin1_general_cs default NULL,
CONTACTLASTNAME varchar(50) collate l' at line 3
Query OK, 0 rows affected (0.00 sec)
user-985a5
I Want to put this deploy in a production enviroment... but.. builds always are related with sample data, the fact is that I do not want sample data DB or SampleData DS. I have nothing related to sample data in my solution repository, neither in DB but if I enter adhoc reporting online, appears a couple of samples, that finally gives a logical error because I do not have sample data installed.
any suggestions?
Anonymous
You may have some trouble in MySQL if you don't have InnoDB setup. There also may be some tables missing from earlier versions of scripts. You may build a MySQL Repository from Hypersonic to get all of the tables you need.
Anonymous
Hi, I could not get the file: svn://source.pentaho.org/svnroot/pentaho-data/trunk/mysql5/SampleDataDump_MySql.sql, it says: "Error * Can't connect to host 'source.pentaho.org': A socket operation was attempted to an unreachable network.", so how and where can I get the sql file for Mysql?
Thanks
Dave
Anonymous
also I am using Tomcat 6, I like to deploy pentaho.war under c:\Tomcat 6\webapps, then Tomcat will created a pentaho folder under the webapps as c:\Tomcat 6\webapps\pentaho, so where should I put pentaho-data folder and pentaho-solutions folder? should be in parallel with webapps?
Thanks
Dave
Anonymous
You can find the MySQL Sample Data Dump by clicking on the following link
http://source.pentaho.org/svnroot/bi-platform-v2/trunk/bi-platform-sample-data/mysql5/SampleDataDump_MySql.sql\\
Regards,
Arun
Anonymous
I have found the sample data, is in this page:
http://sourceforge.net/project/showfiles.php?group_id=140317&package_id=160028\\
Best regards,