Hitachi Vantara Pentaho Community Wiki
Legacy BI Server Documentation
Child pages
  • 03. Configure the Sample Data
Skip to end of metadata
  • Created by user-d22f7, last modified by user-ac0ac on Nov 25, 2008
Go to start of metadata



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:

  1. Grab the file from our subversion repostitory at svn://source.pentaho.org/svnroot/legacy/pentaho-data/trunk/mysql5/SampleDataDump_MySql.sql
  2. Then import the file into mysql like so: mysql> source c:/SampleDataDump_MySql.sql


  • No labels

10 Comments

  1. user-eed46

    nevermind.

  2. Anonymous

    there is no file pentaho_data-<version>.zip for version 1.6.0

  3. user-bef2c

    Changed package name to pentaho_sample_data-<version>.zip

  4. 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)

  5. 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?

  6. 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.

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

  8. 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

  9. 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

  10. 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,