Mysql--Pentaho how to export the data from MySQL and import into HANA Database

This document is for the introduction of the basic function of Pentaho and how to export the data from MySQL and import into HANA Database.

 下载地址参照：（30天试用）http://www.pentaho.com/download

Before Start

You need to copy the jar files of database connector for both MySQL and HANA DB to the library folder of Pantaho before we start this ETL tool. Here is the list:

 

1. MySQL: mysql-connector-java-5.1.28-bin.jar

You may download the file from MySQL official website.

http://dev.mysql.com/downloads/connector/j/

 

2. Hana DB: ngdbc.jar

You could find this file in the directory of you SAP HANA Studio:
\%HANA Studio%\configuration\org.eclipse.osgi\bundles\2000\1\.cp\lib

 

3. Target folder:  \%pentaho%\design-tools\data-integration\lib

 

Open Pentaho and create a transformation

1. Open “Data Integration”.

2. Click “Cancel”.

3. Now the “Spoon” is open.

4. Create a new Transformation.

5. Now you could drag and drop the components from Design panel.

 

Create Inputs

1. Drag and Drop “Table input” component to the design panel.