#Idatabase 3.17 install
#Idatabase 3.17 plus

#Idatabase 3.17 install

To use you can use the Desktop Tools Schema-Workbench and Aggregation-Designer ( here is an excelent tutorial by Diethard Steiner), but for the Pentaho-Server you will need to install jPivot4J from the marketplace as jpivot or Saiku cannot read it. Create the Analisys Data Source for the FoodMart model:.After you create both data sources, click Cancel to return to the Data Source Dialog. Repeat for AdventureWorks just change name and Database: adventureworks.į. Click Test and it should report a succesfull connection, click Ok.Į. User name: pentaho_user password: password.ĭ. Name: FoodMart Select Type: MySql Host: localhost Database: foodmart

#Idatabase 3.17 plus

Create ( plus sign icon) a new Connection: FoodMart. Name the Datasource and type: FoodMart, Database.

Create a JDBC Data Source for each Database:ī.

Click at the left top menu: File → Manage Data Sources.

We will use the FoodMart file in next section.

For new datasources, add (You can define it also in the web app if you like)įoodMart/url=jdbc:mysql://localhost:3306/foodmartĪdventureWorks/driver=ĪdventureWorks/url=jdbc:mysql://localhost:3306/adventureworksĭownload the FoodMart mondrian (snowflake schema) here and unzip them.

Go to ~/Pentaho8/pentaho-server/pentaho-solutions/system/simple-jndi.

Mysql -u root-user -p root-password < foodmart_mysql.sqlĮcho 'grant all on adventureworks.* to identified by 'password' `' | mysql -u root-user -p root-passwordĮcho 'grant all on foodmart.* to identified by 'password' ' | mysql -u root-user -p root-password II. mysql -u root-user -p root-password < AWBackup.sql Upload them to your MySql database and grant access to pentaho_user. You need to add this line on the top of FoodMart file: CREATE DATABASE IF NOT EXISTS foodmart USE foodmart AdventureWorks is a relational database and FoodMart is a Data Wharehouse database.ĭownload them and Unzip them. The classic databases for learnimg SQL and MDX are AdventureWorks (OLTP) and FoodMart (DW). So I looked up the links to recreate two additional databases in MySQL for you to use. Well, at least that what crossed my mind when I started using these tools. But you may want to model metadata* or mondrian from scratch, require more rows in your tables, or want to replicate lots of samples that refer to the Microsoft Server. The Pentaho Demo comes with SampleData (SteelWheels based) HSQLDB that will suffice for modeling and learning all the Pentaho tools.