Skip to content

4.1 Data Integration Pentaho Kettle

Bocher edited this page Apr 10, 2015 · 2 revisions

We present a method to connect H2GIS to PENTAHO KETTLE ETL.

Step 1 : Install KETTLE

Download http://community.pentaho.com/projects/data-integration/ and install it.

Step 2 : Copy H2GIS librariries

Download the last H2GIS libraries available on http://www.h2gis.org. Unzip the folder and copy all jars in KETTLE lib folder. Don't forget to remove the current h2 driver.

Step 3 : Run KETTLE

Run the spoon.sh if you are on linux or bat on Windows.

SPON

Step 4 : Create a New Transform

To create a new transform, right-click New in the context menu.

CREATE TRANSFORMATION

Step 5 : Create New Database Connection

Go to the menu Tools > Wizard > Create database connection. It will bring up a pop-up window to connect to a new database.

Select the database name and type as shown below and press Next.

DATABASE CONNECTION

Step 6 : Specify the database parameters

Specify the JDBC connection’s URL and the name of the driver class as shown below. Don't forget to add it to your database path ;-)

DATABASE PARAMETERS

Step 7 : Set the Username and Password

Specify your username and password as shown below.

DATABASE USER

Step 8 : Enjoy

As the last figure shows, H2GIS is now avalaible in KETTLE. Enjoy and read the KETTLE documentation.

PLAY