Importing H2 database in RapidMiner 5

Hi! Here's the configuration to import your H2 database in Rapidminer:

1. Add the H2 driver to RapidMiner: Go to 'Manage Database Drivres' and configure it is follows: (The Jar file lies in the /bin folder of your H2 installation; give its path). Save these settings
   
   
   
   
   
   
   
   
   
   
   
2. Now go to your process window in RapidMiner and drag the 'ReadDatabase' operator:

3. Click on it and add attribute values as shown in the image:
(database url is the complete url of your embedded database file). The default username in H2 is 'sa' without password. But, this won't work for RapidMiner since its mandatory to give some password. So, Create a new user with some password using the 'CREATE USER' sql command. In my case, I created a new database user called 'user1'.

4. Once this is done, restart RapidMiner for changes to take place. Do not forget to save your process when RapidMiner prompts you to.

5. Now, Click on Build SQL Query. You'll see something like what is shown on left. Select the table you want to read (just click on the name of the table and the select * query will be generated) and click OK